INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Role Playing Dimension confusion

Role Playing Dimension confusion

(OP)
Im currently learning SSAS using the a simplified order schema. The order fact contains multiple dates i.e create_date_key, order_date_key, shipped_date_key each of which is linked back to the calender dimension via a foreign key relationship.

When I process the cube, I end up with a single calendar dimension and multiple dimensions within the cube named after each date_key i.e. CREATE DATE, ORDER DATE, SHIPPED DATE.

Now I thought this was all fine and dandy, then I started reading about role-playing dimensions and did some testing on my cube.  It seems OK. The data correlates on a daily basis to what I expected.  If I drag in for example both order and invoice date, they seem to group fine.

I'm still concerned I'm missing something with the role playing dimensions. Should I be explicitly creating these? What is the implication if I dont?
 

"There are only two lasting bequests we can hope to give our children; one of these is roots, the other wings" - Hodding Carter  

RE: Role Playing Dimension confusion

SSAS has basically created role-playing dimensions for you.  If you were using another tool, or doing your reports directly off of the relational star schema, then you would want to do something like creating a view for each date over your date dimension table.   

RE: Role Playing Dimension confusion

A Role Playing Dimension is a single dimension, such as date, that is used multiple times.  The cube uses the Same Physical Dimension object but assigns a new name to it in the cube.  This prevents you from having to build multiple versions of the same object in order for it to fulfill multiple roles.  Date is one of the more common dimensions where you will see it as a role playing dimension.  As long as the relationships maintain the same level of granularity there should be no issue.   

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
                           - Daffy Duck

RE: Role Playing Dimension confusion

(OP)
Thank you, has put my mind at rest.

"There are only two lasting bequests we can hope to give our children; one of these is roots, the other wings" - Hodding Carter  

RE: Role Playing Dimension confusion

"Company" is another example of a role-playing dimensions, as a "Company" can be both a customer and a vendor/supplier.  In a legal scenario, a "Person" might be a plantiff in one lawsuit, a defendant in another, and a witness in another.  

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close