Hi,
We are in the process of creating customized reports on Financial Module in OBIA 11.1.1.10.1 which will be sourced from PeopleSoft.
Client wants to analyse and have filter prompts on some of there Chart Fields like Operating Unit, Affiliate, Project, Program Code ..etc.
OOTB reports I guess it does not provide these Chart Fields as separate Dimension tables except few like Project, Company, Cost Centre ..etc
Can any one let me know how to do this in OBIA, Do I need to introduce Custom Dimension table for required Chart Flied and also modify existing ETL Interface to use these Custom Dimension.
Regards,