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?
In the dimension designer select each attribute. Then set OrderBy=Key. Redeploy.