<div>
Hi Ken.<br />
<br />
Have you looked into SSAS Display Folders? They are more flexible than people usually think: <br />
<br />
<a href="https://devinknightsql.com/2011/12/20/ssas-display-folders/" rel="ugc">https://devinknightsql.com/2011/12/20/ssas-display-folders/</a>
</div>


Hi Ken.

Have you looked into SSAS Display Folders? They are more flexible than people usually think:

https://devinknightsql.com/2011/12/20/ssas-display-folders/ [https://devinknightsql.com/2011/12/20/ssas-display-folders/]

<div>
Hi bcnagel,<br />
<br />
this is for measures, what about dimensions?
</div>


Hi bcnagel,

this is for measures, what about dimensions?

<div>
When it comes to dimensions, during cube development you can set any ordering of dimensions that you would like (using the Cube Structure tab), but in my experience Excel ignores that ordering. What about naming your dimensions such that their alpha order is the order your users want?
</div>


When it comes to dimensions, during cube development you can set any ordering of dimensions that you would like (using the Cube Structure tab), but in my experience Excel ignores that ordering. What about naming your dimensions such that their alpha order is the order your users want?

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I'm developing a SSAS 2012 cube and the users require to see dimensions and measures are some logical order on there Pivot view from the excel. the order of display is business requirement, I should be able to do that what ever order they ask.<br />
<br />
So, it should be control from the SSAS cube.<br />
<br />
Can we achieve this and how? &nbsp;Please help.
</div>
</div>


Hi,

I'm developing a SSAS 2012 cube and the users require to see dimensions and measures are some logical order on there Pivot view from the excel. the order of display is business requirement, I should be able to do that what ever order they ask.

So, it should be control from the SSAS cube.

Can we achieve this and how?  Please help.

SSAS Cube customise the default structure how the display  the dimensions and measure from excel output

SQL Server Analysis Services (SSAS) is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. Analysis Services includes a group of OLAP and data mining capabilities and comes in two flavors - Multidimensional and Tabular.