You can browse a cube through the cube browser in Analysis Services or through the one in the Management Studio. I usually use the one in the Management Studio, as it gives your more space to look. In the cube I created in Analysis Services, I added a Budget hierarchy in my Budget dimension. I decided to check the data for the new hierarchy in comparison to the money that was assigned to it in the Budget fact table. And it was problematic… I was opening the Budget hierarchy and in the first 3 levels...
…like for instance, it could all of a sudden turn into a ball! J Ok bad computing joke. So this time around I thought I'd tell you about a weird incident I had with my cube. I found out I could see my cube in the Management Studio and even browse it, but when trying to run an MDX on it (again, in the Management Studio) it would tell me I didn't have any cubes for the MDX to run on.. I could still run MDX scripts on it in my SSAS project so I continued as usual, thinking to myself only that this is...