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 |
|
Ludwig
Starting Member
9 Posts |
 Posted - 2008-11-22 : 01:46:49
|
| Hi Guys,I'd like to use a name set to get for instance the 3 top performing sales guys measured by revenue. Let's say these sales guys belong to different sales teams, so they are the leaf elements of a dimension with more than one level.I define my nameset as follows:(Topcount (Existing([View Employee].[View Department - View Employee].[View Employee].Members),3, [Measures].[Revenue]))The mdx expression uses the topcount function to determine the 3 best performing sales guys, it basically just ranks them based on revenue.The statement runs without problems when I process the cube but when I test the name set in ssas cube browser it shows me sales guy who don't belong to the top 3 and it also doesn't change the names of the sales guys when I include the time dimension and select different months and days...and it should change because nobody is every day under the top 3 out of 500 sales guysSame result in MS-Excel by the way..Why is this?My understanding is that I can use top and also buttom count to get the leaf level elements of a dimension in an ordered fashion. It also doesn't matter if the measure is a calculated measure or a fact measure..Any idea?ThanksLudwig |
|
|
Ludwig
Starting Member
9 Posts |
|
|
|
|
|
SSAS 2005 Named Sets/Top Count