Hi Guys,
I am working on a module. where I should input the L1 then it should go L2 level. if I Enter the L2 then it should distribute L3. I can use the break back .
I there any functionality available for this scenario
@143kishornaidu
Anaplan is best designed for pulling the data(aggregating the data) and you will have umpteen functionalities for the same.
but when it comes to disaggregation, i think break back is the best possible option for bringing the data for higher level to lower level.
there are some functionalities like PROFILE, SPREAD, which is helpful while doing calculations like depreciation etc. which basically pushes the data.Thanks,Manjunath
You can use LOOKUP function to cascade the numbers down from L2 to L3. Note that the numbers will be flat lined across all the children of the parent
Hope that helps
Misbah
Miz Logix
The Anaplan XL Reporting formula reference page has not been updated since April 2026. It's missing any reference to the new XL3LookupAsync formula. Can we please have this page updated with all the latest features from XL?
Hello All, The modules in the MFP model (DAT010 - Retail Based Historical Actuals, DAT020, DAT030, DAT040, DAT050, and DAT060) are already available, and the data for the different plans has been loaded. However, when I open Page 5000 - Seed Long Range LRP and select Seed Selection = LY, the following metrics are not being…
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
