Question

Sonnfan on Sun, 30 Dec 2012 17:34:08


Hi everybody, I need some help in creating a measure in MDX.

My customer dimension looks like that:

|-State
|---City
|-----Street
|--------Street number
|-----------Customer

So for example

|-Saxony
|-Bavaria
|---Munich
|-----Example-Street
|-------1
|-----------Customer A
|-------2
|-----------Customer B
|-----------Customer C
|-------3
|-----------Customer D

Now I'd like to create a measure, that gives me to every level the amount of customers, for example '4' for Munich (and something like 10 for Bavaria).

I read about the count function but can't seem to make it work properly. Could somebody tell my how to implement this feature? :)

Regards and best wishes,
Sonnfan

 


Sponsored



Replies

Martin Mason on Sun, 30 Dec 2012 19:24:08


The following definition should work.

CREATE MEMBER CurrentCube.[Measures].[CustomerCount] AS
	COUNT(Descendants( [Customer].[Hierarchy].CurrentMember, [Customer].[Hierarchy].[Customer] ) )

HTH, Martin

http://martinmason.wordpress.com


Sonnfan on Tue, 01 Jan 2013 17:49:53


Hey, thanks for your suggestion. I was able to solve the Problem with the following code:

with member [Measures].[Amount] as 'sum(descendants([Customer].currentmember, [Customer].[Name]),1) '

...

Regards,
Sonnfan