Hi,
I currently have a very simple MDX as follow:
SELECT NON EMPTY { [Measures].[Param Result] } ON COLUMNS, NON EMPTY { ([Param Data].[Param StartTime].MEMBERS ) } ON ROWS FROM ( SELECT ( STRTOSET(@rpTestName, CONSTRAINED) ) ON COLUMNS FROM [AuditTester])
Since the above query might return a lot of parameter results for each parameter, my users want to bin (group) the results together by 5, 10, 20, etc. For example, binning by 5 means if the above query returns 10 rows, I need another query to only return two records to users where each new record is an average of 5 old rows. I did it in sql statement but now I need to do it in MDX. Any helps or suggestions would be greatly appreciated!
Thanks,
Amy
I currently have a very simple MDX as follow:
SELECT NON EMPTY { [Measures].[Param Result] } ON COLUMNS, NON EMPTY { ([Param Data].[Param StartTime].MEMBERS ) } ON ROWS FROM ( SELECT ( STRTOSET(@rpTestName, CONSTRAINED) ) ON COLUMNS FROM [AuditTester])
Since the above query might return a lot of parameter results for each parameter, my users want to bin (group) the results together by 5, 10, 20, etc. For example, binning by 5 means if the above query returns 10 rows, I need another query to only return two records to users where each new record is an average of 5 old rows. I did it in sql statement but now I need to do it in MDX. Any helps or suggestions would be greatly appreciated!
Thanks,
Amy