CubeUpdate

The CubeUpdate verb updates an existing PowerCube by modifying the PowerCube object in the Cognos® Transformer model.

To create or update an .mdc file, see CreateFiles.

The user interface equivalent is to modify the PowerCube property sheet.

For more information about updating PowerCubes, see CubeMake.

The syntax is as follows:

CubeUpdate objCube [powercubeopts] [DimensionView objDim 
objView ][MeasureInclude objMeasure meaopt]

Argument

Description

CubeUpdate objCube

Specifies the PowerCube to update. objCube can be the object name, object identifier, or both.

powercubeopts

Optional parameters that describe the cube in greater detail. For the complete list of options, see powercubeopts. If the cube exists, previously set options are retained unless you change them with this command.

DimensionView objDim objView

Specifies the dimension and dimension view. objDim can be the object name or object identifier. objView can be the object name, object identifier, or both. Repeat this argument to specify multiple views, as in

DimensionView "Years" "All Categories" 
DimensionView "Products" "All Categories"

MeasureInclude objMeasure meaopt

Specifies the measure. objMeasure can be the object name, object identifier, or both. meaopt must be one of Yes, Indirect, or No. Repeat this argument to specify multiple measures, as in

MeasureInclude 159 Yes 
MeasureInclude 175 No

Example

This example modifies the PowerCube Great Outdoors Company Sales by enabling drill-through, changing the dimension view to Omit Dimension and excluding the Revenue measure.

CubeUpdate "Great Outdoors Company Sales" MdcFile "c:\outdoors.mdc" 
DrillThrough True EndList DimensionView "Products" "Omit Dimension" 
MeasureInclude "Revenue" Indirect