Can anyone help me with this, please? I'm unable to get the correct formula for this.
Hi @Apurv989
Could you please share dimensionalities of the two modules? You can find it in Appies to or Pivot of the modules.
I think you should simply select the source and automatic aggregation will work or just a SUM function. But anyway let's look at dimensions first.
Kirill
In the REV02 module there is no formula and you need to write a formula to populate the volumes from DATA02 SKU Volumes module. Try it, Best of Luck!
In the target module you need to check dimensionality where volumes need to be loaded vs the source and refer the volumes from SKU module , it depends on dimensionality between source and target module , for eg if rev02 has SKU as dimension or any parent as dimension , then directly the module can be referred since it will be an aggregated or direct reference , else you will need to apply sum or lookup accordingly
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…