Home > Data Modeler Dialog Boxes > SQL Access to Oracle AW Pro...
This dialog box displays the properties of a SQL Access to Oracle Analytic Workspaces (AW) object in a multidimensional model. For more information about working with multidimensional data, see Oracle OLAP User's Guide and the online help for Analytic Workspace Manager.
General
Name: Name of the object.
AW Name: Analytic workspace where the source data is stored.
Include GIDs: Controls whether the grouping ID for each dimension member is included.
Use Object Types: Controls whether the next two fields (Object Type Name and Table Type Name) are accessible.
Object Type Name: Name of the object type.
Table Type Name: Name of the table type.
Use Model Clause: Controls whether the Include RowToCell default statement will be included in the SQL statement.
Include RowToCell: Controls whether the Use Model Clause default statement will be included in the SQL statement.
SQL Statements: Displays a dialog box in which you can view, modify, and change the order of attributes, and also see the SQL statement the reflects the current specifications. On the SQL Statement tabs in this box, the Show Formatted Limit Map option enables dimension information to be formated (divided over several lines).
Dimensions and Attributes
Lists any dimensions associated with the object. For each dimension, you can specify predefined attributes and hierarchies. To add a dimensions and attributes item, click the Add (+) icon and select the elements to be included; to remove a dimensions and attributes item from the object definition, select it and click the Remove (X) icon.
Measures
Calculated measures can add information-rich data to a cube. The data set is calculated on the fly, so no data is stored. You can add as many calculated measures as you like without increasing the size of the database.
Description
Description of the SQL Access to Oracle AW object.
Comments, Notes, Summary