Cube Object

Discussion

Use this object to change the properties of a cube. Each cube defined in a model gives users a multidimensional view of the underlying data through PowerPlay®. To create Cube objects, use the Add method of the Cubes collection.

Use the CreateMDCFile method to create the PowerCube file (.mdc). Use the CreateMDCFiles method of the Model object to create all .mdc files in the model.

Users need only log on once in a session to view any number of cubes and reports associated with their custom view.

To save changes to the properties of this object, use the Update method.

Users can publish either a data source or a package using the PublishDatasource or PublishPackage methods. When publishing a package, the data source is also be published by default. Users have the option to choose whether to overwrite the data source or package when publishing.Users can assign custom views to each cube. Custom Views contain security information.

Related Topics

These tables list related collections, methods, and properties.

Method	Description
AddDeployLocation Method	Adds a new deployment location for Copy and Activate
ClearDeployLocations Method	Removes all deployment locations.
CreateMDCFile Method	Creates a PowerCube file (.mdc) based on the cube definition.
Delete Method	Deletes the Cube object.
DeployCubes Method	Deploys a PowerCube to all deployment locations.
PublishDatasource Method	Publishes the Datasource connection for a PowerCube to the IBM® Cognos® Analytics server.
PublishPackage Method	Publishes the Package for the PowerCube to the IBM Cognos Analytics server.
RemoveCubeCustomView Method	Removes the custom view from the cube.
SetDeployType Method	Sets the deployment type for Copy and Activate.
Update Method	Updates the Cube object.

Property	Description
AllowDrillThrough Property	Sets or returns whether a cube or measure can drill through to a cube or report.
AlternateQueryPath Property	Sets or returns an alternative data source path used by the cube. When using the AlternateQueryPath property, you must provide name of the data source and the path to the datasource.
AltMDCFile Property	Sets or returns the alternate file name for the cube.
Application Property	Returns the Transformer Application object.
BlockParentTotals Property	Returns a denied value for parents of excluded children.
CacheCrossTabs Property	Sets or returns whether summaries are cached for the initial PowerPlay crosstab in the cube.
CompressMDC Property	Sets or returns whether the cube is compressed for compact storage.
Consolidate Property	Sets or returns how a cube is consolidated.
CubeCreation Property	Sets or returns whether the cube is created.
CubeCustomViews Property	CubeCustomViews property description.
CubeStamp Property	Returns a cube creation time-stamp.
DataSourceWindowsLocation Property	Sets or returns the Windows location of the PowerCube on the IBM Cognos Analytics server.
Description Property	Sets or returns the description of the Cube object.
DesiredPartitionSize Property	Sets or returns the desired partition size when auto-partitioning is enabled.
DimensionView Property	Sets or returns the View object associated with a cube or custom view.
DimensionViewType Property	Sets or returns which dimensions and views belong in a cube.
DrillThroughTargets Property	Returns a collection of DrillThroughTarget objects associated with a Cube object.
EstimatedRows Property	Sets or returns an estimate of the number of records that the cube contains before auto-partitioning.
IncrementalUpdate Property	Sets or returns whether the cube is incrementally updated from the data source.
IsMDCInUse Property	Returns whether a child cube is in use or being rebuilt.
MaxNumPartLevels Property	Sets or returns the maximum number of times Transformer reads the data source during cube partitioning.
MDCFile Property	Sets or returns the name of a PowerCube file (.mdc).
MeasureInclude Property	Sets or returns the name of a measure to include in the Cube object.
MeasureName Property	Sets or returns a descriptive title that identifies a measure on the PowerPlay dimension line.
Name Property	Sets or returns the name of the object.
Optimize Property	Sets or returns the current cube optimization option.
Parent Property	Returns the parent object.
Password Property	Sets a case-sensitive password for the cube.
Server Property	Sets or returns whether a cube is processed locally or on a server.
Signon Property	Sets or returns the Signon object used by the cube.
Status Property	Returns a problem status associated with the cube the last time it was created.
Type Property	Returns the object type.
UseAltMDCFile Property	Sets or returns whether a temporary file name may be used.

Examples

objCube = objModel.Cubes.Item(1)