Returns a table containing a list of all Basic Variable-type variables in an EPM Server.

Syntax

SELECT * FROM EpmBasicVariablesView()

Resulting Fields

•Name: Name of the variable

•Description: Description of the variable

•EU: Engineering unit configured in the variable

Usage Example

To return data from all Basic Variable-type variables containing the expression "Elipse" in the Name field, use the next declaration.

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