Skip to Content

MDX: Getting syntax error

Sep 22, 2017 at 12:06 PM


avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers