Hi everyone,
I’m trying to open a default report from Dynamics AX 2012 but I got the following message:
“The following error ocurred, Query (23, 8) The Members function expects a hierarchy expression for the argument. A memember expression was used”
The query from the report is the following:
WITH //member @AX_CompanyName1 as “CEU” // CubeElementReference = [Warehouses].[Warehouses]
MEMBER [Measures].[Default] AS “[Warehouses].[Site - Warehouses].[Warehouses].MEMBERS”
MEMBER [Measures].[ParameterCaption] AS [Warehouses].[Site - Warehouses].CurrentMember.Member_Caption
MEMBER [Measures].[ParameterValue] AS IIF([Warehouses].[Site -Warehouses].CurrentMember.MEMBER_UNIQUE_NAME = [Warehouses].[Site - Warehouses].[All].MEMBER_UNIQUE_NAME, [Measures].[Default], [Warehouses].[Site - Warehouses].CurrentMember.MEMBER_UNIQUE_NAME + “.CHILDREN”)
MEMBER [Measures].[ParameterLevel] AS
[Warehouses].[Site - Warehouses].CurrentMember.Level.Ordinal
SELECT {[Measures].[ParameterCaption] ,[Measures].[ParameterValue] ,[Measures].[Default]} ON COLUMNS,
{{[Warehouses].[Site - Warehouses].[All], [Warehouses].[Site - Warehouses].[Warehouses Site].MEMBERS}
} ON ROWS FROM [Sales Cube] WHERE strtomember("[Warehouses].[DATAAREAID]."+"&[" + @AX_CompanyName1 + “]”)
I need to execute the query, what should I modify in the cube or AX configuration ?
Thanks