Show TOC

Function documentationDynamic Constants Locate this document in the navigation structure

 

Dynamic Constants are predefined in Planning and Consolidation, and can be used within the context of the INFO instruction. You can define your own constants and use your own naming convention for the names, but they cannot match any of those in the following list. Constants are available to other tasks within a package.

These constants are detailed in the following table:

Predefined Constant

Description

%ACCOUNT_DIM%

This constant returns the dimension name where dimension type = A.

%APP%

This constant returns the current application name.

%APPLIST%

This constant returns a list of applications.

%APPPATH%

This constant returns the current application path. The path returned has the trailing back slash (\) appended to it.

%APPSET%

This constant returns the current application set name.

%CATEGORY_DIM%

This constant returns the dimension name where dimension type = C.

%CONVERSIONPATH%

This constant returns the Data Manager conversion folder path name. The path returned has the trailing back slash (\) appended to it.

%CURRENCY_DIM%

This constant returns the dimension name where dimension type = R.

%DATAPATH%

This constant returns the current data path for the Data Manager. The path returned has the trailing back slash (\) appended to it.

%DATAROOTPATH%

This constant returns the current root data path for the Data Manager. The path returned has the trailing back slash (\) appended to it.

%DEFAULT_MEASURE%

This constant returns the default measure type used in Planning and Consolidation.

%DIMS%

This constant returns a list of dimensions based on the application.

%ENTITY_DIM%

This constant returns the dimension name where dimension type = E.

%FACTDIMS%

This constant returns a list of dimensions based on Microsoft SQL Server.

%LOGICPATH%

This constant returns logic folder path. The path returned has the trailing back slash (\) appended to it.

%MEASURES%

This constant returns a list of measures.

%OLAPSERVER%

This constant returns the OLAP server name.

%SELECTIONPATH%

This constant returns DM selection folder path. The path returned has the trailing back slash (\) appended to it.

%SQLSERVER%

This constant returns the SQL server name.

%TEMPPATH%

This constant returns the temp folder path for the current user. The path returned has the trailing back slash (\) appended to it.

%TIME_DIM%

This constant returns the time dimension.

%TRANSFORMATIONPATH%

This constant returns the Data Manager transformation folder path. The path returned has the trailing back slash (\) appended to it.

%TRIMMEDUSER%

This constant returns the short User ID (without the domain name).

%USER%

This constant returns full user name (with the domain name).