Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

HR Analytics - Organization hierarchy

dmazeAug 31 2012 — edited Aug 27 2013
Hi,
Need some help in configuring Department Based Organization hierarchy in OBIA 7.9.6.3… Im implementing OBIA HR Analytics with Peoplesoft as the data source...

After installation and configuration we loaded the data in the warehouse. But W_INT_ORG_DH table is not loaded… I somehow feel that the parameter values we set for $$TREE_SETID_NAME_LIST and $$TREE_STRUCT_ID_LIST are not correct…

Documentation doesn’t say from which table we need to query to get the values for these parameters…But the source tables to load dwh table are PS_DEPT_TBL, PSTREESTRCT, PSTREENODE, PSTREELEVEL.
We don’t know which column I should query to set the parameters…

Could you please let me know the table and column in Peoplesoft to set these parameter values..


thanks & regards,
dmaze
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 24 2013
Added on Aug 31 2012
#business-intelligence-applications
7 comments
1,312 views