Analytics Software

Hi,

I need some help around configuring OBI Apps 7.9.5 (Financial Analytics module) with PeopleSoft Financials 8.9. Please realize that I am NOT asking about PS EPM product.

There is this GL Account Groupings (file_group_acct_codes_psft.csv) file provided by Oracle where we have to group organization's GL Accounts as part of the Financial Analytics configuration. In addition, there are the PS Trees where client have their organization specific hierarchies configured on the PS Financials source system (OLTP side). The main questions :

1. The first column in the file_group_acct_codes_psft.csv is called 'BUSINESS_UNIT' and allows you the capability to group GL accounts for each BU within the company. In case of my client, they dont have BU specific groupings. In other words, the same GL groupings they have provided me apply to the whole organization (not BU specific). In this case, do I have repeat the GL groupings rows in the csv file for each BU this company has (they got 80 plus so it will be a lot of copying/pasting) or can I leave the BUSINESS_UNIT column blank since the groupings are not BU specific in this case?

2. How and where are the PS Trees used in the Financial Analytics application (on which reports/dashboards if any)? So once we modify the Informatica mappings to bring in those client specific PS Trees, where do they show up?

3. On the same note, where is the GL Account Groupings used in the Financial Analytics app (on which reports/dashboards if any)? These are the groupings that were included via the csv file (file_group_acct_codes_psft.csv)

4. The confusion is around that they both (PS Trees & GL Account Groupings) seem very similar to each other on how they group GL accounts so we want to understand the impact of each one of these within the OBIEE Financial Analytics application.

Your help will be appreciated.

Thank you,

Naushad.