OBIEE 12c: Essbase With More Than 20 Measures Gives Error NQSError: 46008 Internal Error: SQOIGeneratorBuiltIn.cpp
(Doc ID 2587325.1)
Last updated on JANUARY 24, 2022
Applies to:Business Intelligence Suite Enterprise Edition - Version 188.8.131.52.181016 and later
Information in this document applies to any platform.
On Oracle Business Intelligence Enterprise Edition, OBIEE 184.108.40.206.0 version
OBIEE environment won't work with OBIEE reports based on Essbase and federated relational data, when working with more than 21 measures.
In the log files noticed the below things that the query generator used two different strategies to build to MDX:
< 20 measures: Individual queries for every measure
> 20 measures: One single query that extracts all data in one go
Facts_20: 20 measures and working.
Facts_21: 21 measures and not working.
Essbase cannot handle the one single MDX query. And below error can be found in obis1disgnostics.log.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document