Overriding Standard Data Load SQL

Use this dialog box to edit the standard SQL statements generated by Essbase Studio for use during the data load process.

Tip:

Review the Data Load SQL Override Editing Guidelines for tips on editing the standard data load SQL.

  To override the standard data load SQL statements:

  1. Access the Essbase Model Properties dialog box using the procedure in Accessing the Essbase Model Properties Dialog Box.

  2. Click the Custom data load settings button to access the Define Data Load Settings dialog box.

  3. Select Use Custom SQL for data load.

  4. Optional: To see the SQL statements as a folder, select the View statements as folder option.

    By default, the SQL statements in the left text box are displayed as a list.

  5. In the left text box, highlight the SQL statement you want to modify.

    Note:

    It is not necessary to highlight the entire SQL statement. When you highlight a portion of an SQL statement to copy and paste to the right text box (see the next step, below), the entire statement will be copied and pasted.

  6. Use the direction button to paste a copy of the SQL statement in the right text box.

  7. Edit the SQL statement.

    Note:

    As you modify SQL statements, the total number of statements modified is displayed in the Modified statements message.

  8. Click OK.

    Note:

    If you have edited the data load SQL, and then want to use the standard data load SQL, simply clear the “Use Custom SQL for data load” check box. Your customized SQL is retained, but not used.