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 2008 Forums
 Analysis Server and Reporting Services (2008)
 Dynamic Ranking

Author  Topic 

Andrewra
Starting Member

17 Posts

Posted - 2009-09-16 : 09:55:16
Came across a situation in SSAS that I would like to see how other people may have handled this. Basically I need to do dynamic ranking around measures in a cube.
So, envision a scenario where I have three parameters:
1) Percentage Type (Best, Worst, etc.)
2) Percentage Amount
3) Measure to base ranking on
Upon making the selection (for example, the best 15% of some measure), I should return a list of choices. From there, the user should be able to drag and drop other dimensions and facts into the crosstab and be able to build a report around those ranked choices.

Curious what anyone has done before to accomplish this.

Thanks

AA





Andrew Alexander

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2010-08-25 : 18:07:32
Andrew did you ever find the answer to this question, I am in the same boat for a dynamic ranking table

If you don't have the passion to help people, you have no passion
Go to Top of Page

savior faire
Posting Yak Master

194 Posts

Posted - 2010-08-30 : 12:57:39
I read an article on this exact topic that I found on www.ssas-info.com.

______________________________________________
Talk sense to a fool and he calls you foolish.
Go to Top of Page
   

- Advertisement -