You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Received Response
edited Apr 14, 2021 7:44PM in Reporting and Analytics for ERP 4 comments


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

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!