//
archives

Analysis Services

This category contains 2 posts

Issues with MSAS default members

We recently came across this confusing issue with how default members affect resultsets. If you use default members in your dimension, you may have this issue unknowingly and you should definitely check your reports which go out for validity. Its been a long standing bug-bear of mine that there’s no easy way in Excel of … Continue reading

Using AMO to administer MSAS cubes

I’ve recently been looking into using AMO to automate common configuration tasks to our MSAS cube infrastructure. In our production environment, we have multiple copies of cubes and multiple servers on which they’re stored so minimizing manual tasks was a must. Sure, all of what is being described below can be done using a combination … Continue reading

Archives