largeselection
Active Member
- Joined
- Aug 4, 2008
- Messages
- 358
Hi,
I'm trying to create a named set via MDX, but I'm too new to accomplish what I'm trying to do (or even know if it's possible). Is it possible to create a topcount set based on multiple criteria?
So I know I can say Topcount(Salesman, 10, Sales) (forgive me for not using full structure), but can I do something more specific like Topcount(SalesMan, 10, {Sales,North America, 2010, Q1, Hybrids})?
So in the first example that says bring back top 10 salesman ranked by Sales. I would like to bring back top 10 salesman ranked by Sales that were also in North America, during Q1 of 2010, in the Hybrids category. So I can accomplish this via pivot table, by creating the topcount set and then just adding all of the rest of my criteria as filters that way the topcount set readjust based on what's filtered in the ptable, but that is quickly becoming messy.
If it were possible to do a topcount the way I'm envisioning it, then I could theoretically just use cubemember function and cuberankedmember functions to correspond so I could see the top 10 salesman by category all next to each other rather than multiple pivot tables all next to each other.
Thanks for any links, insight, thoughts.
I'm trying to create a named set via MDX, but I'm too new to accomplish what I'm trying to do (or even know if it's possible). Is it possible to create a topcount set based on multiple criteria?
So I know I can say Topcount(Salesman, 10, Sales) (forgive me for not using full structure), but can I do something more specific like Topcount(SalesMan, 10, {Sales,North America, 2010, Q1, Hybrids})?
So in the first example that says bring back top 10 salesman ranked by Sales. I would like to bring back top 10 salesman ranked by Sales that were also in North America, during Q1 of 2010, in the Hybrids category. So I can accomplish this via pivot table, by creating the topcount set and then just adding all of the rest of my criteria as filters that way the topcount set readjust based on what's filtered in the ptable, but that is quickly becoming messy.
If it were possible to do a topcount the way I'm envisioning it, then I could theoretically just use cubemember function and cuberankedmember functions to correspond so I could see the top 10 salesman by category all next to each other rather than multiple pivot tables all next to each other.
Thanks for any links, insight, thoughts.