Chapter 6. Creating PowerCubes
When you select Create PowerCubes from the Run menu, one or more
PowerCubes are generated with the default property settings. These binary files
contain all the source data for the dimensions and levels in your model.
PowerCubes generated by Cognos Transformer version 8.x and later can be used
as a data source for any IBM Cognos studio, such as Analysis Studio, Report
Studio, or Metric Studio. If the PowerCube does not have IBM Cognos security, it
can be used in IBM Cognos Series 7 PowerPlay products, and in IBM Cognos
Business Intelligence Mobile Analysis for local (disconnected) use. Once IBM
Cognos security is included, the PowerCube can only be used in the IBM Cognos
studios.
However, before you deploy your cubes, you may want to customize them. For
example, you can create cube groups where the child cubes are intended for
different users, and so contain different dimension views or subsets of the query
objects defined in your model. You can also improve performance by setting up
time-based partitioned cubes. For more information about time-based partitioning,
see “Defining a Time-based Partitioned Cube” on page 125.
When you are designing your cubes, you should evaluate the languages in which
your end users will require the cubes to be distributed. For information about cube
languages and locales, see “Managing Languages and Locales” on page 161.
Tip: We recommend that you experiment until you have a satisfactory balance
between cube build and data retrieval times. This customization may, but need not,
parallel the security-based views that you associate with your configured IBM
Cognos namespace.
You can create
v similar but different models that meet the needs of each target group, perhaps
pointing to different source files
You can then build one focused cube from each of these models.
v one model and one cube, and use dimension views to remove unwanted
categories and offer different perspectives on the data
v a group of several smaller, related cubes from one model, and control the
measures and details created in each cube
v a large time-based partitioned cube and several smaller cubes, related across a
conformed time dimension
v one large shared cube, and hide certain dimensions from some users by
implementing IBM Cognos custom views.
For more information about custom views, see Chapter 7, “Adding Security,” on
page 147.
Create a Single PowerCube
When you want to tailor the properties of a PowerCube to meet the specific needs
of users, you can manually define the cube. Examples of items that you can
customize include the location of the PowerCube or the dimensions and measures
to include.
© Copyright IBM Corp. 2007, 2011 123
To Next Page
Loading...
Need help?
General