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.
Update the PowerCube Metadata
During PowerCube creation, all the source data is read, categories are generated in
accordance with the model structure, and the data is written to a cube file (.mdc)
for use in the OLAP reporting components.
There are several factors that affect the time it takes to create a PowerCube,
including partitioning, cube optimization, incremental updates, the size of the
cube, and, most importantly, the number of data sources.
There is other data in the model that is not dependent on the category generation
process. Referred to as metadata, this related information includes
v object names
v short names
v descriptions
v drill-through items
v custom views
You can use the Update Selected PowerCube command from the Run menu to
quickly update this related information for an existing cube without affecting the
main cube data.
For example, suppose your PowerCube production schedule involves recreating a
cube monthly, while your transactional data source is updated weekly. You set up
drill through so your users can see, on the first week of each month, the first
weekly report; on the second week, the first and second weekly reports; and so on.
Although you only create the full PowerCube once a month, you can update its
related information weekly by adding the extra drill-through report for the
required measure.
Procedure
1. In the PowerCubes list, select the cube whose metadata you want to update.
2. From the Run menu, click Update Selected PowerCube.
3. In the Update PowerCube dialog box, select the items you want to update.
4. Click OK.
Check Cube Status
After your PowerCubes or cube groups are created, you can check their status
before you deploy them to your OLAP report users. You can also apply a filter in
the PowerCube Status dialog box to focus on the cubes that need attention at any
particular point in the cube customization process.
144 IBM Cognos Transformer Version 10.1.1: User Guide
To Next Page
Loading...
Need help?
General