I am really stuck with the formula to be used in this module.
Would really appreciate help if someone can guide through detailed formula
Hi @Smuti yes we are taking values from default forecast because if it is current year then we will take data of previous year.But if it is not current year we will not be having previous year data so we will take default forecast of previous year as baseline of next year(if 2020 is current year then baseline for 2020 is 2019 data and baseline for 2021 is default forecast of 2020)
Hi
For Baseline forecast you can use this formula- IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN LAG(Default Forecast, 52, 0, STRICT) ELSE 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year'
Growth Rate we are actually calculating by taking weekly growth % in DEM02 module
Default Forecast is nothing but baseline *(1+growth rate)
you can refer to the screenshots(DEM 03 Demand Forecast Module)
to get an idea how to calculate initial Demand forecast
Hi @AkhilEmmanual thanks for helping me out but with regard to baseline formula we are taking a value from default forecast but if we see the formula default forecast is dependent on baseline so how is the formula getting justified? i am sligtly confused with that aspect.
@AkhilEmmanual thanks for all the help!! its quite understandable now.
@AkhilEmmanual there is another topic for which i am having doubt and kind of stuck, could you please help.
3.3.7.1 Create Inventory Ordering Overrides module
i have created the DCA module and added below formula, however in my INV01 my checkbox isnt reflecting.
DCA formula
Let me know where am i making the mistake, i am unable to understand.
Also for yellow highlighted above i have added AD02 in read and write access driver in INV01.
@Smuti can you show the blue print view . I think you had given DCA to Submit purchase order request? if its like that remove the DCA from there. That may be reason why you are not able to see check boxes. DCA should be Applied to Suggested Order Amount for the month.
The model should actually look like this
@AkhilEmmanual here is the snip of my blueprint view, however when i make changes my dashboard isnt reflecting like yours.
if you see as per your screenshot and mine yellow highlight is shown as blank thats not the case in yours.
Also can you show me your DCA blueprint view to verify if i have written correct formula for each
@Smuti That is because for Suggested Order Amount you should give DCA based on Submit Purchase Order Request.
@AkhilEmmanual
Even if i added DCA as per the screenshot you have shown my numbers arent reflecting.
@Smuti Can you check any boolean on submit purchase order request then it will be visible because now submit purchase order request is false that is the reason its not showing.
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
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
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…
