|Oracle9i OLAP User's Guide
Release 2 (9.2)
Part Number A95295-01
Creating an Analytic Workspace From Relational Tables, 4 of 6
GENSQLOBJS is an OLAP DML program that generates a SQL script. The script uses the
OLAP_TABLE function to generate views of multidimensional workspace data. The analytic workspace must contain ECM-type metadata, whether generated by
CNV_CWM.TO.ECM or provided in a legacy Express database. The resulting dimension views and measure views comprise a star schema that represents the analytic workspace.
You can use the resulting relational views in two ways:
Chapter 15, "CWM2_OLAP_AW_ACCESS" for information about generating views of analytic workspace data.
A text expression that provides the name of an ECM-type analytic workspace.
A text expression that provides the name of the directory alias where the SQL script will be created. For information about obtaining access to a directory alias, see "Controlling Access to External Files".
A text expression that specifies the base name of the output script file. An extension of
.sql will be appended to this base name.
A text expression that identifies the desired language dimension value. Required only when there are workspace objects that support multiple languages. For example, a variable with dimension labels might have a language dimension with values for English, French, and Spanish. When generating a relational view, you must identify which language you want the view to support.
The following command creates a SQL script with a name of
salesdat.sql from the
sales analytic workspace. The files are stored in the directory identified by the
scripts directory alias. The workspace language dimension will be limited to