Reporting with Hierarchies in OTBI
SummaryFusion OTBI - Hierarchies are not showing in all General Ledger subject areas
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.