I am very new to MDX and just started learning basics. In my project we are using MDX cube on OLAP.
We are facing some issue with duplicate records being fetched from the query. I tried to put distinct on rows but didn't work out.
Here is the original query.
with member [Measures].[average_score] as [Measures].[Value]/[Measures].[Count],
FORMAT_STRING = '#,0.00' member [Measures].[label] as
[Standards].[Dim Standards Parent Id].Currentmember.Properties("Standard Type") + ' ' +
[Standards].[Dim Standards Parent Id].Currentmember.Properties("Standard Label")
select {[Measures].[label],[Measures].[average_score]} on columns,
NONEMPTY( (Descendants([Standards].[Dim Standards Parent Id],IIF(1 = 0,2,1+2))),
{[Measures].[average_score]}) on rows from surveys
where({[Questions].[Question Type].[RUBRIC_PLUS_EVIDENCE],
[Questions].[Question Type].&[RUBRIC],[Questions].[Question Type].&[SINGLE_SELECT]},
{[School Year].[Dim School Years Id].&[9]}, {[Questions].[Template Id].&[49]},{[Institutions].[Institution Id].[46760]},{[Surveys].[Survey Configuration Id].[118684]},{[Surveys].[Status].[IN_PROGRESS],[Surveys].[Status].[COMPLETED]})
can you please help me out in this.