March 12, 2007 at 3:31 am
I have a cube where I must count the customers. I used DistinctCount (Customers.members.children), it's OK, but doesn't function properly when I choose 2 or more members by the Product Dimension. I use owc as client.
Instead, it's OK if I filter only 1 product, or I don't filter the Product dimension.
If I do a multi-selection I see the same number of AllProducts (without filter).
I also tried to use DistinctCount (from Measures) of CodeCustomer in Fact Table but it's worse...
How can I count the customers without these problems ?
Thanks
March 12, 2007 at 10:39 am
That's a common problem with AS2000 and distinct count. You have to do a Basket Analysis. I don't know if it's supported in OWC.
More info here:
http://msdn2.microsoft.com/en-us/library/aa902637(sql.80).aspx
It's resolved in AS2005: http://blogs.conchango.com/christianwade/archive/2005/04/03/Distinct-Count-in-Analysis-Services-2005.aspx
March 12, 2007 at 12:15 pm
Not sure if it's covered off int he Market Basket Analysis info but you could try an alternate Distinct Count (e.g. as a calc measure) that may provide the outcome you're looking for. The format is shown below, you need to have another measure that you'll use to determine that an event occured [e.g. sales dollars means a sales transaction that day]:
Count
(
NonEmptyCrossJoin (
{[Measures].[Sales]},
Descendants ([Products].CurrentMember, , LEAVES )
)
)
Steve.
March 15, 2007 at 2:38 am
Thanks a lot
It's O.K.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply