This page describes how to build new reports in Reporting module for Axiodis and / or customize existing report.
Datawarehouse content
Axiodis datawarehouse propose by default following tables and corresponding data which can be used to create reports :
| Table | Description | Type |
|---|---|---|
| IC_D_DRIVER | Dimension table about drivers | Dimension |
| IC_D_LOGISTIC_AREA | Dimension table about logistics areas | Dimension |
| IC_D_OPERATION | Dimension table about transport operations | Dimension |
| IC_D_PRODUCT | Dimension table about products | Dimension |
| IC_D_PROVIDER | Dimension table about providers | Dimension |
| IC_D_ROUTE | Dimension table about routes | Dimension |
| IC_D_SEQUENCE | Dimension table about sequences | Dimension |
| IC_D_SITE | Dimension table about sites | Dimension |
| IC_D_TRAILER | Dimension table about trailers | Dimension |
| IC_D_TRUCK | Dimension table about trucks | Dimension |
| IC_M_OPERATION | Measure table about transport operations | Measure |
| IC_M_ROUTE | Measure table about routes | Measure |
| IC_M_SEQUENCE | Measure table about sequences | Measure |
| IC_D_ROUTE_INVOLVED_PROVIDERS | Dimension table to store all the involved providers fo the routes | Dimension |
| ID_D_ROUTE_VALORIZED_PROVIDERS | Dimension table to store all the valorized providers of the routes | Dimension |
For further informations and more details about Axiodis datawarehouse content, click here to see the document about the datawarehouse description.
How to create a report ?
- Launch Axiodis reporting module
- Create a new report (cockpit)
- Add a widget
- Choose
Create a cockpit
Create a dataset
Update IC + MIA streams if necessary