<index>

Defines an optional, custom index that you add to the fact table generated for a Business Intelligence cube. The system does not use this index (because it automatically adds the indices that it needs). You can add a custom index if you plan to access the fact table via SQL.

Details

The system does not use this index (because it automatically adds the indices that it needs). The custom index may be helpful if you plan to access the fact table via SQL.

The <index> element has the following contents:

Attribute	Purpose
name, displayName, description, disabled	See Common Attributes in a Cube.
type	Specifies the type of index. Use "bitmap", "bitslice", "index", or "key".
properties	Specifies the fields of the fact table on which this index is based. Specify a comma-separated list of properties of the fact table class.

Tip:

Remember that you can specify the factName attribute for most levels and measures, to control the names of the properties in the generated fact table class.

Example

<index name="IndexName" type="bitmap"  properties="MxAge,DxGender"/>