I have 3 modules. First module has list with yearly values. second module has line items that convert the yearly data to quarterly. I want to convert quarterly data monthly in third module. The quarterly module has override capabilities so if user select set annual to 0, then the total for that year will be 0. If user select override for Q2, then the updated value of Q2 will be carried down to Q3 & Q4. First module is year timescale, second is also year timescale and third module is month timescale.
Check if this helps:
Annual=$0, all quarters and all months become 0. Q2 override entered then Q2, Q3, Q4 months reflect override value/3months. If no overrides, monthly values = (Annual/4 Quarters)/3months
Hi @Amittiwari0507, What is the question here?
Hi @Amittiwari0507 , Is there a reason you're using line items for Quarters instead of native timescale? If you change the set up to using the native timescale you can use quartervalue(source line) to get the value at month level. In the current set up, you'd need a mapping for Quarter-Month and can then use lookup to get the values, however lookup on time has a very bad impact on the performance so I'd suggest you move the set up to native quarters and use quarter value. Hope this helps! :)
We have an Anaplan model that uses "Fake Time" - that is a time dimension specifically constructed for the application and not one found native to Anaplan. For this reason the Opening / Closing Balance summaries don't work. We would like to be able to show the opening and closing balance at the beginning end of each weekly…
Hello everyone, We are trying to use Anaplan Connect in order to push data from a dwh to Anaplan Data Hub. To do so, we need an authentication by token. We can't make it work, we receive the following error: ERROR 16020 |-- Anaplan API: Invalid key path Any suggestions? Thank you all in advance for the help! Michele
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
