OTBI Analysis: Connect 2 Subject Areas of General Ledger - Balance Real Time and General Ledger - Pe

Content

Hello There,

I have an OTBI analysis for Subject Area: "General Ledger - Balances Real Time".

I would like to add column 'Accounting Period End Date'. This is made available in Subject Area: "General Ledger - Period Status Real Time".

Performed the following Steps:

1. Added the 2nd Subject Area: "General Ledger - Period Status Real Time"

2.Added these columns from both the Subject Areas:

          Ledger --> Ledger Name

          Time --> Accounting Period Name

3. Added the required column from the 2nd Subject Area: "General Ledger - Period Status Real Time"

          Time --> Accounting Period End Date

4. Tab Advanced --> Advance SQL Clauses