grouping by MDX

Question

Post reply

grouping by MDX

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

cafc SSCommitted Points: 1647 More actions · Answer 1

i want count the number of costumer by age group, by store and date (of course that is implicit that the costumers has sales...)

in my date base i have the following data:

costumers code| age group | store | date | sales

1 | 0-14 | 4 | 20-7-2010 | 10

2 | 0-14 | 4 | 20-7-2010 | 5

3 | 15-24 | 5 | 21-7-2010 | 0

i want simply count the numbers of costumer for a given age group, store and date:

Suppose:

for store 4, and day 20-7-2010 , how many costumers for age group 0-14 there are?

for this age group are: 2

correct?

thanks

Dirk Wegener Ten Centuries Points: 1131 More actions · Answer 2

Is your [Dim Costumer] dimension connected to a measure group containing Sales? Then you can use the following statement assuming your measure name is called Sales:

WITH



SET FilteredSet AS

  nonempty(

    [Dim Costumer].[Cod].ALLMEMBERS *

    [Dim Costumer].[Age Group].&[0-14] *

    [Dim Store].[Cod].&[51] *

    [Dim Date].[D].&[2010-07-21],

    [Measures].[Sales]

  )

MEMBER [Measures].[x] AS Count(FilteredSet)

SELECT {[Measures].[x]} ON 0,

FilteredSet ON 1

FROM [StoreDM];

http://www.dwexplorer.com
@dtwegener