Home > Getting Started with Oracle... > Using SQL Developer for OLA...
![]() Previous |
![]() Next |
You can choose between two tools for creating and managing dimensional objects:
SQL Developer: The OLAP extension is tightly integrated into SQL Developer and provides a familiar environment for creating and managing dimensional objects. This guide describes how to use the OLAP extension. For basic tasks, such as connecting to Oracle Database or editing an object, see the general SQL Developer documentation.
Analytic Workspace Manager: A full featured, standalone application specifically for creating and managing dimensional objects. See the Oracle OLAP User's Guide for download instructions and usage.
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:
Open the Help menu and click About.
Select the Extensions tab.
Scroll down the alphabetical list of extensions until you find OLAP.
You can set various options that affect the way that SQL Developer operates.
To set your configuration preferences:
Choose Preferences from the Tools menu.
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.