Hi all,
I'm a OLAP beginner and i'm building my first cube for my customer.
I have a hierarchical geographic dimension that reproduce a tipical
structure like this one:

Main Area - Sub Area - Seller - Customer

I need to count the number of Customers, how can i accomplish my duty?
Using a calculated member in the dimension? Some other ways?

Thanks in advance.

Simone Greci

It depends what you want. If you just want a count of all customers in the
dimension, then try a calculated measure like this: -

[customer dim].[customer level].COUNT

If you want only the customers below the current member in the customer
hierarchy (e.g. within a particular sub-area), then try this: -

COUNT(DESCENDANTS([customer dim].CURRENTMEMBER,[customer dim].[customer
level]))

If you want the customer count to be limited by selections in other
dimensions, e.g. if the time dimension is fixed on JULY then only count the
customers we sold to in July, then I think the best way would be to create a
DISTINCT COUNT measure based on the customer ID in the fact table.

--
Dean Adam
Magenic Technologies


"s.greci (AT) gmail (DOT) com" wrote: