
As you can see the image above, how to make the order like
'<10days'
'10-20 days',
'21-30 days',
'31-50 days'
'>50 days'
is it possible?

As you can see the image above, how to make the order like
'<10days'
'10-20 days',
'21-30 days',
'31-50 days'
'>50 days'
is it possible?
Hey,
There is a sort by property at column level in ssas.
So you would need to have a mapping table :
<10. 1
10-20days. 2
Etc.
Then create a relationship between the fact table and this mapping table and use the sort property and sort it by the numerical column.
Yeah I did this way. This is the reference step by step to do it. Totally helps me. Hope it help others too. <3
sql-server-analysis-services-how-to-set-the-order-by-attribute-sort-key
The easiest way I can see is to change "<10 Days" to "0-10 days" also change ">50 days" to "50 and more days". Something like this should work automatically.
Great idea Lucas, but I need to follow exact format as given by my superior. Thank for answer btw :)
4 people are following this question.
File for a cloned Vertipaq data object conflicts with a master data object file
dimension security on a combination of dimensions
integration services ne figure pas dans la liste des fonctionnalités partagées de sql server
Getting error message as "Unable to find any Microsoft OLE DB providers on the machine."
How to schedule SQL profiler to auto start/stop to capture SSAS synchronization?