Returns a table with a list of all existing expression variables on an EPM Server.

Syntax

SELECT * FROM EpmExpressionVariablesView()

Resulting Fields

•Name: Name of the expression variable

•Description: Description of the variable

Usage Example

To return data from all expression variables whose names contain the expression "kpi" in the Name field, use the next declaration.

SELECT * FROM EpmExpressionVariablesView() WHERE Name LIKE '%kpi%'