Returns names and types of items belonging to the informed Contextual Model node.

EpmBrowseModel(
  @path nvarchar(max))

Where:

•path: Full path of the Contextual Model node to search for items

This query returns a table with two columns, the first one (Child) with the name of the items belonging to the requested node and the second one (Type) the respective types, which can be Folder, BasicVariable, or ExpressionVariable. Usage example:

SELECT Child AS childName, Type AS type
  FROM dbo.EpmBrowseModel('ContextualModel/Folder01')

In this case, the query returns a table with all names and their respective types of items belonging to Folder01 folder of ContextualModel node.