Post reply

role playing dimension

  • April 10, 2012 at 10:59 am

    #254646

    Hi All, can we have any example for role playing dimension other than time, and why we need more cubes for one project, on which basis we create multiple cubes for a project..

    thanks in advance friends!

    Niharika

  • April 11, 2012 at 1:10 am

    #1471690

    A multi cube project is the preffered choice to support different line of businesses within a job function

    Raunak J

  • April 11, 2012 at 1:15 am

    #1471693

    Also see this thread

    http://forum.kimballgroup.com/t24-role-playing-dimensions-when-is-it-appropriate

    Raunak J

  • April 11, 2012 at 2:33 am

    #1471713

    The most used example of a role playing dimension is the time dimension.

    Say you have a fact dimension with the following attributes:

    * orderdate

    * due date

    * delivery date

    You don't want to implement 3 time dimensions, so you link those 3 attributes to the regular time dimension with foreign keys.

    In SSAS, you make one time dimension, but in the cube designer, you add it 3 times, one for each date attribute. Make sure you set the correct mapping in the dimension usage tab.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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