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

Syntax

SELECT * FROM EpmBasicVariablesView()

Result Fields

•Name: Name of a variable

•Description: Description of a variable

•EU: Engineering unit configured in a variable

Example

To return data from variables with a BasicVariables type containing the expression "Elipse" in the Name field, use the next statement.

SELECT * FROM EpmBasicVariablesView() WHERE Name LIKE '%Elipse%'

EpmBasicVariablesView function