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
Hello there, we are using AnaplanXL to pull data from 3 different sources into one Excel file. Two of them are Azure SQL data bases and the third is Anaplan itself. Whenever the Excel is opened 3 pop up windows to log in to each data base appear. Until they appear and everything is entered or clicked already 2 minutes are…
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
