Come across some data that just doesn't make sense? Found a discrepancy between an Magento BIreport and a query or third-party report?
Depending on the complexity of your analysis, generating the corresponding Magento BI report may require familiarity with a number of different facets of the platform. This checklist and the related links will help you understand the logic behind your report, allowing you to identify the source of any discrepancies.
- If another member of your team created the report, begin by confirming the objective and parameters of their analysis
- Generate expected data points to compare to the Magento BI report based on a query, a third-party reporting tool, or a formula
- Review and confirm the metric definition(s), either from the metric link in Report Builder or by visiting the System Summary tab:
Review and confirm other data manipulation within the report:
If the discrepancy involves recent data, confirm the latest available data point by consulting the Update Details section on the Connections page
If a metric used in the analysis is built on a table from your database where rows are ever deleted from that table, confirm with the Magento BI Support Team that the table is being checked for deleted rows, as well as the frequency of the recheck and the replication method for the table
Similarly, if columns used in the analysis can be modified after a row is added, confirm with support that these columns are being checked for modifications, as well as the frequency of the recheck
- Data table
- Operand column, including its calculation if it is derived (via System Summary)
- For subscription metrics: start and end dates
- Filters, including those contained in any filter sets applied
Still stumped? Don't worry - we're here to help. Send us a request using these instructions.