Understand the Cube.Settings Worksheet: Properties

The following table shows the fields, values and descriptions for the Properties section on the Cube.Settings worksheet:

Table A-2 Properties Section of the Cube.Settings Worksheet

Property or Field Valid Values Description
Application Type
  • ASO
  • BSO

This is an application property.

Defines whether the cubes in the application use aggregate storage (ASO) or block storage (BSO).

Outline Type
  • Unique
  • Duplicate

This is a database property.

  • Unique: member names in the outline must be unique.
  • Duplicate: Duplicate member names are permitted in the outline.
Aggregate missing values
  • Yes
  • No

This is a database property.

Defines whether missing (#MISSING) values are aggregated during a cube calculation.

Create blocks on equations
  • Yes
  • No

This is a database property.

If you enter Yes, then when you assign a nonconstant value to a member combination for which no data block exists, a data block is created. Entering Yes can produce a very large cube.

Sometimes, new blocks are not desired; for example, when they contain no other values. In large databases, creation and processing of unneeded blocks can increase processing time and storage requirements.

For more specific control, you can use the SET CREATEBLOCKONEQ calculation command within a calculation script to control creation of blocks at the time the command is encountered in the script. See the SET CREATEBLOCKONEQ calculation command.

Two-Pass calculation
  • Yes
  • No

This is a database property.

If you enter Yes, then after a default calculation, members that are tagged as two-pass are recalculated, overwriting the aggregation results from the first calculation pass. The two-pass tag is effective on members of the dimension tagged as Accounts and on Dynamic Calc and Dynamic Calc and Store members of any dimension.

Date Format

The following date formats are supported in application workbooks:

  • month dd yyyy
  • mm/dd/yy
  • yyyy-mm-dd
  • mon dd yyyy
  • yy.mm.dd
  • dd.mm.yy
  • mm-dd-yy
  • mm/dd/yyyy
  • dd/mm/yy
  • dd-mm-yy
  • dd Month yy
  • Month dd, yy
  • mon dd, yy
  • dd mon yyyy
  • yy/mm/dd
  • dd Month yyyy
  • yyyy/mm/dd
  • dd-mon-yy
  • dd mon yy

This is a database property.

Date measures enable cell values in the form of a formatted date. The date values are stored internally as numeric values, although you load them into Essbase as formatted date strings. When queried, date measures are displayed according to the selected date format.

Implied Share
  • Force On
  • Force Off

If you select Force On, the parent is treated as an implied share when it has only one child or when it has only one child that consolidates to the parent.

If you select Force Off, Essbase never uses Implied Share. This is the default behavior.

Scenario Sandboxes
  • 0
  • A positive integer less than 1000.

This value defines whether the cube contains a sandbox dimension for creating scenarios of the data, and the number of sandbox members within the sandbox dimension. A value of 0 indicates no sandbox dimension.

You can modify the Properties section on the Cube.Settings worksheet in the Designer Panel. See Work with the Cube.Settings Worksheet: Properties in Cube Designer.