Home Dashboard Directory Help

Role Playing dimension - change level name by Tiago Rente - VF-PT



Sign in
to vote
Type: Suggestion
ID: 284096
Opened: 6/25/2007 2:13:22 AM
Access Restriction: Public
Primary Feedback Item: 144500


In order to use the dimension’s role playing functionality, it should be possible to change the name of the attribute/hierarchy’ levels.
E.g., you use 2 time dimension using role playing, it is not possible (at least to my knowledge) to change the name of the attribute/hierarchy’ levels. The first dimension is related to orders time and the second to delivered time, the end-users would like to be able to figure out if the month is related to the order or the delivery.

Order Time:
• OT Year
• OT Month
• OT Day

Delivered Time:
• DT Year
• DT Month
• DT Day.
Sign in to post a comment.
Posted by jbusselman on 9/5/2012 at 7:36 AM
I too would like to know if this has been included in SQL 2012 as we are contemplating individual dimensions (Date is killer as we have tons and very time consuming to do the identical setup for each) or trying to do the role playing dimension.
Posted by krish9 on 10/27/2011 at 6:12 PM
Is this atleast addressed in SQL Server 2012 which is right now in CTP 3?
Posted by ponzie on 4/28/2008 at 12:33 AM
This is the singlemost frustrating aspect of SSAS for us.
It effectively means that every role playing dimension that is required to have its own uique name needs to be created as a real cube dimension with the consequent impact on development time, storage space and processing time.
Posted by Tiago Rente - VF-PT on 4/27/2008 at 3:39 AM
I found a similar request from Chris Webb https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=144500&wa=wsignin1.0

Posted by Microsoft on 2/6/2008 at 3:18 PM
Thanks, this is a good idea. We're looking into this for upcoming releases of Analysis Services.

-Analysis Services Team
Sign in to post a workaround.