Simple conditional formatting when a cell is rule or consolidation based.
Clients often ask if we can highlight which cells can be entered into and which cannot. Of course we can work around this, but if there is a large table of details (say in a Dynarange) it adds a lot of workings to the sheet. It would really help i...
We have a lot of templates which often use the same macros. It would be great to have the possibility to have this code in one place instead of having the same code over and over again in every template. This would speed up development and make ma...
When adding a target in the ESG Accelerator "Target Setting Input", the model should automatically splash the target out to the year/month, either evenly distributed or distributed based on actuals for a given year. The long term target setting in...
Add paging in reports for Legal Entities (including the ones listed for workflow)
Sometimes, there are many Legal Entities at customers, paging function would be needed in reports: "Scope of consolidation", "Data collection", "Consolidation Manager", "Consolidated Financial Statement".
Custom source level elements in the Consolidation dimension
The Local GAAP element of the Consolidation dimension is the only element to receive original source data for the separate financial statements. This data is captured on the ~ element of the Scope dimension and shows automatically on all other sco...