Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Analytics Cloud and Server

set content level in FACT LTS for unbalanced hierarchy

Question

Views

Comments

2714750 Rank 2 - Community Beginner

Sep 28, 2016 2:17AM edited Aug 13, 2024 7:19PM in Oracle Analytics Cloud and Server

Hi,

I've 2 datasources - one Essbase cube and one Postgresql source.

From Essbase source I've created LTS for Account which has hierarchy in 17 levels now.

From sql source created LTS for fact. Then created BMM folder where pulled the measures and other fields from the Fact and Account dimension.

But in report, while added any description field that has been pulled in BMM from the fact, it is giving error: 14025.

Please help me how to set level in Content tab and which level should I set there.

It is very urgent. Appreciate quick help.

Regards.