Skip to Content
avatar image
Former Member

MDX: Getting syntax error

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers