My Oracle Support Banner

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 and later
Information in this document applies to any platform.


On Oracle Business Intelligence Enterprise Edition, OBIEE 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.