Our Big Data Team, here at M&S, packed up their bags and headed to San Francisco last week for the 2015 Oracle Business Intelligence Warehousing and Analytics Summit. Some of the major topics discussed included: Internet of Things (IoT), Big Data, and Advanced Analytics. The Internet of Things (IoT) is at the peak of Gartner’s Hype Cycle. It is becoming increasingly talked about and there are predictions of billions and billions of sensors by 2020. But what exactly is IoT? IoT involves embedded computing devices interconnected with existing internet infrastructure, such as, wearables and connected cars. Why the hype right … Read More
The Challenge Managers of Oracle E-Business Suite HCM applications may wish to implement a business rule that prohibits employees from taking leave that exceeds their balance (ie result in a negative leave balance). Until now, E-Business Suite has not provided an easy way to implement that business rule, rather, users needed to write custom code for the ‘BG_ABSENCE_DURATION’ fast formula. For many users these seemed overly complicated. The Solution Beginning with E-Business Suite R12.1.3, following the simple steps below, Oracle has provided a profile option that can be set to prevent employees from taking leave that exceeds their balance. Authenticate … Read More
When creating a one line table in Oracle BI Publisher using a Data Table, it will give you redundant filtering options on the titles of the table and an unnecessary subtotal at the end of the table if there is a fact in the table. Instead, we would like to have a similar table but without the filters and the subtotal. To do this we will add a Layout Grid to the dimensions that we have predefined. This will give the overall BI Publisher report a much cleaner look by removing two of the features of the data table. … Read More
Recently, I have been toying with the idea of having an OBIEE report that would allow the users to customize which columns would be shown in a particular report. This idea was going to be hard to execute because allowing users to customize the report that they would want to see on a dashboard would require the XML driving the analysis to change dynamically. A solution to this problem will not give the user 100% control of which columns are added to a report but it will allow them to have more control creating a report that they’re interested in. … Read More
Allegations of Vision Corporation’s activity in gender salary discrimination is something that Oracle’s Vision Corp takes very seriously and have been generous enough to open up all of their information for independent analysis by the public. We will begin an investigation of their full time employee’s salary information to see if the allegations of gender salary discrimination are prevalent in this corporation. We will be using OBIEE 220.127.116.11.0 to investigate. The first thing we will look at is a generated table and pie chart that calculates the number of employees by their gender. We can see that there is a … Read More
JOINS In SQL Developer, JOINS are used to relate information in different tables. A JOIN condition retrieves data from two or more tables. It is performed in the WHERE clause of the select statement. There are multiple types of SQL joins, but this post is going to be focusing on the OUTER JOIN. SYNTAX The (+) operator can be on either the right or left side of the join condition. The side the operator needs to be on depends on whether “Nulls” need to be included from that table. Using the first SQL JOIN, the results would return all the … Read More
M&S is excited to be the Principle Sponsor for the Pittsburgh OAUG Annual Golf Outing. We hope you’ll join us for a fun morning of Golf, Food, and Prizes on August 15th. We play a Par Quota Scramble held at Buffalo Golf Course, where you can enjoy “one of the best golfing experiences in the Pittsburgh area.” There will be a 9am shotgun start, so please join us early on the course at 8am. The cost is $40 per person or $160 per foursome. For registration information visit the PittOAUG website and download the flyer today. We hope to see you out there!