Post reply

Look up table in SSAS

  • May 26, 2008 at 6:34 am

    #154385

    hi,

    In SSAS is it possible for lookup table, for instance: if the purchase goes above 500 then rating is 5,if 400 then rating 4...the purchase values like 500,400 are in one dimension table. hence the rating are in another dimension table.

    Is it possible to make a lookup with these dimension table by providing rating?

    If it's possible,then how to implement???

  • May 27, 2008 at 2:06 am

    #820397

    Hi,

    Not sure what exactly you are trying to do here. What do you do with the rating? use it in a calculated member? or is it just a dimension attribute?

    Regards,

    Vijay.

    Warm Regards,
    Neel aka Vijay.

  • May 27, 2008 at 6:11 am

    #820490

    It sounds to me like you just need a "Rating" dimension.

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

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