Measures show as null in IDT business layer (connected to Essbase Cube)

[Former Member]

All,

We have applied BI 4.0 FP3 and able to connect to the Essbase 11.x cube. Was able to create the business layer as well. But when I try to create a query and preview the measures (for account) based on the filters as seen below, I get no result (null value). Below is the script..

FYI, this combination of filters and account (operating_expense) shows values in the underlying Essbase cube/report.

Any help will be appreciated..Thank you.

WITH

MEMBER [Custom1].[SLICER1] AS 'Aggregate(Distinct({[Personnel]}))'

MEMBER [Custom2].[SLICER2] AS 'Aggregate(Distinct({[70GA]}))'

MEMBER [Custom3].[SLICER3] AS 'Aggregate(Distinct({[Custom3.Legal]}))'

MEMBER [Custom4].[SLICER4] AS 'Aggregate(Distinct({[TopC4]}))'

MEMBER [Entity].[SLICER5] AS 'Aggregate(Distinct({[M900]}))'

MEMBER [ICP].[SLICER6] AS 'Aggregate(Distinct({[FM ICP Top]}))'

MEMBER [Period].[SLICER7] AS 'Aggregate(Distinct({[Jan]}))'

MEMBER [Scenario].[SLICER8] AS 'Aggregate(Distinct({[ACTUAL]}))'

MEMBER [Value].[SLICER9] AS 'Aggregate(Distinct({[FM Parent Curr Total]}))'

MEMBER [View].[SLICER10] AS 'Aggregate(Distinct({[Periodic]}))'

MEMBER [Year].[SLICER11] AS 'Aggregate(Distinct({[2012]}))'

SELECT

NON EMPTY {[OPERATING_EXPENSES]} ON COLUMNS

FROM [CUBEBASE]

WHERE ([Custom1].[SLICER1], [Custom2].[SLICER2], [Custom3].[SLICER3], [Custom4].[SLICER4], [Entity].[SLICER5], [ICP].[SLICER6], [Period].[SLICER7], [Scenario].[SLICER8], [Value].[SLICER9], [View].[SLICER10], [Year].[SLICER11])

[Henry_Banks · Accepted solution]

Hi,

FP03 is in Ramp Up and not general availability.

Consequently, the vast majority of the audience on SCN have no exposure to FP03.

Moreover,  you should be working directly with Support who have route-1 priority for OSS direct to Development during RU.   Your RU Coach should have informed you of this process.

Please submit a support incident ASAP,  after you have requalified your issue on the latest available Patch (in this case 3.4) which is a condition of joining Ramp Up.

Regards,

H

[Former Member]

Hello Ann,

Is the query above  same as the one generated by IDT. Did u get a chance to trace the query going back and see the results retured upon exeuting that query manually.

Did u check with other combination of filters?

Regards,

Laxminarayana