Cube Settings

The Cube Settings section on the Cube Config page contains configuration that applies to the cube as a whole.

These settings are separate from the configuration of individual dimensions.

To access Cube Settings:

Open Casabase Cube in Snowsight.
Select Cube Config from the navigation.
Select the cube you want to configure.
Expand Cube Settings.

Cube Information

Casabase Cube displays information about the cube and, where applicable, the source artifacts used to create or load it.

Depending on how the cube was created, this information can include:

Information	Description
Dialect	The multidimensional cube dialect associated with the cube, such as `ASO`.
OTL Source	The source Essbase outline when the cube was created from an imported `.otl` file.
Outline Import Information	The Snowflake user and timestamp associated with the most recent outline import.
Data Source	The source location associated with the most recent cube data load.
Data Load Information	The Snowflake user and timestamp associated with the most recent data load.
Rows Loaded	The number of rows loaded from the source, where available.

For example, a cube created from an Essbase outline and native level-0 export might show:

Dialect:       ASO
OTL Source:    Sample.otl

Data Source:
@"MY_DATABASE"."MY_SCHEMA"."EPM_STAGE"/ASOsamp/Sample/data/

Rows Loaded:
1,249,859

This information provides traceability to the source artifacts used to create or refresh the cube.

Cube-Level Settings

The following settings apply to the cube as a whole:

Setting	Description
Data Classification	Data sensitivity classification for the cube: `INTERNAL`, `CONFIDENTIAL`, `RESTRICTED`, or `PUBLIC`.
Row Limit	Maximum number of rows that can be returned by a cube query.
Apply member formulas	Controls whether member formulas are evaluated during query processing.
Build lock timeout (minutes)	Configures the build lock timeout for the cube.

Data Classification

Data Classification identifies the sensitivity classification associated with the cube’s data.

Casabase Cube supports the following classifications:

Classification	Intended Use
`INTERNAL`	Data intended for internal organizational use.
`CONFIDENTIAL`	Sensitive business data requiring controlled access.
`RESTRICTED`	Highly sensitive data requiring the strongest access restrictions.
`PUBLIC`	Data approved for public access or distribution.

The classification applies to the cube as a whole.

Select the classification that corresponds to your organization’s data governance and information classification policies.

Row Limit

Row Limit controls the maximum number of rows that can be returned by a cube query.

For example:

Row Limit: 10000

can be used to limit unexpectedly large result sets.

The current value is displayed directly in Cube Settings and can be adjusted as appropriate for the cube’s expected query workloads.

Apply Member Formulas

Apply member formulas controls whether member formulas defined in the cube are evaluated during query processing.

When enabled, Casabase Cube applies configured member formulas as part of multidimensional calculation.

When disabled, member formulas are not applied.

This setting applies across the cube rather than to an individual dimension.

For more information about formulas and calculation behavior, see Formula Capabilities.

Build Lock Timeout

Build lock timeout (minutes) configures the build lock timeout for the cube.

The value is specified in minutes.

Build locking is used during operations that modify or rebuild cube structures. The timeout setting provides cube-level control over that behavior.

See Rebuilding Dimensions for more information about dimension rebuild operations.

Saving Cube Settings

After modifying cube-level settings, select Save Cube Settings to apply the changes.

The saved settings apply to the selected cube.

Source Information vs. Cube Storage

The Data Source shown in Cube Settings identifies the source used for the cube’s data load.

It does not represent an external fact table that Casabase Cube queries when QUERY_CUBE executes.

After data is loaded, Casabase Cube manages the cube data within the Casabase Cube Native Application database in the customer’s Snowflake account.

Conceptually:

Source Data
    │
    │ Load
    ▼
CASABASE_CUBE
Native Application Database
    │
    ├── Cube Data
    │
    └── Cube Metadata
            │
            ▼
        QUERY_CUBE

Clients therefore do not need to specify a physical data table when querying the cube.

For more information, see Data Storage & Boundaries.

Essbase and Cloud EPM Source Information

For cubes created from Oracle Essbase or Oracle Cloud EPM, Cube Settings provides additional traceability to the source artifacts used to build and load the cube.

OTL Source

The OTL Source identifies the Essbase outline used to create the multidimensional model.

For example:

OTL Source: Sample.otl

Casabase Cube also records information about the outline import, including the Snowflake user and timestamp associated with the import.

Data Source

The Data Source identifies the staged location from which the cube data was loaded.

For example:

@"MY_DATABASE"."MY_SCHEMA"."EPM_STAGE"/ASOsamp/Sample/data/

The displayed information can also include:

The number of rows loaded
The Snowflake user who performed the load
The date and time of the load

Together, the OTL Source and Data Source provide visibility into the metadata and data artifacts used for the current cube.

See Oracle Essbase & Cloud EPM Migration for the complete migration workflow.

Cube Settings vs. Dimension Settings

Cube-level settings should not be confused with the configuration associated with individual dimensions.

Each dimension has its own Column Mapping & Settings section.

Dimension-level configuration can include:

Dimension definition table
Parent column
Child column
Alias column
Operator column
Shared member column and value
Formula column
Time dimension designation
Time Balance column
Time Balance Skip column
Sort order column
Default member
Dimension solve order
Security
Automatic rebuild behavior
Active status

These settings define how Casabase Cube interprets the dimension definition table and constructs the dimension and its hierarchy structures.

Conceptually:

Cube
│
├── Cube Settings
│   ├── Data Classification
│   ├── Row Limit
│   ├── Apply Member Formulas
│   └── Build Lock Timeout
│
├── ACCOUNT
│   └── Dimension Settings
│
├── ENTITY
│   └── Dimension Settings
│
├── PERIOD
│   └── Dimension Settings
│
└── YEARS
    └── Dimension Settings

Cube Settings affect the cube as a whole, while dimension settings control the configuration and behavior of individual dimensions.

Hierarchies within those dimensions define member relationships, navigation paths, and aggregation structures.

Cube Operations

The Cube Config page also provides access to operations that affect the selected cube.

These include:

Rebuild Dimensions
Clone Cube
Drop Cube
Advanced operations where applicable

These are cube lifecycle operations rather than persistent Cube Settings.

See:

Key Takeaways

Cube Settings apply to the cube as a whole.
Cube Settings are separate from the configuration of individual dimensions.
Data Classification supports INTERNAL, CONFIDENTIAL, RESTRICTED, and PUBLIC.
Data Classification describes the sensitivity of the cube’s data; it is separate from data access controls.
Row Limit controls the maximum size of cube query result sets.
Apply member formulas controls whether member formulas participate in query processing.
Build lock timeout configures build-lock behavior at the cube level.
Cube Settings also provide source and load information where available.
For Essbase and Cloud EPM migrations, this includes the source outline and staged data source.
The displayed Data Source identifies where loaded data originated; it is not the physical table used by QUERY_CUBE.
Cube data is managed within the Casabase Cube Native Application database in the customer’s Snowflake account.
Individual dimensions have their own configuration settings.
Hierarchies define member relationships and aggregation structures within dimensions.

Next Steps

Continue with:

Adding Dimensions for dimension-level configuration.
Rebuilding Dimensions for rebuilding multidimensional structures after dimension definition changes.
Formula Capabilities for member formula behavior.
Data Storage & Boundaries for details about cube data storage.