CODEWITHSUNDEEP
ssas
Faiz
Faiz

Reputation: 283

How to sort a numeric dimension in ssas

In one of my dimensions I have 4 columns with the data type tinyint but in ssas after processing the cube, its been assigned the data type system.byte. I dont know it did that. And because of this my data sort is like 1, 10, 2 etc. but I want it to be 1, 2, 3 etc. How can I overcome this issue?

Upvotes: 2

Views: 1003

Answers (1)

GregGalloway
GregGalloway

Reputation: 11625

In the dimension designer select each attribute. Then set OrderBy=Key. Redeploy.

Upvotes: 2

Related Questions