Custom Attribute Names in Role Playing Dimensions for SSAS
User Rating: / 0
Written by Pavel Pawlowski   
Sunday, 29 September 2013 22:07

SQL Server introduced a great feature for improving the processing time and reducing storage requirements in the form of Role Playing Dimensions. Unfortunately one of the drawbacks is that those dimensions do not support custom attribute names for different roles. Often the business requirement is to use custom attribute names, but many reporting solutions (including Excel) use only the attribute names for column names. In this tip we look at how this can be achieved using hierarchies.




Pyramid Analytics