MDX Create Set Function Crashes Essbase Application

(Doc ID 2419513.1)

Last updated on JULY 06, 2018

Applies to:

Oracle Analytics Cloud Service - Version 17.4.1 to 18.2.1 [Release 17 to 18]
Information in this document applies to any platform.

Symptoms

Using Create Set in MDX query crashes application and generates an exception (xcp) file. 

a) Create a test set using following command:

CREATE SET [TESTSET] AS
'{[Product].[100],[Product].[200]}'

b) Use the Set in the MDX query as below:

SELECT
{[Measures].[Sales]} ON ROWS,
HIERARCHIZE([TESTSET]) ON COLUMNS
FROM [Samplle].[Basic]

c) Application crashes and XCP file will be created. 

 

Changes

Create Set function used to work till 11.1.2.3 Essbase. After migrating to Oracle Analytics Cloud (OAC), the application is crashing.

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