/
Data from only certain years showing on Cubes

Data from only certain years showing on Cubes


Description of Issue

When running any type of Cubes (GL, Payroll, Fixed Assets, etc.), data only shows for a certain years, but years before that do not show, even though data exists in Munis for those years.

There is no data available before a certain date. Cubes job is completing successfully.

Can we change the starting year that cubes pulls from?

Context
  • Cubes
  • Database Administration
  • Extraction Year
Cause

This issue occurs when your site's Cubes are set to only report back to a certain year. Data will not show on your Cubes for years prior to this year.

Resolution

SaaS Please contact TSM SaaS Support with a request to update the Cube date range.

OnPrem clients can typically update the Cubes retrieval date without assistance. Instructions are here: Update the Retrieval Date for Cubes - OnPrem 

Additional Information

Please note that this process will cause Cubes to run slower, as it is trying to pull in more data.

When installed, cubes pulls from the last 5 years automatically.





Related content

Update the Retrieval Date for Cubes - OnPrem
Update the Retrieval Date for Cubes - OnPrem
More like this
Cubes Data Start Date
Cubes Data Start Date
More like this
Cubes is not pulling in as much data as it used to after upgrading
Cubes is not pulling in as much data as it used to after upgrading
More like this
Work Orders Cube failing due to datetime2 error - UB work orders
Work Orders Cube failing due to datetime2 error - UB work orders
More like this
Cubes is no longer working after upgrading to new Munis version
Cubes is no longer working after upgrading to new Munis version
More like this
Cubes showing outdated or incorrect data- Incorrect database defined
Cubes showing outdated or incorrect data- Incorrect database defined
More like this