Specifying maxFacts in the Cube Definition

Specifying maxFacts in the Cube Definition

While you are developing a cube, you typically recompile and rebuild it frequently. If you are using a large data set, you might want to limit the number of facts in the fact table, in order to force the cube to be rebuilt more quickly. To do this, you can specify the pMaxFacts argument for %BuildCube(); see Building the Cube in the Terminal.

Or you can specify the maxFacts attribute as follows:

1. In Studio, open the cube class.

2. Find the <cube> element:

   <cube name="HoleFoods" 
   caption="HoleFoods Sales"
   defaultListing="Listing"
   nullReplacement="Missing Value"
   actionClass="HoleFoods.KPIAction"
   sourceClass="HoleFoods.Transaction">
   

   

3. Add the maxFacts attribute to this element:

   <cube name="HoleFoods" 
   caption="HoleFoods Sales"
   defaultListing="Listing"
   nullReplacement="Missing Value"
   actionClass="HoleFoods.KPIAction"
   sourceClass="HoleFoods.Transaction"
   maxFacts="10000">
   

   

   The value that you specify determines the maximum size of the fact table.

4. Save and recompile the class.

5. Rebuild the cube.