Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQLboom
Yak Posting Veteran
63 Posts |
 Posted - 2004-05-05 : 06:33:11
|
| Hi,Please verify the following query based on Sales Cube in Foodmart 200 database cubein Analysis Services: Can someone suggest what is wrong with the above query and provide some sample code to calculate ranks. The query runs and does not give the rankf or the query with message (An error occurred during an attempt to get a cell value):with member [Measures].[RANK] as 'RANK ([Promotion Media].[Media Type].Members.CurrentMember, FILTER(except([Promotion Media].[Media Type].members,{[Promotion Media].[Media Type].[No Media]}),[Measures].[Unit Sales] > 5000), [Measures].[Unit Sales]) 'select {[Measures].[Unit Sales], [Measures].[RANK]} on columns, FILTER(except([Promotion Media].[Media Type].members,{[Promotion Media].[Media Type].[No Media]}),[Measures].[Unit Sales] > 5000) on rowsfrom Sales |
|
|
|
|
|
Calculating Rank