Test Microsoft Excel JAVA Agent
 |
The following instructions for testing Excel JAVA agent are valid for Analytics Extension versions 9.4.x and above.
|
Prerequisites
The Excel agent is correctly configured and running.
Testing Excel Agent
Follow the steps below to test the new Excel JAVA agent:
1. Create an Analysis Provider
|
|
In the Connector (Required) field, select the connector created during Excel agent configuration. Refer Configure the Microsoft Excel JAVA Agent
|
For more information about creating an analysis provider, refer to Create an Analysis Provider .
2. Create a Model
|
|
• In the Provider Name(Required) field, select the provider created in Step 1.
• In the Choose File field, ensure the selected file is in Excel workbook format.
|
For more information about creating a model, refer to Create an Analysis Model. If the model deployment is successful, it will be in Ready for testing state.
3. Test the Model
There are two ways to test or verify working of a model.
b. Test by creating event on the model: See Step 4 below for detailed process.
|
|
To create an event for the model, check if the model is enabled. Refer Enable an Analysis Model for steps to enable a model.
|
4. Test by creating an event on the model: Follow the steps below to create an Analysis event:
a. Create a new Thing. While creating the Thing, ensure to add properties under Properties and Alerts for the model on which event is to be set.
b. Create an analysis event with the following details:
i. In the Source Type(Required) field, select Thing.
ii. In the Source (Required) field, select the Thing created in step 4.a.
iii. In the Event (Required) field, select DataChange.
iv. Select the property for which the event is to be created.
v. In the Provider Name (Required) field, select the provider created in step 1.
vi. In the Model Name (Required) field, select the model created in step 2.
vii. Click Save. to save the analysis event.
For more information about creating a new event refer to Working with Analysis Events.
c. Select the analysis event created in Step 4.b, and click Map Data. Map the inputs with properties of the model. Similarly map the results to the properties.
For more information about mapping refer to Map Event Data to Properties.
d. Test the model on the data change event.
i. Open the Thing created in step 4.a.
ii. Enter input values for the model properties.
iii. The result is updated once the value of property (on which event is created as in step 4.b) is modified. Click Refresh if required.