OBIEE 11g Online Quizzes Available - 1z0-591 certification study material

We have created several online quizzes related to the OBIEE 11g environment.   All of the quizzes are free and only require creating an account with Quizegg.com to access them.   No personal information is collected.   

If you can pass these quizzes, you should have no difficulty passing the:

1Z0-591  Oracle Business Intelligence Foundation Suite 11 Essentials

certification exam.

Oracle OBIEE Answers Quiz 1
Oracle OBIEE Answers Quiz 2
Oracle OBIEE RPD Quiz 1
Oracle OBIEE RPD Quiz 2
Oracle OBIEE RPD Quiz 3
Oracle OBIEE DAC Administration Quiz
Oracle OBIEE 11g Security
Oracle BI Applications Implementation
Oracle BI Peoplesoft HR Applications Implementation


Please contact doug.ross@hcminsight.com with any questions or comments about the quizzes.  

Mapping Ceridian HR to OBIEE HR Analytics

The typical implementation of Oracle's Business Intelligence Human Resources Analytics Application is structured around either Peoplesoft or Oracle E-Business Suite data.   However, we recently completed a project where the source system was Ceridian's Human Capital Management application.

Because of the architecture of the BI applications, it is only necessary to configure the Source Dependent Extract (SDE) Informatica mappings and then allow the standard out-of-the-box Source Independent Load and Post Load Processing mappings to handle populating the Business Analytics Warehouse target tables.

For this project, we were able to successfully map standard HR dimensions like:

• Employee (W_EMPLOYEE_D)
• Job (W_JOB_D)
• Department (W_INT_ORG_D)
• Pay Type (W_PAY_TYPE_D)
• Pay Grade (W_PAY_GRADE_D)

As well as two fact tables:

• Workforce Event  (W_WRKFC_EVT_MONTH_F)   - Includes Events and Headcount Snapshots
• Payroll (W_PAYROLL_F)

 For further information on mapping Ceridian HR to Oracle HR Analytics, contact us at hcminsight@hcminsight.com.



Sample  SQL used in the SDE mapping for Payroll which extracts data from the Ceridian source:

SELECT
'EARNINGS' as TYPE,
Ebflxid as EMPLOYEE_ID,
jbpaygrade as PAY_GRADE_ID,
EeCategory+'~'+ Eestatus+'~'+ jbflsa as EMPLOYMENT_ID,
EjCompany as COMPANY_ORG_ID,
EjJobcode as JOB_ID ,
EjLocation as EMP_LOC_ID,
EjDepartment as HR_BUSINESS_UNIT_ID,
EjCompany as EMP_HR_ORG_ID ,
CsePayTypeCode as PAY_TYPE_ID,
CsePayTypeLong,
null as EMP_POSTN_DH_ID,
CsuDateBeg as PAY_CHECK_DT,
CsuPayPeriod as PAY_PERIOD_START_DT,
null as PAY_PERIOD_END_DT,
null as PAY_EARN_START_DT,
null as PAY_EARN_END_DT,
'Y' as PAY_DETAIL_FLG,
CseCurrErngs as PAY_ITEM_AMT,
'N' as DELETE_FLG,
'N' as REJECT_FLG,
'USD' as DOC_CURR_CODE,
'USD' as LOC_CURR_CODE,
'1' as LOC_EXCH_RATE_TYPE,
'1' as LOC_EXCHANGE_RATE,
GETdate() as EXCHANGE_DT,
convert(varchar,csuflxideb) +'~'+ convert(varchar,CsuDateBeg)
+'~'+convert(varchar,CsePayTypeCode)+'~'+ convert(varchar,CsuCheckno)
 as INTEGRATION_ID,
CsuCheckno as X_CHECK_NUM,
CsuPayPeriod as X_PAY_PERIOD

FROM
Ebase, CheckSumm, CheckSummHE,Eemploy,Ejob,jobcode
WHERE
Ebflxid = ejflxideb and
Ebflxid = eeflxideb and
Ebflxid = csuflxideb and
CsuFlxid = CseFlxIDCsu and
EjJobcode=Jbjobcode and
ebflagemp='y'
--and  Ebflxid=55704
--and  CsuPayPeriod=2011200
-- and (csudatebeg BETWEEN '01/01/2012' and '01/31/2012')

and (
(EjDateBeg <= CsuDateBeg AND
(EjDateEnd >= CsuDateBeg OR EjDateEnd IS NULL))
AND(EeDateBeg <= CsuDateBeg AND
(EeDateEnd >= CsuDateBeg OR EeDateEnd IS NULL))
 and   EeStatus <> 'Terminated'
 OR
(eedatebeg<=CsuDateBeg and
(eedateend>=CsuDateBeg or eedateend is null)) and
Ejdateend = eetermdate)

union

SELECT
'DEDUCTIONS' as TYPE,
Ebflxid as EMPLOYEE_ID,
jbpaygrade as PAY_GRADE_ID,
EeCategory+'~'+ Eestatus+'~'+ jbflsa as EMPLOYMENT_ID,
EjCompany as COMPANY_ORG_ID,
EjJobcode as JOB_ID ,
EjLocation as EMP_LOC_ID,
EjDepartment as HR_BUSINESS_UNIT_ID,
EjCompany as EMP_HR_ORG_ID ,
CsdDedCode as PAY_TYPE_ID,
CsdDedDesc,
null as EMP_POSTN_DH_ID,
CsuDateBeg as PAY_CHECK_DT,
CsuPayPeriod as PAY_PERIOD_START_DT,
null as PAY_PERIOD_END_DT,
null as PAY_EARN_START_DT,
null as PAY_EARN_END_DT,
'Y' as PAY_DETAIL_FLG,
CsdDedCurr as PAY_ITEM_AMT,
'N' as DELETE_FLG,
'N' as REJECT_FLG,
'USD' as DOC_CURR_CODE,
'USD' as LOC_CURR_CODE,
'1' as LOC_EXCH_RATE_TYPE,
'1' as LOC_EXCHANGE_RATE,
GETdate() as EXCHANGE_DT,
convert(varchar,csuflxideb) +'~'+ convert(varchar,CsuDateBeg) +'~'
+convert(varchar,CsdDedCode)+'~'+ convert(varchar,CsuCheckno)

as INTEGRATION_ID,
CsuCheckno as X_CHECK_NUM,
CsuPayPeriod as X_PAY_PERIOD
FROM
Ebase, CheckSumm, CheckSummDed,Eemploy,Ejob,jobcode
WHERE
Ebflxid = ejflxideb and
Ebflxid = eeflxideb and
Ebflxid = csuflxideb and
CsuFlxid = CsdFlxIDCsu and
EjJobcode=Jbjobcode and
ebflagemp='y'
--and  Ebflxid=55704 
--and  CsuPayPeriod=2011200
-- and (csudatebeg BETWEEN '01/01/2012' and '01/31/2012')
and (
(EjDateBeg <= CsuDateBeg AND
(EjDateEnd >= CsuDateBeg OR EjDateEnd IS NULL))
AND(EeDateBeg <= CsuDateBeg AND
(EeDateEnd >= CsuDateBeg OR EeDateEnd IS NULL))
 and   EeStatus <> 'Terminated'
 OR
(eedatebeg<=CsuDateBeg and
(eedateend>=CsuDateBeg or eedateend is null)) and
Ejdateend = eetermdate)

UNION

SELECT
'TAX' as TYPE,
Ebflxid as EMPLOYEE_ID,
jbpaygrade as PAY_GRADE_ID,
EeCategory+'~'+ Eestatus+'~'+ jbflsa as EMPLOYMENT_ID,
EjCompany as COMPANY_ORG_ID,
EjJobcode as JOB_ID ,
EjLocation as EMP_LOC_ID,
EjDepartment as HR_BUSINESS_UNIT_ID,
EjCompany as EMP_HR_ORG_ID ,
CsxshortDesc as PAY_TYPE_ID,
CsxshortDesc,
null as EMP_POSTN_DH_ID,
CsuDateBeg as PAY_CHECK_DT,
CsuPayPeriod as PAY_PERIOD_START_DT,
null as PAY_PERIOD_END_DT,
null as PAY_EARN_START_DT,
null as PAY_EARN_END_DT,
'Y' as PAY_DETAIL_FLG,
CsxCurrTax as PAY_ITEM_AMT,
'N' as DELETE_FLG,
'N' as REJECT_FLG,
'USD' as DOC_CURR_CODE,
'USD' as LOC_CURR_CODE,
'1' as LOC_EXCH_RATE_TYPE,
'1' as LOC_EXCHANGE_RATE,
GETdate() as EXCHANGE_DT,
convert(varchar,csuflxideb) +'~'+ convert(varchar,CsuDateBeg)
+'~'+convert(varchar,CsxshortDesc)+'~'+ convert(varchar,CsuCheckno)
 as INTEGRATION_ID,
CsuCheckno as X_CHECK_NUM,
CsuPayPeriod as X_PAY_PERIOD
FROM
Ebase, CheckSumm, CheckSummTax,Eemploy,Ejob,jobcode
WHERE
Ebflxid = ejflxideb and
Ebflxid = eeflxideb and
Ebflxid = csuflxideb and
CsuFlxid = CsxFlxIDCsu and
EjJobcode=Jbjobcode and
ebflagemp='y'
--and  Ebflxid=55704 
--and  CsuPayPeriod=2011200
-- and (csudatebeg BETWEEN '01/01/2012' and '01/31/2012')
and (
(EjDateBeg <= CsuDateBeg AND
(EjDateEnd >= CsuDateBeg OR EjDateEnd IS NULL))
AND(EeDateBeg <= CsuDateBeg AND
(EeDateEnd >= CsuDateBeg OR EeDateEnd IS NULL))
 and   EeStatus <> 'Terminated'
 OR
(eedatebeg<=CsuDateBeg and
(eedateend>=CsuDateBeg or eedateend is null)) and
Ejdateend = eetermdate)

The definitive manual for OBIEE developers is available now on Amazon:

Oracle Business Intelligence 11g Developers Guide by Mark Rittman

Have you ordered your copy yet?

The BP1 patch for OBIEE 11.1.1.6.2 is available on Oracle. Readme file from the patch is shown below:

 

13867143 - Patch 11.1.1.6.2 BP1 (6 of 7) Oracle Business Intelligence 
=====================================================================

Section 1: About This Patch
---------------------------
This patch is one of a number comprising the Oracle Business Intelligence 11.1.1.6.2 BP1 Patchset.

Refer to the Readme of the first patch in the patchset (Patch 14223977) to see:
* Important information that you must read before installing the patchset
* Installation and deinstallation instructions


Section 2: Patch Installation and Deinstallation Instructions
-------------------------------------------------------------
For information about installing and deinstalling this patch, refer to the Readme for Patch 14223977.


Section 3: Bugs Fixed By This Patch
-----------------------------------
6197675 PROVIDE CAPABILITY TO DOWNLOAD REPORT WITH FILTERS USING GO-URL ACTION=DOWNLOAD
9884975 11G ADMIN TOOL RECEIVES NQSERROR: 37005 WHEN SAVING ONLINE RPD CHANGES
10199188 CHARTS X AXIS LABEL IS BLURRED AT 45/60 ANGLE
10295403 EXCEL DOWNLOAD : TOTAL RULE LINES ARE MISSING
10353891 TEXT IN ANGLED BRACKETS IS MISSING FROM FILTER VIEW
10417235 LAYOUT PANE IS CORRUPTED AT TABLE VIEW EDITING.
10647655 COLUMN DATA FORMAT IS IGNORED ON WRITEBACK
11793832 MULTIPLE VALUES IN A DASHBOARD PROMPT DOESN'T WORK WITH BI PUBLISHER
11815935 NLS:THE SETTING FIRSTDAYOFWEEK IN LOCALEDEFINITIONS.XML DON'T AFFECT CALENDAR UI
12325889 SAVING A NEW REPORT TITLE VIEW IS NOT AUTOMATICALLY UPDATED WITH REPORT NAME
12355716 HTML TAGS IN OBIEE 11G REPORTS DOESN'T WORK
12391045 FUNCTION REPORT_AGGREGATE REQUIRES AT LEAST ONE MEASURE COLUMN IN ITS FIRST ARGU
12612904 TOTAL PICKS VALUE IN FIRST ROW AND GIVES NOT A NUMBER WHEN AVERAGING NULL
12638186 EXCEL EXPORT GENERATES A SPACE BEHIND ANY MEASURE VALUE WHEN USING ACTION LINK
12656913 OBI 11G ONDEMAND - DASHBOARD MENU ITEMS DISAPPEAR FROM MENU
12687758 MAPS WITH 500+ TILES TAKE TIME TO LOAD IN FIREFOX AND CHROME (IE FINE)
12696084 FORMAT HEADINGS > HORIZONTAL ALIGNMENT IS NOT WORKING IN TABLE, PIVOT VIEW IN FF
12701383 DOWNLOAD TO EXCEL INCLUDES A BLANK TEXT ROW BELOW THE LAST ROW OF DATA
12715885 HORIZONTAL ALIGNMENT WON'T WORK FOR NARRATIVE, STATIC TEXT VIEW IF EXPORT TO PDF
12725139 VARIABLE VALUES NOT RESOLVED IN TITLE/LEGEND OF CHART, SHOWS FORMULA
12728253 DRILL DOWN TO DETAIL LEVELS DOES NOT WORK FOR THIRD DIMENSION ON ROW EDGE
12776086 REPORT COLUMN SELECTOR IS NOT BEING UPGRADED PROPERLY
12787619 EXPORTED EXCEL:THE 11TH COLUMN HEADING'S FONTS INCORRECT AND LINES ARE MISSING
12807186 OPTION TO NOT SUPPRESS POPUP DOES NOT WORK WITH COLUMN SELECTOR ACTIONS
12822192 DOWNLOAD TO EXCEL WITH DATA FORMATTED COLS AND LOCALE OTHER THAN ENGLISH ISSUE
12826429 MULTIPLE-SELECT PROMPTS DO NOT APPEAR IN UPGRADED ENVIRONMENT
12905237 MAP VIEW DOES NOT FIT FILTERED LAYERS
12908486 UPGRADING 11.1.1.3 TO 11.1.1.5 GAUGE TITLES FOOTER CHANGED FROM "@1 %" TO "@0 %"
12911049 EXPORT (PDF, EXCEL, ETC.) OPTION IS NOT EXPORTING ALL ROWS OF A REPORT
12914177 DON'T SHOW NULL PROJECT_INACCESSIBLE_COLUMN_AS_NULL COLUMN IN SUBJECT AREA
12921728 DXE MAKING UNNECESSARY COPY OF DATA FOR SINGLE AXIS LAYOUTS
12952452 DEFAULT VALUE FOR COLUMN SELECTOR VIEW IS THE FIRST VALUE OF THE COLUMN LIST
12960177 ADDING CALCULATION TO THE HIERARCHY COLUMN IN SELECTION STEPS RESULTS IN ERROR
12963080 LINE BAR 3D GRAPH IS UPGRADED TO CYLINDRICAL BAR 3D GRAPHS
12977729 HIERARCHICAL COL DRILLING ON MORE THAN ONE PAGE OF RESULTS LOSES FOCUS ON DRILL
12978196 COLUMN SELECTOR DOES NOT PASS VALUES FROM SUMMARY REPORT TO DETAILED REPORT
12981896 MAPVIEWER HOVER TOOLTIPS SHOW WRONG VALUES
12992697 PAGE BREAK WITH COLUMN BREAK DOES NOT WORK IN PRINTABLE HTML
13008956 DISABLE AUTO-PREVIEWING OF RESULTS NOT WORKING
13024366 SOLARIS CRASH WHILE MODIFYING GRAPH IN ANALYTIC REPORTS
13054445 REPLACING NULL VALUES WITH "0" IN AN OBIEE PIVOT TABLE IS NOT WORKING
13062842 HORIZONTAL SCROLL BAR IS NOT DISPLAYED ON EDITING DATABASE DIRECT REQUEST
13084799 QUERIES AGAINST BISERVER NOT LEVERAGING FORWARD ONLY OPTION
13110980 THE SECTION PROPERTIES OF PIVOT TABLE IS NOT EFFECTIVE OR NOT CORRECT
13111799 GRAPHING ENGINE IS NOT RESPONDING ERROR HAPPENED.
13249783 AFTER APPLYING PATCH 129725592, OBIEE 11G THROWS BAD XML INSTANCE
13253545 ADDING A NEW GROUP SHOWS EMPTY COLUMN
13256635 VIEWUICONTAINER ERRORS FOR UPGRADED REPORTS
13256990 "NODE WADS NOT FOUND" ERROR OCCURS WHEN UPGRADE 10G CATALOG AND REPOSITORY
13258962 BI SERVER CRASHING STD::BAD_ALLOC ORA-24550 ERROR THEN RESTARTING
13331075 UNABLE TO DRAG MULTIPLE CATALOG ITEMS TO A DASHBOARD
13359653 ANALYSIS QUERY IS NOT CANCELED PROPERLY.
13366675 INAPPROPRIATE PRE-RESERVES WITH STRINGBUFFER
13370386 "THE CURRENT XML IS INVALID WITH THE FOLLOWING ERRORS: BAD XML INSTANCE!" OCCURS
13383217 QDR ISCUSTOMGROUPUNIQUEID DOES UNNECESSARY STRING CONCATENATION
13384157 LARGE SMA BUCKET SIZES NEED TO BE ALIGNED TO POWERS OF 2
13386650 DOWNLOADING INTO EXCEL WITH CONDITIONAL FORMAT BREAKS DATA FORMAT
13386728 OBIEE 11G EVALUATE FORMULA FAILS IF PARAMETERS HAS % OR /
13393602 RSUM NOT CALCULATING CORRECTLY WHEN THERE ARE EXCLUDED COLUMNS
13398245 PROMPT VALUE IS NOT PASSED ON NAVIGATION IF THE PROMPT SECTION IS COLLAPSED
13400140 MULTI-STEP PROMT MISSING THE DASHBOARD PROMPT WHICH "LIMIT VALUES BY" IS SET
13401386 AUTO PREVIEW ARE NOT PREVENTED EXCEPT PIVOT VIEW
13401775 RESET BUTTON DOES NOT CLEAR MESSAGE ABOUT WRONG DATE FORMAT
13403816 AFTER APPLIED MLR 13110245 STILL HAVING THE HIERARCHICAL PROMPT ISSUE
13405110 OPENING REPORT CRASHES BI PRESENTATION SERVICES
13409646 CALCULATED ITEMS CAUSE MANY INTERNAL CUBES WITHIN DXE
13416870 RACE CONDITION IN PRESORTED CUBE
13418590 EXPORT TO EXCEL NOT WORKING PROPERLY (LINUX 64)
13434349 "LIMIT ROWS BASED ON SECTION VALUES" PROPERTY IS NOT EFFECTIVE FOR GRAPH PIVOT
13440792 EXPORT TO EXCEL WITH REGIONAL SETTINGS OTHER THAN ENU
13444157 ERROR WHEN USE "IS IN TOP" OPERATOR IN FILTER WITH PRESENTATION VARIABLE
13447368 COLUMN FORMAT PROPERTY IS NOT SAVED
13458667 HIDDEN OPTION NOT AVAILABLE FOR DATE COLUMNS IN TABLE LAYOUT
13471332 NEW MEMBER STEP WINDOW DOESN'T FIT ALL REQUIRED MEMBER SELECTION
13477147 CREATE PROMPTED LINK CREATES A LINK WITH THE NAME OF THE VARIABLE
13479613 CANNOT MODIFY REPORT/DASHBOARD WHEN USER HAS READ-WRITE BUT NO DELETE PERMISSION
13498324 PERFORMANCE DEGRADATION FOR PARENT-CHILD HIERARCHY QUERY FROM 11.1.1.6.0
13501903 EXCEL DOWNLOAD ERRORS WITH DOUBLE QUOTES AND EMBEDDED COMMAS
13502763 DRILL DOWN ON REGULAR COLUMN WITH CUSTOM DATE FORMAT
13516292 REPOSITORY INIT BLOCKS LOSE CONNECTION TO DATABASE AND NEVER REGAIN IT
13517767 POSITIONAL CALC CAN CAUSE XMLWRITER EMPTY DOCUMENT ERROR
13522214 VALUE-BASED HIER PROMPT SEARCH RESULTS IN ODBC ERROR
13522246 DASHBOARD EMBEDDED IN IFRAME MODIFIES PORTALPATH OF SINGLETON SESSIONINFO
13523548 ERROR OUT WHEN USING MULTIPLE DOUBLE COLUMNS IN SAVED FILTERS
13526747 PIVOT CHART LEGEND DUPLICATES MEASURE LABELS.
13529441 MULTI DASHBOARD PROMPT DOESN'T WORK WITH BI PUBLISHER INTEGRATED
13533404 SECTIONS HEADERS ARE CAUSING DASHBOARD SPACING ISSUES
13539267 HIERARCHY IN PIVOT TABLE AND BAR CHARTCAUSES ERROR
13541432 PIVOT SORT BUTTON DISAPPEARS WHEN SELECT "AFTER" FROM THE TOTAL OF "COLUMNS"
13542145 UNION ERROR IN WHEN FILTERING A COLUMN THAT HAS A DESCRIPTOR ID COLUMN
13546009 SELECT PIVOT TABLE IN VIEW SELECTOR CAUSES COLUMN TO BE EXCLUDED WHEN DRILLING
13567100 CASE WHEN USED IN MEASURE IN PIVOT IS NOT WORKING AS IN 10G
13570406 MAP VIEW DOESN'T DISPLAY THE CORRESPONDING LEVEL DATA AFTER DRILL DOWN
13577428 PIVOT TABLE FORMATTING ISSUE
13585714 USING "FORMAT TITLE VIEW" IN ANSWERS- RESULTS - TITLE THROWS "INVALID XML" ERROR
13586709 GRAPH PIVOTED VIEW POSITION DOES NOT REMAIN SAME.
13599283 BRIEFING BOOK DOESNT SHOW SAVED CUSTOMIZATIONS VIA A LINK.
13605450 'MY FOLDERS' DOESN'T SHOW IN DASHBOARD EDITOR WHEN USERNAME HAS PARENTHESES
13606302 "DO NOT DISPLAY IN A POPUP" ACTION LINK INCORRECT BEHAVIOR (HIERARCHY LEVEL COL)
13615198 RIGHT CLICK INCLUDE MSR NEEDS TO ADD TO MSR BIN, NOT COLUMN.
13616593 AUTO PREVIEW ARE NOT PREVENTED FOR GRAPH
13627902 MAPS ARE PRINTED IN GREY WHEN LOG IN USING ITALIAN LANGUAGE
13641963 BACKSPACE BUTTON AFFECTS THE MAIN WINDOW INSTEAD OF POP-UP WINDOW
13647309 GRAND TOTAL FUNCTIONALITY INCORRECT AND INCONSISTENT WITH OLAP CUBES
13682411 CALC ITEM NOT DISPLAYED IN A PIVOT TABLE
13688544 'CASE WHEN' CHANGES TO 'CASEWHEN' IN XML AND CAUSES ERROR WHEN SET XML
13704274 SECURITY FILTERS ARE INCORRECTLY APPLIED TO LEVEL-BASED MEASURES
13724002 PIVOT TABLE TITLE TRANSLATING PROBLEM
13774538 GRAPH TITLE DISPLAYING VARIABLE CODE @{TESTCASE} ON EXPORTED TO PDF FILE.
13774635 OBIPS THROWING ASSERTION WHILE RUNNING THE CACHE SEEDING AGENT
13788536 GRAPH PIVOTED RESULTS PREVENTS ADDING NEW COLUMNS TO CRITERIA
13792237 ADMINTOOL CRASHES WHEN DELETING MULTIPLE PHYSICAL TABLES
13815409 MULTIPLE PIE CHARTS DISPLAYED FOR PIVOT TABLE REPORT WHEN SHOULD BE ONE
13827099 ADD ADDITIONAL ASCENDING SORT RESULTS IN ERROR
13844868 BI PRESENTATION SERVICE FAILS TO START IN PARALLEL WITH OTHER BI COMPONENTS
13897448 FILTER ON A COLUMN WITH A FOMULA CREATED BY BIN DOES NOT COMPLETE
13933009 DOUBLE COLUMN (DESCRIPTOR ID) DASHBOARD PROMPT - ENABLE SQL RESULTS ON CODE COL
13944009 INCORRECT REPORT LINK GETS GENERATED IN IE8
13946535 REFRESH ISSUE OF ALL VALUES IN FILTERDROPDOWN NOT RESIZED AND VALUES NOT VISIBLE
13963768 HIDE COLUMNS ON DASHBOARD NOT WORKING CORRECTLY
13983193 ALIAS THAT HAS AN '&' IN THE NAME CAUSES ERROR ROOT XML NODE NQW NOT FOUND
13986530 OBIEE CRASHES IF RUN MULTIPLE QUERIES CONCURRENTLY ON SAP/BW FOR THE FIRST TIME
14005093 OBIEE PRESENTATION SERVER AND JAVAHOST FAILS AFTER CONSOLE LOGOFF EVENT
14021534 MISSING PROMPT FIELD IF THE DASHBOARD PAGES CONTAIN DUPLICATE PROMPT PAGE
14025087 UNCHECK "SHOW APPLY BUTTON" CAUSE PROBLEM ON RESTRICTED DASHBOARD PROMPT COLUMN
14053994 ACTION LINKS DON'T WORK WHEN HAVING COLUMN SELECTOR AND USING CHROME




Section 4: Known Bugs With This Patch
-------------------------------------
13873434 QA:IE:UNABLE TO RENAME COMPOUND LAYOUT
14158156 MEMORY SPIKE DURING THE COMPILATION PHASE FOR QUERIES WITH LARGE EXPRESSIONS

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

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.



.

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: