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

Syntax

SELECT * FROM EpmExpressionVariablesView()

Result Fields

•Name: Name of an expression variable

•Description: Description of a variable

Example

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

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

EpmExpressionVariablesView function