Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Reporting with Hierarchies in OTBI

edited May 18, 2020 4:20PM in Reporting and Analytics for ERP 4 comments

Summary

Fusion OTBI - Hierarchies are not showing in all General Ledger subject areas

Content

Background/Requirement:

My client wants an OTBI analysis which includes various levels of KFF segments (e.g. parents L1, L2, L3 of Cost Centre and Natural Account code) to be able to report at various levels of segment 'roll up'.  (A very common and reasonable sort of requirement!)  However, there is a documented bug with OTBI (with an enhancement request) such that the hierarchies only display at very top level or very bottom level (leaf node) in OTBI subject areas (i.e. the hierarchies are 'flattened').  The exception to this is "General Ledger - Balances Real Time" which uses the Essbase hierarchies.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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