Implementing BI Analytics(delivered) with Peoplesoft 9.1 HR

[sam chenthati]

Hi All,

We are trying to implement BI Analytics (out-of-box) with our PPLSFT 9.1 HR module; one of the challenges we faced is with Hierarchy and many custom tables in the source being different than the out-of-box solution. 

Hierarchy in our data source : Position hierarchy (where Reports_To position number of the positions(staff) is assigned to respective supervisor's id and so on within Position data table, by using Position data table joins we get the roll-up's).

Please share some thoughts - If anybody had this type of implementation in the past or any knowledge on this:
* customizations required to implement delivered solutions.
* notable tables/etls to tweak.
* any considerations to take care.
* any documentation I can refer to.

Thanks in Advance.
Sam.