on 09-22-2017 1:06 PM
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?
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.