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:
See Also:
Chapter 15, "CWM2_OLAP_AW_ACCESS" for information about generating views of analytic workspace data. |
None
GENSQLOBJS(aw_name, directory, filename [, language])
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 ENGLISH
.
CALL GENSQLOBJS('sales', 'scripts', 'salesdat', 'ENGLISH')
|
![]() Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|