Create analysis using Subject Area ‘General Ledger- Balances Real Time’ In Oracle Fusion

1.      Run or schedule Process “Create Balances Cube” In ESS. This process create Essbase cube.

2.      Run or schedule Process “Create Rules XML File for BI Extender Automation”

3.      Run or schedule Process “Import Oracle Fusion Data Extensions for Transactional Business Intelligence”

4.      Mandatory parameters to use the subject area as follows:-

i)        Navigate to Ledger folder and pull Ledger Name, Chart of Accounts

ii)      Navigate to Time folder and pull Name, Accounting Period Name column.

iii)     Navigate To Currency folder and pull Currency, Currency Type column

iv)     Navigate to Amount Type and pull Amount Type column

v)      Navigate to Scenario folder and pull Scenario column.

vi)     Navigate to Balance folder and pull Beginning Balance and Ending Balance

vii)   Navigate to Cost Center Segment folder and pull Cost Center Code

viii)  Navigate to Natural Account Segment folder and pull Account Code

ix)     Navigate to Balancing Segment folder and pull Balancing Segment Code

x)      Filter on Chart of Accounts

xi)     Filter on Fiscal Calendar Name

xii)   Filter on Accounting Period name for a period which has balances.

xiii)  Run the report.