Working with Excel Add-In for Operations Hub
Features of Excel Add-In for Operations Hub
Following are the features available in Excel add-in for Operations Hub
Feature | Description |
---|---|
Query | Enables you to perform the model query and to get the data onto the excel. |
Configuration | Enables you to connect to and save Operations Hub server details |
About | Displays the version information of Excel Add-in for Operations Hub. |
Help | Displays the Help for Excel Add-in for Operations Hub. |
Logs | Opens the folder where you can view the logs generated. Note: The log files are in json format. You can open the files in Notepad to view the details. |
Configure Operations Hub Server
About this task
To query a model defined in Operations Hub, you should receive a token from Operations Hub Server.
To enable this you can either explicitly launch Configuration window or launch the Query window.
The Operations Hub Configuration window enables you to configure the Operations Hub Server and save the details of Operations Hub Server.
Procedure
Querying an Operations Hub Model
You can query an Operations Hub Model using the Object Types, Data Variables and Objects:
Icon | Description |
---|---|
Represents Object Types. Double-click to view the data variables and contained types (Object type)
Note: Object Types are not selectable. | |
Represents Data Variables. | |
Represents Objects. |
- Object Types: Object types define the structure of the equipment within your model.
- Data Variables (including contained types): Data Variables describe the actual data that is received from a data source. Among other things, it defines how to use a property in the Views feature. For example, you can define a property to appear as a trend line on Trend views. For each object type, such as a Car, you set up all the data variable names, such as Color, Speed that any object associated with this type can reuse in its own definition.
- Objects: Objects are the instances of object types or equipment pieces. Example: BMW, BENZ