Maintenance Utilities

The procedures in this section are maintenance and recovery tools rather than normal application operations. Use them only for the specific situations described below.

REVERT_DIMENSION_RENAME

Minimum role: CUBE_ADMIN

REVERT_DIMENSION_RENAME(P_CONFIRM) -> VARCHAR

Rolls back the hierarchy-to-dimension rename migration applied during an application upgrade.

This is a recovery utility and is not part of normal Casabase Cube operation.

Parameters

Parameter	Type	Req/Opt	Description
P_CONFIRM	BOOLEAN	opt	Must be TRUE to perform the rollback.

Caution

Use REVERT_DIMENSION_RENAME only when instructed by Casabase support and only when the hierarchy-to-dimension rename has caused a specific problem that cannot otherwise be resolved.

Reverting restores earlier object names that the current application version does not expect.

Example

Preview the operation first:

CALL CUBE.REVERT_DIMENSION_RENAME(FALSE);

Only proceed with the rollback when instructed by support:

CALL CUBE.REVERT_DIMENSION_RENAME(TRUE);