Wednesday, May 30, 2012

Are you smarter than an RPD Administrator?

Prove it!

How well do you know the OBIEE 11g Administration tool?   Are you ready to put your knowledge to the test?   How about to three tests?   Below you will find links to three online exams to test your RPD skills.   Tests 1 and 2 are 50 questions each.  Test 3 has 33 questions.     There is no time limit for taking the test and you can take it as many times as you would like.   The passing score has been set to 80%.

The only requirement for taking the exams is to create an account with quizegg.com.   

And how about making it worth your while?   Every person who takes any of the exams will be entered into a drawing to win one of four  $25 Amazon gift cards.  One entry per exam taken.    Every person who receives a passing score will receive an additional entry for each passing score.    And if you pass all three exams, you will receive an additional entry - seven possible entries total.

Drawing will be held on July 1, 2012 for all entries received by June 30, 2012.

OBIEE RPD Quiz 1:   http://quizegg.com/q/62269
OBIEE RPD Quiz 2:   http://quizegg.com/q/62396
OBIEE RPD Quiz 3:   http://quizegg.com/q/62397

Note: this quiz covers version of OBIEE - 11.1.1.6

Monday, May 21, 2012

COMPA Ratio Metric in HR Analytics

One of the key metrics in Oracle's HR Analytics in the Compensation subject area is Compa Ratio.   This metric is an industry standard measurement of where an employee's salary fits as compared to other employees in the same pay grade.  

In HR Analytics, the calculation is based on two logical columns:

 CASE  WHEN "Core"."Fact - HR - Operation (Workforce)"."Pay Grade Mid Yearly Amount" <> 0 THEN "Core"."Fact - HR - Operation (Workforce)"."Total Annual Base Salary" / "Core"."Fact - HR - Operation (Workforce)"."Pay Grade Mid Yearly Amount" END 

The physical columns for the calculation are:


Notice that the calculation can be sourced from either the aggregate table, W_WRKFC_BAL_A for the salary component or from the W_WRKFC_EVT_MONTH_F table depending on the columns selected in the Answers analysis.

Also note that the metric is based on global currency so the expectation would be that the Pay Grade Mid Yearly Amount would be stored in global currency as well.



.

Wednesday, May 16, 2012

Bug in SDE_PSFT_InternalOrganizationDimension_DepartmentHierarchy_Derive


The delivered mapping SDE_PSFT_InternalOrganizationDimension_DepartmentHierarchy_Derive has a bug in it where it is incorrectly mapping the column W_INT_ORG_DHS.ORG_HIER12_NUM to the wrong column. 
Relevant area of the mapping is shown here:

ORG_HIER12_NUM is connected to port L13_NODE_LABEL (the L13 is correct even though it is connected to HIER12).

If you look at the surrounding port expressions around L13_NODE_LABEL, you will see that they are all in pairs of VAR_LXX_NODE_LABEL and :LKP_W_PSFT_INT… but for L13_NODE_LABEL, it has :LKP instead of VAR.

So the fix is to change the expression on L13_NODE_LABEL to: