An Alternative to Using an Oracle BI Publisher Data Table for a One Line Table

Brian BurdiOracle, Technical TipsLeave a Comment

An Alternative to Using an Oracle BI Publisher Data Table for a One Line Table

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

An Analysis Design that will Allow Users to Create Custom Reports in OBIEE

Brian BurdiOracle, Technical TipsLeave a Comment

An Analysis Design that will Allow Users to Create Custom Reports

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

Is Oracle’s Vision Corp Guilty of Gender Inequality? An OBIEE Analysis to Investigate Reports

Brian BurdiCase Studies, Industry Trends, Oracle, Technical TipsLeave a Comment

gender-inequality-in-the-workplace

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 11.1.1.6.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

Joining Oracle E-Business Suite HRMS Tables in Oracle SQL Developer

Shannon MiskevicsOfferings, Oracle, Technical TipsLeave a Comment

Joining Oracle E-Business Suite HRMS Tables in Oracle SQL Developer

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

Understanding the Core Oracle E-Business Suite HRMS Tables

Shannon MiskevicsOracle2 Comments

Understanding the Core Oracle E-Business Suite HRMS Tables

There are hundreds of tables in Oracle E-Business Suite HRMS, but some are used more frequently than others. When querying, it is important to not only know the common tables that are used, but also to understand how the tables link together. Some of the common tables are listed below. Common HRMS Tables The chart above shows some of the most common tables that are used in Oracle HRMS. Often, a column in one table will link to a column in a different table. For example, the primary key PERSON_ID in the PER_ALL_PEOPLE_F table will link to the foreign key … Read More

Everything You’ve Ever Wanted to Know About HR Date-Tracking in Oracle EBS

Shannon MiskevicsOracle, Technical TipsLeave a Comment

Calendar

Date-tracking is an original function through Oracle E-Business Suite (EBS) Human Capital Management (HCM). This function allows companies to edit their employees’ information and create continuity between different records. Date-tracking is an important function in EBS HCM, especially when it comes to changing employee person status, job position, etc. Correction and Update For this example, Jim Jones started as a Sales Consultant. To change information after it is entered so that instead Jim is married, use the correction function. When correcting an entry, it overrides the previous record with the error and replaces it with the new information. Therefore now it … Read More

Customizing the Auto-Complete Prompt Functionality in OBIEE 11.1.1.6

Brian BurdiOracle, Technical TipsLeave a Comment

paint-brush-on-wooden-artistic-pallette

There are some features that the auto-complete prompt functionality has. It can be turned on and off by either the user or the dashboard designer and the administrator can change different parameters in the code that was implemented to help meet the business’s needs. Turning off auto-complete on the dashboard level: Edit Dashboard and select Dashboard Properties: There will be an option to turn the Auto-Complete off:   Turning off auto-complete on the user level: Click on the user name -> My Account: Under Preferences the user can turn the Auto-Complete off:   [divider scroll_text=””] The administrator can configure the … Read More