Post reply

Calculated member

  • September 28, 2009 at 4:32 pm

    #226566

    Hi ,

    I have a dimesion having customer information and a fact with sales information. I want to create a calculated member in cube (using calculation tab in SSAS), which will give me top 100 customer according to their total purchase.

    Does any one has idea how to get this.

    Thanks,

  • September 28, 2009 at 10:08 pm

    #1059303

    It sounds like you're probably after a set more than a calculated member (ie the set will give you those top 100 customers, a calc member will simply be the sum of the top 100). You could achieve this using the TOPCOUNT function quite easily. If you're using SSAS 2005 you need to be aware that if you create this set within the cube (ie in the MDX script) then it will be evaluated only once (ie *not* on each call to it). Normally this can be an issue, as you usually want this top 100 to change over time as you get more data into the cube. In 2008 you can change a flag to indicate you want the set to be calculated dynamically.

    HTH,

    Steve.

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

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