Post reply

Calculate the unique number of customers at runtime in Analysis Services 2005?

  • February 5, 2009 at 3:09 am

    #199905

    have a Analysis Services problem I need urgent help with. I need to calculate the distinct count of customers that meets a criteria at runtime.

    I have a Facttable which looks like this

    OrderIdCampaignCustomer IDPriceplanArticleIncomingvalueCurrent value

    12009 1 A A 0 15

    22009 1 A B 15 15

    32009 1 B A 20 0

    42009 1 B B 0 15

    52009 2 A A 0 20

    62009 2 A B 0 20

    72009 2 B C 20 15

    82009 2 C C 10 0

    92009 3 A A 10 5

    102009 3 A A 10 15

    112009 3 A B 5 0

    I need a calculated measure "No of unique ValueCustomers" which meets the criteria previous value > 0 and Current value > 0.

    Problem is that which customer that counts as a ValueCustomer changes depending on what I look at for the moment.

    If I look at Priceplan A then there are 2 ValueCustomers. Customer 1 and 3. The previous value and current value are summorized on Priceplans which means it doesn't matter that the previous value for order 1 is 0.

    If I look at Article B then there are 1 Value Customers. Customer 2. The previous value and current value are summorized on Articles which means it doesn't matter that the previous value for order 4 is 0.

    There are so many combinations of dimensions so it is not possible to predefine all combinations. I want to make the calculations on the fly when I look at the cube.

    Is it possible to create such a measure? If I use some kind of filter for previous value and current value and a count distinct(customer Id) function?

    regards

    Tomas

  • February 5, 2009 at 3:11 am

    #938684

    The message should of course start with:

    Hi

    I have an Analysis Services ....

    /Tomas

Viewing 2 posts - 1 through 2 (of 2 total)

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