Dimension Attribute Sorting in Analysis Services

Question

Hi, I built a Cube in Analysis Services with year and months dimensions.

My problem is the sorting of the months while browsing the cube and later in reporting services. The months are displayed following: 1, 10, 11 12, 2 ,3.....

How can I avoid this?

Answer 1

Hello,

You should you question to a more related forum like http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/threads

You attributes are order textual, not numerical. If it's is a numeric value, then you have to change the OrderBy property from "Name" (=text) to "Key" (=numeric value).

See:
Dimension Attribute Properties Reference => OrderBy
Specify Attribute Ordering (Business Intelligence Wizard) (SSAS)

and also Sorting Attribute Members Based on a Secondary Attribute

---

Olaf Helper
Blog Xing

Answer 2

Ok, thanks.

Answer 3

Hello JO_MO,

Wir gehen davon aus, dass die Antwort Dir weitergeholfen hat.
Wenn ja, wäre es hilfreich wenn Du diese Lösung bestätigen würdest.

Gruß,

Ionut