SSAS NameColumn Property format Issue :

I am trying to format the Name column through the format property. Rather than to create the named calculation in the DSV and then use it as a name column. I did this test both in 2008 r2 and 2012 and both have the same behaviour that format is not going to change and it’s showing the original value.

SSAS Name Column Format

Even I put my name in the format though process run successfully.

I did some investigation and found very useful post of Dan English in which he got response from Microsoft:

http://social.msdn.microsoft.com/Forums/zh/sqlanalysisservices/thread/dee2dccc-7321-492c-a68d-2e1375efe237

Response from Microsoft:
The “Format” string for Attribute names is a stub for a later addon and is not implemented. Attribute names will only accept WChar types. Any formatting should be done either in the data source view as a “Named Calculation” or in the source table/view on the relational source.
The above reply is in June 2007 and now is February 2013 this issue still persist in 2012 release.

Conclusion:
Don’t use the Name column format property, use the named calculation technique which mentioned above.

Please read/vote for this Microsoft Connect suggestion:

https://connect.microsoft.com/SQLServer/feedback/details/779761/ssas-namecolumn-property-format-issue

Advertisements

About Zaim Raza

7 Years of professional experience in Business intelligence using SQL Server and Microsoft SharePoint/.net Technologies. Experience in Data warehousing, Data Modeling, Data profiling, Data Integration, Data cleansing, consultations and enterprise reporting. I want to work for organization where I am able to utilize my skills, experience and knowledge to transform the technology into business value.
This entry was posted in SSAS and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s