Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MDX Query, binning results together

Status
Not open for further replies.

amypham

Programmer
Dec 29, 2008
1
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top