Skip to main content

Manage Scripts

The Manage Scripts feature allows you to view, select, and execute global database scripts as part of cube preparation or maintenance tasks. Scripts can create or modify database objects, adjust data, or apply configuration changes before running cube jobs. You can review scripts, run them in a chosen environment, and monitor execution results.

When to manage scripts​

  • Applying configuration changes: Adjust system settings or apply updates that support cube processing.
  • Resolving data issues: Correct or cleanse source data before a refresh or load job.
  • Preparing database objects: Create or modify tables, views, or procedures needed by the cube before loading data.

Make the cube editable​

  1. In the Administration page, select OLAP Manager from the sidebar.
  2. In the cube list, select the cube where you want to configure tracking.
  3. Clear the In Production checkbox.
  4. Click Save.

Manage scripts​

  1. In the Options panel on the right, click the General icon.
  2. Select Manage Scripts.
    Or right-click the Workspace and select Manage Scripts.
  3. In Global Scripts, click to select scripts you want to execute. They will move to the Scripts to Execute list.
  4. In Scripts to Execute, review the selected scripts.
  5. Click the magnifying glass next to a script to preview its content.
  6. Click Execute.
  7. Select the target environment and click Confirm.
  8. Enter any required parameters in the Parameters dialog.
  9. Click Run.

Review execution report​

  1. In the Execution Report dialog, locate the script you want to review.
  2. Click the success or error icon to open details.
  3. Review execution results in the Manage Scripts details window.
  4. Click Cancel, then Save.

Manage Scripts fields​

FieldDescription
Environment DescriptionName of the environment where the script ran.
Script DescriptionText label identifying the script.
Server TypeDatabase server type where the script is intended to run (for example, SQLSERVER, ORACLE).
Script ContentSQL code or commands contained in the script.
Revert Script ContentSQL code used to undo the effects of the script.
Error MessageDetails of any error encountered during execution.