Build a Subset of Your Cube Data for Testing Purposes

You can generate categories and create a cube that uses a subset of your source data, to obtain a smaller, more quickly built cube for testing purposes.

For example, suppose your model uses the following database sources:

  • Customers (9,400 structural records)
  • Products (1,720 structural records)
  • Daily Sales (350,000 transactional records)

To create a quick test build, include only the first 350 records from each data source.

Note: When the number of test rows in the data source is limited to slightly more or fewer than 15 rows, Cognos® Transformer generates extra categories in the model. The extra categories are labeled with numbers instead of proper category labels. This problem exists only when running test builds; when the complete cube is built, Cognos Transformer correctly processes all the rows from all the queries.

Procedure

  1. From the Run menu, click Test Build.
  2. In the Number of records to process box, type the number of records to be read from the source.
  3. Click either Generate categories only or Create PowerCubes.
  4. Click OK.