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 |
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 onUpon 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.ThanksAA 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 tableIf you don't have the passion to help people, you have no passion |
 |
|
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. |
 |
|
|
|
|