Subscribe to Columns as Arrays

Users can subscribe to a single column of a data table, view, or ad-hoc query and get the entire column as an array. This feature is available for the BI Server, GridWorX and Web Services point managers.

AnalytiX-BI Server

Here are some examples of column tags that should now return arrays:

• bi:Models:Northwind.Categories.CategoryID

• bi:Models:Northwind(SELECT Categories.CategoryID)

• bi:Models:Northwind(SELECT Categories.CategoryID, Categories.CategoryName)[1]

• bi:Models:Northwind(SELECT Categories.CategoryID, Categories.CategoryName)[CategoryName]

For backwards compatibility reasons, this feature is disabled by default. To manually enable it, open Platform Services Configuration, go to the Point Managers tab, select the BI Server Point Manager, and set the value for EnableArraySubscription to true to enable this feature or false to disable it.

GridWorX Server

For example, this tag should now return an array:

db:Northwind.Categories[CategoryID]

For backwards compatibility reasons, this feature is disabled by default. To manually enable it, open Platform Services Configuration, go to the Point Managers tab, select the GridWorX Point Manager, and set the value for EnableArraySubscription to true to enable this feature or false to disable it.

Web Services

For example, this tag should now return an array:

ws:Sample Web Services.National Weather Service.Current Conditions<@stationid=KBOS>.cloudLayers

For backwards compatibility reasons, this feature is disabled by default. To manually enable it, open Platform Services Configuration, go to the Point Managers tab, select the Web Services Point Manager, and set the value for EnableArraySubscription to true to enable this feature or false to disable it.