send a parameter value to MDX query of SSAS data Source

0
Hello I have an MDX query that calculate total persons by gender... and I want to put gender as parameter this is the query SELECT NON EMPTY { [Measures].[Total Persons] } ON COLUMNS, NON EMPTY { ([DIM_GENDER].[DIM_DESC_ARABIC].[DIM_DESC_ARABIC].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@DIMGENDERDIMDESCARABIC, CONSTRAINED) ) ON COLUMNS FROM [Model]) and I defined parameter called DIMGENDERDIMDESCARABIC but it still gives me an error XML/A fault: The query contains the parameter, which is not declared.; Code: XMLAnalysisError.0xc10e0004 Im stuck here can anyone help me how to solve the problem
tofevif822's picture
Joined: Aug 13 2020 - 2:11am
Last seen: 1 month 1 week ago

0 Answers:

No answers yet
Feedback
randomness