Oracle9i OLAP Services Developer's Guide to the OLAP DML Release 1 (9.0.1) Part Number A86720-01 |
|
Creating and Using Analytic Workspace Metadata, 7 of 7
The following metadata is required for the display of the following objects:
Define a folder membership valueset to specify the measures that are contained in a folder, then set the MEASINFOLDERVS property on the folder dimension.
The following example defines a folder membership valueset. Note that the definition uses the measure dimension and is dimensioned by the folder dimension. For information about the measure dimension, see "Set the DBMEASDIM property to identify the workspace's measures". For information about the folder dimension, see "Set the DBFOLDERDIM property to identify the workspace's folders".
define measinfldr valueset dbmeasdim <dbfolderdim>
You then create a list of measure names in the valueset. For more information about using valuesets, refer to the DEFINE VALUESET command in the OLAP DML Reference.
After you have defined the folder membership valueset, then you can set the MEASINFOLDERVS property on the folder dimension.
For example, the following code sets the MEASINFOLDERVS property on the folder dimension and specifies the valueset named dbmeasdim.
consider dbfolderdim property 'MEASINFOLDERVS' 'dbmeasdim'
To display a short name for any OLAP DML object, define a short description variable to hold the short name, then set the SDSCVAR property on that object.
The following example defines a short description variable for a SALES variable, then assigns "sales" as the variable data. Note that the variable is defined with a text data type.
define short_sales variable text short_sales = 'sales'
After you have defined the short description variable, then you can set the SDSCVAR property on the OLAP DML object.
For example, the following code sets the SDSCVAR property on the SALES variable and specifies the short description variable named short_sales.
consider sales property 'SDSCVAR' 'short_sales'
To display a long name for any OLAP DML object, define a long description variable to hold the long name, then set the LDSCVAR property on that object.
The following example defines a long description variable for a SALES variable, then assigns "sales for the past 12 months" as the variable data. Note that the variable is defined with a text data type.
define long_sales variable text long_sales = 'sales for the past 12 months'
After you have defined the long description variable, then you can set the LDSCVAR property on the OLAP DML object.
For example, the following code sets the LDSCVAR property on the SALES variable and specifies the long description variable named long_sales.
consider sales property 'LDSCVAR' 'long_sales'
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|