Skip Headers
Previous
Previous
 
Next
Next

Using SQL Developer for OLAP Development

You can choose between two tools for creating and managing dimensional objects:

Locating the OLAP Extension

The OLAP extension is available in SQL Developer 4.0. It does not run in Release 3.2 or earlier releases.

To verify the OLAP extension is loaded: 

  1. Open the Help menu and click About.

  2. Select the Extensions tab.

  3. Scroll down the alphabetical list of extensions until you find OLAP.

Configuring the OLAP Environment

You can set various options that affect the way that SQL Developer operates.

To set your configuration preferences:

  1. Choose Preferences from the Tools menu.

  2. Expand the OLAP node, and choose one of the following panels:

    • Advanced: Overrides some default data storage settings.

    • Build Log: Controls the content of the build logs.

    • OLAP DML Syntax Colors: Customizes the colors used in the OLAP DML program editor.

    • OLAP Expression Syntax Colors: Customizes the colors used in the OLAP Expression Syntax editor.