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: 

Independent OBIEE Consultant Review

Are you reviewing potential consulting organizations to assist with your Oracle BI Applications implementation?  Do you know the right questions to ask to increase the probability of a successful project?  Are you placing the fate of your projects on the content contained in a resume? What would it be worth to you to have an independent assessment of candidates for the project when tens or hundreds of thousands of your budget are at stake?

We offer an independent review service that includes both a technical interview via telephone and a basic knowledge assessment exam to help improve your decision making process.    Our review process can be tailored to your specific project requirements based on your input.  Our unique OBIEE assessment test includes both a multiple choice exam and a series of written questions designed to test both depth of knowledge and written communication skills.   Following the review, we will deliver to you both a qualitative and quantitative assessment of each candidate within 24 hours. 

Our fee for an assessment is $120 per individual assessment with discounts available for five or more assessments.

Contact doug.ross@hmcinsight to discuss your requirements or to get a sample assessment review document.

Configuring Human Resurce Analytics Workforce Events WIth Peoplesoft

 When configuring Oracle's Business Intelligence Applications Human Resource Analytics using
a Peoplesoft source, one of the most important steps is the creation configuration file
domainValues_Wrkfc_EventType_psft.csv.

This files controls how rows from the PS_JOB table loaded into the data warehouse are mapped
to standard events like Hires, Terminations, Transfers, etc.

The first step in configuring the CSV is to query the Peoplesoft source to get all of the
potential Action / Reason Code combinations that may appear in the PS_JOB table.

 SELECT ACTION, ACTION_REASON, DESCR FROM PS_ACTN_REASON_TBL ORDER BY 1

Once that list has been genereated, edit the domainValues_Wrkfc_EventType_psft.csv file
with entries for all desired values. Each ACTION/REASON can be mapped to a specific
set of standard domain values for spreadsheet columns:

EVENT_TYPE
EVENT_REASON
W_EVENT_GRP_CODE
W_EVENT_GRP_NAME
W_EVENT_SUBG_CODE
W_EVENT_SUBG_NAME
EVENT_CODE
EVENT_NAME

Use the delivered CSV file for examples of the expected values for these columns.