You use the Essbase tab to set preferences for locking Essbase objects, executing operations in the background, and associating outlines with editors.
In the “When opening the Essbase objects” box, you specify the lock-unlock setting that is applied when objects (such as calculation and report scripts are opened):
Always lock object—Other users cannot modify, rename, or delete locked objects.
Never lock object—Users can modify, rename, and delete objects that are not locked.
Prompt me to lock object—This option is selected by default.
Note: | All outlines opened in Outline Editor are locked. |
In the “When executing calculation scripts” list, you select a background-process option that applies to full database and calculation-script calculations:
Always calculate in background—As a calculation processes, you can continue working or exit the console. When you launch a calculation, an ID for the process is displayed. You can use the ID to track the status of the process in the Background Process Status window.
Always wait for calculation to finish—You cannot continue working or exit the console until the calculation finishes.
Prompt me to calculate in background—This option is selected by default.
In the “When executing report scripts” list, you select a background-process option that applies to report execution:
Always execute report in background—As a report is executed, you can continue working or exit the console. When you initiate execution of a report, an ID for the process is displayed. You can use the ID to track the status of the execution in the Background Process Status window.
Always wait for execution of report to finish—You cannot continue working or exit the console until the report execution is completed.
Prompt me to execute report in background—This option is selected by default.
In the “When executing data loads/dimension builds” box, you select a background-process option that applies to data loads and dimension builds:
Always execute data load/dimension build in background—As the data load or dimension build processes, you can continue working or exit the console. When you initiate the process, an ID is displayed. You can use the ID to track the status of the process in the Background Process Status window.
Always wait for execution of data load/dimension build to finish—You cannot continue working or exit the console until the data load or dimension build is completed.
Prompt me to execute data load/dimension build in background—This option is selected by default.
In the “When associating an outline in editor” group, you select an option that determines whether objects that you open in editors are associated with outlines:
Always associate with an outline
Never associate with an outline
Prompt me to associate with an outline
If you select the “Show MaxL statements in the message panel” option, in the Messages pane, all MaxL statements sent from Administration Services to Essbase Server for execution are displayed. When statements are executed, a tab that contains the statements is added to the Messages pane.