1
vote
0answers
50 views

how declaring `hierarchies and level` in SSAS help to improve MDX Query performance?

how declaring hierarchies and level in SSAS help to improve MDX Query performance? I use SQL Server 2008 R2 and I use SSAS and I reading book Professional Microsoft SQL Server Analysis Services 2008 ...
1
vote
0answers
158 views

how i can auto format mdx query in sql server [closed]

I Use SQL Server 2008 R2 And SSAS. I write/edit MDX Query and in some case complex i need format my MDX Query like Key (Ctrl+K)(Ctrl+Y) in SQL Tools Belt. after very search i find this site ...
1
vote
0answers
105 views

Need to write MDX for time dimension in Mondrian

This is my Dimesion and Measure: <Dimension type="TimeDimension" foreignKey="ReqDateKey" name="Date"> <Hierarchy name="YQMD" hasAll="true" allMemberName="All Dates" ...