Business Intelligence with MicroStrategy Cookbook

Building a new cube

Creating a new cube is very similar to creating a report. We use the same editor and the same objects. There are restrictions on which objects can be used inside a cube; for example, consolidations and custom groups cannot be added to the cube definition. However, there are alternative techniques that provide the same functionalities like derived elements (check the product documentation). Now that we learned how to transform a report into a cube, we will try to create a new one from zero. And this time we want it bigger.

Getting ready

Out of the box the limit for a cube dataset is 32,000 rows. We need to change that in order to do this recipe. Go to the Project Configuration window (right-click on the project name in the Desktop ...