Understand the Essbase.Cube Worksheet

The Essbase.Cube worksheet in an application workbook defines the application and cube name, as well as dimensional information – such as dimension names, types, storage (dense or sparse), and outline order – when you build the cube from Cube Designer or the Essbase web interface.

The following image shows the Essbase.Cube worksheet in a sample application workbook.


Image of the Essbase.Cube worksheet in an application workbook.

Table A-1 Essbase.Cube Worksheet Fields and Values

Property or Field Valid Values Description
Application Name
  • The application name must not exceed 30 characters.
  • Do not use spaces.
  • Application names are not case-sensitive.
  • The following special characters are not allowed: % $ - { } ( ) ! ~ ` # & @ ^

Enter the name of the application.
Database Name
  • The cube name must not exceed 30 characters.
  • Do not use spaces.
  • Cube names are not case-sensitive.
  • The following special characters are not allowed: % $ - { } ( ) ! ~ ` # & @ ^

Enter the name of the cube.
Version

This must be a positive integer.

This is the application workbook version.
Dimension Name

Dimension names cannot be the same as the cube name.

Enter the name of each dimension. There must be at least two dimensions in a cube. For block storage, one dimension must be a dense dimension.

Use no more than 1024 characters when naming dimensions, members, or aliases.

The following special characters are not allowed: @, ., ,, !, {, }, [, ]. /, \, *.
Dimension Type
  • Time
  • Accounts
  • Regular
  • Attribute-Boolean
  • Attribute-Numeric
  • Attribute-Text
  • Attribute-Date

Describes the type of dimension. Regular is the Default. Per cube, you can only use one Time and one Accounts dimension type.
Dimension Storage
  • Dense
  • Sparse

Sparse is the default.

There must be at least one dense dimension.
Outline Order

This must be a positive integer.

This is the order of the dimension in the outline.

Attribute dimensions must be ordered after base dimensions.
Base Dimension

This must be an existing dimension name.

This is the dimension pairing for the attribute dimension.

You can modify the Essbase.Cube worksheet in the Designer Panel. See Work with the Essbase.Cube Worksheet in Cube Designer.