Copy data from Actual Version to Budget Version

Hi Experts,

I am testing a scenario, where user wants to update forecast data. But before user does it, he wants to copy previous year actual data to current year and next year forecast version. I do not want to use "Bulk Copy" functionality.

Scenario

Copy data from Actual version and Year 2019 to Forecast Version & Year 2020 & Year 2021,

Actual, Year 2029 ---> Forecast, 2020, 2021

I created a module 1 with Version, Time, Cost Center, Cost Element, Line item: Amount. Store dummy actual data for year 2019. Created another module 2 with same lists and selected forecast version and used formula "POST" from module 1, I am able to copy data from previous year to next 2 year, but I can not see Actual data in Forecast version.

Please guide.

Thanks,

Varun

Accepted answers

All comments

rob_marshall

@varun.joshi07

Are you using Native Anaplan Versions? If so, please make sure the SwitchOver toggle in Blueprint is turned on.

nathan_rudman

why not using bulk copy ?
why copy the data ? why not using switchover or a formula to mimic switchover (you can have a boolen setting over time and version and use it like IF setting then actuals else forecast)

varun.joshi07

@nathan_rudman @rob_marshall Thanks for stepping forward and help me answering my query.

The reason for not using Bulk Copy is because it will copy all periods and all years data, but here I have custom requirement, where I just want to copy Actual Year 2019 to Forecast Year 2020 and 2021.

After trying many times, I found a way to achieve this requirement.

Thanks,

Varun

tbeck

A good way to avoid versions (as the size of the model multiplies with every version) is to create a list of "Scenarios". Item 1 is Forecast, Item 2 is Budget, (or Actual), and apply the 2 item list to the module instead of an entire version. This will call for the SELECT function down the road when Forecast needs to be pushed to Actuals, and Forecast needs to be cleared.

1) Create a staging module with the same dimensions as the input module, minus the scenario list.

2) Set the line items in the staging module equal to the Input module and use the SELECT Function to select the forecast data

3) Copy the staging Module and create a Data Clearing Module to import into the forecast scenario by inputting a 0 as the formula in all line items.

4) Import the forecast data from the staging module into the Actuals by importing into a fixed item "Actuals"

5) Clear the forecast data by importing the 0's into the forecast.

This will allow a bulk copy to function efficiently without using versions.

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…