When Implementing HR Analytics, What Position Tables Does ODI Need to Populate and Why is W_POSITION_D and W_POSITION_DH Included in the Design?

(Doc ID 2030331.1)

Last updated on OCTOBER 09, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Goal

You have the following questions with regards HR Analytics:-

  1. The W_POSITION_D and DH tables are not used at all at RPD level (not used in BMM). Why they are used?
  2. For implementing HR Analytics, what position tables does ODI need to populate.
  3. If these tables are not used at OBI level, is there any point of loading these tables?
  4. Why is this dimension included in WRKFC_EVT_FG in the load plan if its not used at report level?


 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms