Basic asset model

The basic asset model only leverages Tagname Dictionary of Managed Historian (Historian API) and its capability of configuring extended properties for grouping Tagname per a field value expected by BI Gateway model objects.

Scenario

Scope of this scenario is to define 2 dimensions and 1 measure calculation such as:

• The asset dimension reflects all assets and plants available as part of the Tagname Dictionary.

• Batch dimension as a type of Time Defining Dimension reflects all batches that have been operated against existing assets. This dimension retrieves tagname historical data and returns all batches (batch ID, Start Time,and End Time) per the key fields Asset and Plant.

• Power measure’s calculation computes the energy spent by the context of Asset, Plant, and Batch.

The Asset dimension is populated by retrieving all distinct value of the custom extended properties named “BIGateway_Asset” and “BIGateway_Plant” across the whole Tagname Dictionary.

The Batch dimension retrieves all tagnames matching the criteria BIGateway_Dimension eq ‘Batch’ and subsequently returns all historical events associated to.

The Power calculation retrieves all tagnames matching the criteria BIGateway_MeasureCalculation eq ‘Power’ and subsequently returns aggregated historical data associated to per requested time slice.

Note: AVEVA BI Gateway datasource object uses Custom Query expression, which facilitates the configuration of the query statement (See the Query Expression section) for retrieving and manipulating result set accordingly to the expected output schema.

Configure Tagname Extended Property

Following is an example of a JSON file, which is used to create Tagname Extended Properties leveraging the basic asset model concept.

Sample:

{

"metadata": [

{

"TagName": "Asset0001.Batch",

"BIGateway_Asset": {"DataType":"String", "Value":"Asset0001"},

"BIGateway_Dimension": {"DataType":"String", "Value":"Batch"},

"BIGateway_MeasureCalculation": {"DataType":"String", "Value":""}

},

{

"TagName": "Asset0001.Power",

"BIGateway_Asset": {"DataType":"String", "Value":"Asset0001"},

"BIGateway_Dimension": {"DataType":"String", "Value":""},

"BIGateway_MeasureCalculation": {"DataType":"String", "Value":"Power"}

}

]

}

For more information about defining extended tag properties, see the Define extended tag properties section in the AVEVA Insight Online Help.