IFS OLAP cube Measures based on SUM aggregation aren't populating in the Sales cube specifically, even though equivalent SUM-based Measures work correctly in the Manufacturing cube, and there's confirmed data present in the Sales-related Data Mart SQL tables. Changing data types on both the SQL table and the cube definition didn't help.

All FAQ questions / Reporting and analytics

Answer

Check whether the DM_FACT_REPORTING_CURRENCY_RATE table has data — an empty currency-rate fact table is a known cause of cubes coming back empty even when the underlying source data itself is genuinely present, since Sales-cube measures commonly depend on currency-rate lookups that Manufacturing-cube measures don't. Also verify every BI Analysis Package lookup/configuration step has been completed correctly, per IFS's own BI Analysis Package configuration-lookup documentation, since a missing or incomplete lookup configuration can produce this same symptom.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Reporting and analytics questions