AX15552
Axiom Intelligence reports use a subset of Axiom Decision Support data that has been selected to support the most useful data analytics. This data set is static to provide optimal query performance while exploring your data, but the data set can be refreshed as needed with the latest data.
The data available to Axiom Intelligence reports is determined by the data model. This model is predefined and provided by the product package installation.
The data model is designed to provide access to the data that is deemed most useful to analytical reporting, based on the data structures used by the product. The data model determines the fields that are available for use in Axiom Intelligence reports. Some fields may directly correspond to tables and columns in Axiom Decision Support, while others may represent transformations or calculations of table data. See your product documentation for more information on the data included in the model.
Currently, data models cannot be customized to include additional fields or to remove existing fields.
Refreshing the available data
When you install a product package that includes an Axiom Intelligence data model, the model and its data are made available to Axiom Intelligence reporting. This creates the initial data set used for reporting. If any changes are made to the data in Axiom Decision Support after the package installation, this data is not available to Axiom Intelligence reporting until the data is synchronized.
Axiom Decision Support uses a Scheduler event handler named System.ProcessBITable to synchronize data for Axiom Intelligence reporting. This event can synchronize all data, or synchronize data for a specific table—for example, if the table has just been modified. This event can be run using a Raise Event Scheduler task or using a RunEvent command or function. The reserved variable name Table can be used to pass in an optional table name.
The Axiom product that provided the data model will also provide a built-in methodology to trigger this event handler and synchronize the data. The product may be designed to synchronize data after specific activities are performed in the software (such as after running an import or a particular data utility), and/or it may be designed to synchronize data at regular intervals using a scheduled job. The product may also provide a way for you to manually trigger the data synchronization as needed from an Axiom form or from a custom task pane.
