Dear Anaplan Product Team,
I would like to suggest an enhancement regarding the consolidation process when a model requires "double consolidation" (e.g., consolidating by the standard 'Entity' dimension alongside a custom dimension, such as 'Business Unit').
Currently, we face a structural limitation regarding how the system handles the Default Input Member for custom dimensions during automated consolidation steps—specifically concerning CYNI (Current Year Net Income), the year-end Retained Earnings roll-forward, and Copy Recurring Journal Entries (JEs).
Here is the current behavior and the resulting pain points:
- Scenario A: No Default Input Member is set.When left blank, standard consolidation steps (like CYNI) calculate properly and maintain the dimensional detail. However at the end of the year, the 'Copy Recurring JE' process fails to roll forward P&L Accounts into Retained Earnings.
- Scenario B: A Default Input Member is set (e.g., "No Business Unit").The 'Copy Recurring JE' process works, but it forces all data into the "No Business Unit" member. Consequently, CYNI is also only calculated against "No Business Unit," completely stripping away our granular data. Most problematically, at year-end when the P&L accounts roll forward into Retained Earnings, the detailed breakdown by Business Unit is completely lost.
Proposed Solution:
Enable the consolidation engine and the Copy Recurring JE functionality to dynamically respect, inherit, and retain custom dimension details from the source data. The system should allow these automated processes to run smoothly across custom dimensions without forcing the use of a single Default Input Member that flattens the data.
Business Impact:
Allowing true multi-dimensional consolidation to flow seamlessly into Retained Earnings at year-end will preserve critical data granularity, ensure accurate multi-dimensional reporting, and eliminate the need for heavy manual workarounds or adjustment journals for our clients.
Thank you for considering this enhancement!
