Import & Migration

The procedures in this section support migration from Oracle Essbase and Oracle Cloud EPM. They import native Oracle Essbase outline metadata, load native data exports, and translate individual Essbase formulas into Casabase Cube syntax.

IMPORT_ESSBASE_OTL

Minimum role: CUBE_ADMIN

IMPORT_ESSBASE_OTL(
    P_CUBE_NAME,
    P_STAGE_FILE,
    P_BUILD_ATTRIBUTES
) -> VARIANT

Parses an Essbase outline file and creates the cube’s dimension source tables from it. This is typically the first application procedure used during an Oracle Essbase or Cloud EPM migration.

Parameters

Parameter	Type	Req/Opt	Description
`P_CUBE_NAME`	`VARCHAR`	req	Cube name to create.
`P_STAGE_FILE`	`VARCHAR`	req	Stage path to the native Essbase outline file.
`P_BUILD_ATTRIBUTES`	`BOOLEAN`	opt	Also build attribute dimensions.

Returns

Returns a VARIANT describing the import result.

The procedure creates dimension input tables in SHARED_DATA. After importing the outline, call REBUILD_DIMENSIONS for the cube to finalize the Casabase Cube creation.

Example

CALL CUBE.IMPORT_ESSBASE_OTL(
    'FINANCE',
    '@MY_STAGE/FINANCE.otl',
    TRUE
);

IMPORT_ESSBASE_EXPORT

Minimum role: CUBE_ADMIN

IMPORT_ESSBASE_EXPORT(
    STAGE_PATH,
    CUBE_NAME,
    IGNORE_UNKNOWN_MEMBERS,
    SOURCE_TABLE
) -> VARCHAR

Loads data from Oracle Essbase or Oracle Cloud EPM native export files into a cube’s fact table.

Supported input file types include .txt and .gz.

Parameters

Parameter	Type	Req/Opt	Description
`STAGE_PATH`	`VARCHAR`	req	Full stage path to the data file.
`CUBE_NAME`	`VARCHAR`	req	Cube name. Determines member-to-dimension mapping and the target fact table.
`IGNORE_UNKNOWN_MEMBERS`	`BOOLEAN`	opt	`TRUE` silently skips unrecognized members. `FALSE` reports them as errors.
`SOURCE_TABLE`	`VARCHAR`	opt	Preloaded table to use instead of scanning the stage. Expected columns are `file_name`, `line_num`, and `raw_line`.

Example

CALL CUBE.IMPORT_ESSBASE_EXPORT(
    '@MY_STAGE/data.txt',
    'FINANCE',
    FALSE,
    NULL
);

IMPORT_ESSBASE_FORMULA

Minimum role: CUBE_ADMIN

IMPORT_ESSBASE_FORMULA(
    P_CUBE_NAME,
    P_FORMULA_NAME,
    P_ESSBASE_FORMULA,
    P_DEFAULT_DIMENSION,
    P_HIERARCHY
) -> VARIANT

Translates a single Essbase calc-script formula into Casabase Cube syntax.

Use this procedure to translate formulas individually during a migration or to inspect how a particular Essbase construct will convert.

Parameters

Parameter	Type	Req/Opt	Description
`P_CUBE_NAME`	`VARCHAR`	req	Cube name.
`P_FORMULA_NAME`	`VARCHAR`	req	Name for the translated formula.
`P_ESSBASE_FORMULA`	`VARCHAR`	req	Essbase expression to translate.
`P_DEFAULT_DIMENSION`	`VARCHAR`	opt	Default dimension for unqualified member references.
`P_HIERARCHY`	`VARCHAR`	opt	Target dimension. This parameter retains the legacy `P_HIERARCHY` name.

Returns

Returns the translated formula together with any warnings.

Some Essbase functions do not have an equivalent Casabase Cube construct. Those functions are reported as requiring manual translation.

Example

CALL CUBE.IMPORT_ESSBASE_FORMULA(
    'FINANCE',
    'Test',
    '@SUMRANGE("Periodic","Jan":@CURRMBR("Period"))',
    'MEASURES',
    'VIEW'
);