Distinct count on several dimension members

Here is an example on how you can select the distinct count on a combination of product categories. The example is written for FoodMart 2000

Rank that thing…

Ranking i MDX kan være en spøjs ting at arbejde med. Her den anden dag sad jeg med problemet at skulle ranke et Crossjoin set hvor jeg kun ville have .children. Det viste sig, at når man rankede, skulle man benytte sig af Extract( [Dimension].Members, [Dimension].DefaultMember ) istedet for [Dimension].Children I min verden er det […]