MDX Query Fails with Unexpected Error 1042017 in 11.1.2.1

MDX Query Fails with Unexpected Error 1042017 in 11.1.2.1 [ID 1320230.1]
Modified 16-MAY-2011 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Cause
Solution
References

Applies to:

Hyperion Essbase Administration Services - Version: 11.1.2.1.000 to 11.1.2.1.000 - Release: 11.1 to 11.1
Information in this document applies to any platform.
Symptoms

An MDX query that previously worked in version 9.3.3 and 11.1.2 no longer works in 11.1.2.1. When the query is executed a network error appears.

Steps to reproduce:
1. Create an ASO application named CBR and a database named CBR. Save CBR.otl to database.
2. Load export_F_CBR.txt to database.
3. Run the MDX query from EAS console:

select
{ [Measures].[Material COGS CP2],
[Measures].[Material COGS CP1]
} on columns
from [CBR.CBR]
where ( [Cost_Period1].[Qtr-8], [Cost_Period2].[Qtr_7],
[Currency].[CUR-RPT]);

Unexpected error 1042017 appears as the result of the query.



Cause

The cause of this problem has been identified in unpublished Bug 12418533 - MDX QUERY WORKED IN 11.1.2 NO LONGER WORKS IN 11.1.2.1



The issue is caused by the MDX function on measures member "Material COGS CP2". The MDX formula is a LEAD function and when removed, the query returns with no error. A lot of members in measures use the LEAD function and none can be queried against in 11.1.2.1.
Solution

A workaround for this issue is to add the following parameter in the essbase.cfg file and stop and start Essbase.

FORMULAOPTLEVEL 2

This defect will be addressed in a future release.