11.3.2 Activity: Import Data into P&L Actual and Budget

In 11.3.2 Activity: Import Data into P&L Actual and Budget I cannot import any data to the Budget version as it seems like only Forecast and Actuals version exist in the new model I have created.

However I cannot tell why the budget version is not there? My systems module for version looks like this:

And versions is set to All for the module:

Accepted answers

ChrisAHeathcote

If you do not want to use switchover you can simply delete the time period in version settings.

Alternatively, you can disable switchover at the line item level in the blueprint of the module.

All comments

bhatjaved

@hannaaberg

you need to create budget version in your versions tab which comes in model settings after time , looks like you have missed initial activity which talks about model settings .

And in your SYS09 module there are line items which reference your version details based on the settings you have set

hannaaberg

I added a new line item named Budget in the versions tab and now it looks like this:

Should I make any further modifications here? I cannot really tell why that is not there since before. I have followed the instructions in all of the steps as they have been pointed out.

SYS09 looks like this so that seems to be incorrect

However the formulas are as per described in the instructions (see previous screenshot)

Then I proceeded with the import of the data and now it seems that it should be working

However, if I check the data in the grid view I have data in the forecast version but no data in the budget version instead of the other way around...

hannaaberg

Note that I have data for FY20 for Budget, but I still don't understand why there is data for the Forecast version since that was never included in the import

bhatjaved

@hannaaberg

your initial mapping was incorrect, now you either need to delete existing data entirely and upload the file again as fresh data or delete the module and create new module with fresh upload .

ChrisAHeathcote

@hannaaberg

There is functionality called Switchover which will automatically allocated values held in actual against other versions upto a given timeperiod as specified in the version settings.

This is still enable and therefore is pulling through the actuals and allocating them to time periods where the switchover functionality applies.

hannaaberg

Is it this one you are referring to? I have not set it to Dec 21 by myself and it seems like it is not possible to set it to null. Is it correct that I receive data in the forecast as-is or should I inactive this in some way? In the data import nothing was mapped to Forecast (Only Actual and then also Budget) so I am certain that the issue does not lie there and that it would help to remove the data and then upload it again

ChrisAHeathcote

If you do not want to use switchover you can simply delete the time period in version settings.

Alternatively, you can disable switchover at the line item level in the blueprint of the module.

MilanN

Your Version (Snip 1) and SYS09 Version details (Snip 2) should look in this manner.
There is a need to make changes in switchover - disable switchover at the line item level in the blueprint of the module
Your data import mapping for version tab looks correct.

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
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,
Cloudworks Big Query Integration Fail
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…