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.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  Excel PercentRank in Analysis Services

Author  Topic  fxea1410 Starting Member 1 Post Posted - 2008-08-29 : 20:57:38 How to use "Excel!PercentRank" in sql server 2005 analysis services? That is, how do you call it while feeding it an array of values? The following works in VS 2005, but I need the pct rank for EACH value in my [Measures].Avg1 and it's not working. Any help from a guru out there is greatly appreciated. CREATE MEMBER CURRENTCUBE.[DimToken].[Department].[PctRank1] AS Excel!PercentRank([Measures].rating_average),[Measures].rating_average), FORMAT_STRING = "#,#.00", NON_EMPTY_BEHAVIOR = { [Rating] }, VISIBLE = 1 ;