Post reply

SSAS Calculation Problem

  • September 15, 2009 at 4:00 am

    #209872

    Hi

    We have a case in which we have three levels of calculation.

    we have product ,product category and product subcategory.

    We are making a calculated member in the SSAS cube in which we are finding the the wiehgted average as

    Weighted Sales=sales*weightage /Total weightage.

    We want to calculate wieghted average at product subcategory and product category level and simple average at Product level i.e.,

    Weighted Sales=Sum(Sales) {of Product category}/Total number of Product category.

    Any idea how to accomplish it....

    Thanks in advance...

  • September 16, 2009 at 9:46 am

    #1054564

    What is supplying the weight for Categories and SubCategories? Is it possible to define these in such a way that the weight per Product is 1 -- making them all the same case?

    Otherwise, it is possible to define a calculated member conditionally using Case or IIF and testing the level. The performance might be a problem, however.

    If you can make and example using Adventure Works, it simplifies helping.

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

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