Curious when your budget or forecast numbers change and your detective mode turns on? Try Data History! An administrator must turn on Data History for a cube. Once Data History is enabled through System Hub, you can now see the audit trail of the data (basically, the who, what, and when of all manual changes to a member combination).
Note: Data History tracks all manual changes made to a leaf-level member combination through the following:
Ad Hoc Analysis
Data-entry template
Line-Item Schedules
Trigger account for a procedural calculation account (an entry is logged in the history of each affected account)
Linked Detailed Planning Schedule
A Journal entry
Right-click a number on your Template or Ad Hoc Data View and select Data History.
That may be because you are clicking at a total level? The cell that you select has to be at a leaf level. If you are looking at a budgeted member combination at a parent level or higher level, you won’t see it. Make sure to drill down and click on Data History at lowest level where the data resides.
If you are still experiencing issues, I would recommend submitting a support ticket to speak with one of our consultants. I hope this helps!
Thank you for the tip! This feature proves valuable during our budget cycle, allowing us to track the history of member field changes, including the date and user name. More interesting is, it reveals how the data was updated in this field, whether through a spread, a defined process, or a template calculation.
I use this feature a lot and it’s helpful to determine who has made which changes to certain cells. I often find it helpful also when troubleshooting issues when users insist that they’ve made changes…those changes might have been overridden by another user after that, or sometimes they just didn’t realize that they’d saved a typo.
There are a few unfortunate limitations/constraints to Data History that I hope get added to the product some day soon:
Infoflexes and other process operations aren’t supported, so (as mentioned in the article) it applies only to manual changes made by humans since the last process operation.
There’s no way to export this data or import it, so if you have a template working with staging accounts that update other accounts, or via formulas, we can’t export/import into the reporting accounts from the source accounts, so the history isn’t available.
There’s no way to report on this data…it’s 100% manual requiring a real human to right click on the cell and view it in real time. I’d love a feature to be able to produce an audit report for all cells in a dataview or template, to include in a report binder or just to be able to view at-a-glance rather than having to check each cell interactively.
