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
Summary of Contents for Cognos
Page 1: ...IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 106: ...92 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 136: ...122 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 160: ...146 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 174: ...160 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 326: ...312 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 352: ...338 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 394: ...380 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 398: ...384 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 411: ...Y year function 362 years between function 362 Index 397 ...