How to change dimension display oder

Muhammad Shami 61 Reputation points
2020-10-02T07:29:51.65+00:00

How could I change the dimensions order of SSAS project as I wanted ? I try to drag them but it not works. Is there any setting somewhere in visual studio that I havenot found ?

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,260 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,821 Reputation points
    2020-10-02T07:49:48.37+00:00

    Hi,

    There no such settings in VS to change the dimension order.
    Normally the work around would be adding prefix to the dimension name such as
    [01- Product];
    [02-Date];
    [03-Customer]
    ...etc.

    Regards,
    Lukas

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. Olaf Helper 43,161 Reputation points
    2020-10-02T12:00:40.113+00:00

    You can change the orders of dimension in the Cube with drag & drop of a dimension, or Right-mouse click on the cube dimension => Up/Down.
    But most clients like MS Excel ignores the defined order and order them alphabetically on its own.

    0 comments