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 application) and set the Governing Rules | Default | Result Sets parameters (as in the following screen capture):
Intelligent Cubes:
128000All other reports:
128000
This setting will allow us to create a cube bigger than 32,000 rows.
Note
Please...
