1
vote
0answers
51 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
163 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 ...
0
votes
1answer
99 views

Is it possible to drop data from OLAP database (and to keep definitions)?

[SQL Server Analysis Services from MS SQL Server 2008 R2 Standard] Our OLAP DB takes data from OLTP DB. We want to make some changes to its structure and to do this - it would be helpful if we could ...