How to set Attributes in sort order for a dimension in SSAS cube?

Hi,

For Example: I have one dimension named as "Name", Under this I have "FirstName" and "LastName" Attributes are there.

But when i drag "Name" dimension, By default "First Name" dragged. But i Want "Last Name" should drag.

Hope You understand my Question. 

Can you please help on this. Thank You.

Nagaraju



July 22nd, 2015 5:24am

You can change NameColumn, Value Column properties for this

see

https://www.mssqltips.com/sqlservertip/3228/change-sort-options-on-dimension-attributes-in-sql-server-analysis-services/

Free Windows Admin Tool Kit Click here and download it now
July 22nd, 2015 5:40am

Hi Visakh16,

I am not bother about Attribute members, I want Attributes Sort Order.

For Example: I have one dimension named as Name, Under this I have FirstName and LastName Attributes are there.

But when i drag Name dimension, By default First Name dragged. But i Want Last Name should drag.

Hope You understand my Question. 

Can you please help on this. Thank You.

Nagaraju

July 22nd, 2015 6:02am

Hi ,

According to your description, you want to sort the order of the attributes list in dimension. Right?

In Analysis Services, the order of all attributes is Alphabetically sorted in a dimension. And it's not supported to change the order, no matter in SSDT or SSMS.

For your requirement, it can't be achieved currently. I recommend you submit a feature request to Microsoft at https://connect.microsoft.com/SQLServer so that we can try to modify and expand the product features based on your needs.

Regards,

Free Windows Admin Tool Kit Click here and download it now
July 22nd, 2015 10:24pm

Thanks for your response Simon_Hou.
July 23rd, 2015 1:40am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics