SQL Server Performance Forum – Threads Archive

Controlling the display order

Hi, Using an old system, my users were accustomed to reports in which the customers were always listed in a certain order (i.e. they were listed based on the ‘custcode’ field). Now they have this new "data cube" solution which they very much like except for one thing i.e. the customers are not listed in the same order (which they are used to)… I would like to use the same approach that was used in the reports of the old system but do not wish to display the customer code field/column. Can I somehow hide it so that only the customer names are listed BUT based on the ascending or desc. order that I will define on the ‘custcode’ field. Thanks in advance.

Yes you can. You just need to open up Analysis services manager and go into Dimension editor. Choose your customer dimension and in advanced properties you can choose the sorting order in your case CustCode. Raulie

Thanks Raulie.
You mean specifying the sort order using the ‘Order By’ option under Advanced Properties. Right?

Yes I believe so. Raulie

]]>