cancel
Showing results for 
Search instead for 
Did you mean: 

MDX: Getting syntax error

Former Member
0 Kudos

Dear Experts,

Am using ADOMD for executing MDX query of my SAP default cubes. I have filtered the dimension members as below. Am getting the syntax error while executing the below query on ADOMD.

Note: I have used this query Microsoft ReportBuilder. There also am getting same error.

MDX Query:

SELECT NON EMPTY {[Measures].[0D_FC_INVQT]} dimension properties MEMBER_TYPE, PARENT_UNIQUE_NAME ON COLUMNS , NON EMPTY {{hierarchize(Union(Intersect(VISUALTOTALS(Except(Descendants([0D_FC_DREG].[LEVEL00].Members, 1, SELF_AND_BEFORE) , {[0D_FC_DREG].[00001]})), Hierarchize({ [0D_FC_DREG].[LEVEL00].Members })) , Except(Hierarchize({ [0D_FC_DREG].[LEVEL00].Members }) , {[0D_FC_DREG].[00001]})))}} dimension properties MEMBER_TYPE, PARENT_UNIQUE_NAME ON ROWS FROM [$0D_FC_C01] CELL PROPERTIES VALUE, FORMAT_STRING, FORMATTED_VALUE


Please anyone correct this syntax issue?

Accepted Solutions (0)

Answers (0)