Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Analysis Services

Changing Ordering of a Dimension Attribute

I have a dimension attribute called Month. It is sorting alphabetically instead of based on it's underlying key value. How do I change this?

Thanks,

Chris

[160 byte] By [ChrisKinsman] at [2008-2-4]
«« Query result does not show all the work items for some users
»» ExtendedDN usage?
# 1
Change the order by from "Name" to "Key". No idea what "Attribute Name" and "Attribute Key" do however.
ChrisKinsman at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Analysis Services...
# 2
If you choose attribute name, you can define the order by another field.
I have in each dimension an order field and I have configured each dimension to sort by this field. By default I fill in this field with name. But if a user request another order I can change values in this field without changing dimension structure.
VectorR3 at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Analysis Services...
SQL Server
SQL Server Analysis Services

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified