The Agiblocks Reporting Guide has been updated with information on all Reporting data available through the OData interface. The information is still organized using different data models and entities within each model and much of the data is the same as was available in Agiblocks Reporting 1.0, though new data models for Futures and Options information have been added. More links between models and data within models can be made depending on the capability of your reporting tool and the reports you wish to create. See the Agiblocks Reporting Guide 2.0 for more information.
Using Microsoft Excel to Create Reports
Microsoft Excel has the ability to connect to the Agiblocks OData interface. To do so, you will need the following:
| 1. | The Agiblocks OData URL – you should get this from your Agiblocks system administrator. |
| 2. | Have the In Access OData EndPoint permission in Agiblocks. |
| 3. | Your Agiblocks user name and password. |
In Excel, select the OData option from under the Data->From Other Sources menu. In the dialog that appears, enter the URL to the OData interface and your Agiblocks user name and password.
You then choose the data model(s) you wish to work with.
See the Agiblocks Reporting Guide 2.0 for more information on Agiblocks data models, entities and fields within the data models that are available for use.