First Login & Orientation

After Casabase Cube has been installed and your Snowflake role has been granted the appropriate Casabase Cube application role, you can open the application from Snowflake.

Open Casabase Cube

Sign in to Snowsight.
Open the installed applications available in your Snowflake account.
Select Casabase Cube.
Casabase Cube opens to its Home page.

Home

The Home page is the starting point for Casabase Cube.

For a new environment, the page provides a Get Started workflow that can guide an Oracle Essbase or Oracle Cloud EPM migration.

At a high level:

Import Outline
      │
      ▼
Build Dimension Structures
      │
      ▼
Import Native Level-0 Data
      │
      ▼
Query the Cube

Each applicable step can also expose a SQL alternative for scripted or automated workflows.

See 5-Minute Quick Start for the complete walkthrough.

Main Application Areas

The exact labels can evolve as the application UI changes, but the primary areas include functionality for:

Area	Purpose
Home	Entry point and guided setup workflows.
Query Builder	Build and run multidimensional queries visually.
Cube Config	Create cubes and manage cube and dimension configuration.
Variables & Saved Queries	Manage cube variables and reusable query definitions.
Administration	Manage application security, governance, diagnostics, and operational functions.
Log / Audit information	Review available application activity and operational information.
Help	Access product guidance from within the application.

Some areas are visible only to users with administrative privileges.

What Your Role Allows

Casabase Cube provides two primary application roles.

`CUBE_PUBLIC`

CUBE_PUBLIC is intended for users and applications that need query and discovery capabilities.

Typical activities include:

Running multidimensional queries
Using Query Builder
Discovering cubes and dimensions
Reading supported secure views

`CUBE_ADMIN`

CUBE_ADMIN inherits CUBE_PUBLIC and adds modeling and administrative capabilities.

Typical activities include:

Creating and configuring cubes
Creating and rebuilding dimensions
Loading data
Managing formulas
Managing security
Scheduling supported operations
Reviewing administrative information

See Roles and Privileges for details.

Choose Your Next Workflow

Migrating from Oracle Essbase or Oracle Cloud EPM

Use the Home-page Get Started workflow.

You will generally need:

The native Essbase outline (.otl)
A native level-0 data export
A Snowflake stage accessible to Casabase Cube for the data import

Start with 5-Minute Quick Start.

For source-specific instructions, see:

Creating a Cube from Snowflake Data

Oracle Essbase or Cloud EPM is not required.

Casabase Cube can create a multidimensional model from Snowflake data using dimension definition tables and cube configuration.

See Creating a Cube from Snowflake Data.

Querying an Existing Cube

If your environment is already configured, continue with:

Query Builder for interactive analysis.
Querying with SQL for programmatic access.