Importing forecast numbers with forecast version and time scaled into a module without forecast vers

Hi All,
I am trying to import forecast numbers from one module having forecast versions(list) and Anaplan time into a module only with time-scale.
The idea is to have a page selector(forecast) in the target module and when users select the respective months ,they should be able to see the numbers forecasted in that particular month from the source module.

When I import the data ,to accomplish the above I see the numbers cumulating when I select the next months.

Can some-one provide some hints to this?

Accepted answers

nathan_rudman

If you want to keep the import action for snapshoting reason, you might want to filter the source module to export only the forecast. No need to keep the actuals in the target module if you don't use it.

Simply right click on the forecast version and click on "Show", save the view and use it as a source of import. this will import only the forecast.

You can so this via a boolean as well, having a setting module where you select which version should be exported (and using this boolean as a filter), so you can switch to another forecast version without having to change the view.

All comments

VIGNESH.M

Hi,

The Actual and Forecast numbers are getting summed and loaded into your target module. To only take forecast numbers,

Option 1: Direct Formula

Use the formula to pull the data, Use SELECT Function

=SOURCE MODULE.VALUE[SELECT: VERSIONS.FORECAST]

Option 2: Import

Step 1: Create a line item in your target module called Staging and use formula to pull data from the source module,

=SOURCE MODULE.VALUE[SELECT: VERSIONS.FORECAST]

Step 2: Import Value from Staging to Target Line Item.

Regards,

Vignesh M

nathan_rudman

Simply right click on the forecast version and click on "Show", save the view and use it as a source of import. this will import only the forecast.

akprasa1

Thank you Vingesh for the response.

I tried to hide the Versions that i dont need and mapped it with the target Version and it worked.

Quick Links

Can you help?

Unanswered questions

Different Subsets of Parent Lists in Input & Output Modules
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!