OBIEE 11.1.1.9 - Error: "The Data Source Does Not Support Rolling Up Arbitrary Sets of Dimension Members " is thrown for few upgraded reports whose datasource is HFM (Doc ID 2210307.1)

Last updated on FEBRUARY 11, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Symptoms

Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.9.0 version, Analytics

After migrating from version 11.1.1.7 to 11.1.1.9.
Some reports which were working in 11.1.1.7 fails in 11.1.1.9.
The following error message is thrown :

[nQSError: 22080] The data source does not support rolling up arbitrary sets of dimension members. [[
file: server\Query\Optimizer\ServiceInterfaceMgr\SIMDB\Src\SQOIALEGenerator.cpp; line: 1753
Please ensure that no more than one member is selected by the WHERE clause filter for each dimension that is excluded from the SELECT list.


State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 22080] The data source does not support rolling up arbitrary sets of dimension members. Please ensure that no more than one member is selected by the WHERE clause filter for each dimension that is excluded from the SELECT list. (HY000)

Changes

 Upgrade to OBIEE 11.1.1.9.x

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms