Metadata That Describes Other Objects

Metadata that is required for other OLAP DML objects

The following metadata is required for the display of the following objects:

• Folders -- To display the measures in a business area, see"Set the MEASINFOLDERVS property to identify measures in folders".

• Any OLAP DML object -- To provide a short description or a long description for any OLAP DML object, see "Set the SDSCVAR property to identify an object's short description" and "Set the LDSCVAR property to identify an object's long description".

Set the MEASINFOLDERVS property to identify measures in folders

Define a folder membership valueset to specify the measures that are contained in a folder, then set the MEASINFOLDERVS property on the folder dimension.

Defining the folder membership valueset

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.

Setting the MEASINFOLDERVS property

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'

Set the SDSCVAR property to identify an object's short description

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.

Defining the short description variable

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'

Setting the SDSCVAR property

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'

Set the LDSCVAR property to identify an object's long description

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.

Defining the long description variable

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'

Setting the LDSCVAR property

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'