SQL Server Performance

Controlling the display order

Discussion in 'Analysis Services/Data Warehousing' started by Joozh, Apr 13, 2006.

  1. Joozh New Member

    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.
  2. Raulie New Member

    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


  3. Joozh New Member

    Thanks Raulie.
    You mean specifying the sort order using the 'Order By' option under Advanced Properties. Right?
  4. Raulie New Member

    Yes I believe so.

    Raulie



Share This Page