Forecasting with my own data. Versions.

Joanna86
Occasional Contributor

Forecasting with my own data. Versions.

Hi!

I'went through L1, and right now I'm trying to do forecasting for Total Profit, Revenue, Cost and Margin in the Module. (with my data)

Why in my modules there is no forecast info? 
I do have a module with Version Details and I do have forecasting there...

I do have info from 2010 to mid of 2017, and I would like to make forecasting for the 2018-2021

 

Where can I check if there any mistakes?

Thanks.

 

16 REPLIES 16
DaanishSoomar
Certified Master Anaplanner

Re: Forecasting with my own data. Versions.

Hi @Joanna86,

 

This is interesting! Glad to see that you are trying this with your data. Best way to learn is by trying things hands on!

 

I do have a few questions, if you can have help provide some information we could help see what is going on:

 

1) Can you please provide screenshots of the blueprint view of the module you are trying to do the forecast in?

2) Can you please share screenshots of your Model Time Settings in the "Time" tab? 

3) Are you able to provide screenshots of the Versions Tab? And the Versions Details? 

 

This will help us begin to get an idea of how you have setup the modules and data. Look forward to getting this taken care of 🙂 

Joanna86
Occasional Contributor

Re: Forecasting with my own data. Versions.

Hi @DaanishSoomar ,

Thank you for the fast reply.

Sure, I made some screenshots.

 

Just in case I made few screenshots of Bleuprint of module where I want to have forecast..

And also the rest of Info attached.

 I will appreciate any help.

Misbah
Moderator

Re: Forecasting with my own data. Versions.

@Joanna86 

 

That probably means that you have not used Versions as dimensions in your target module although it may be present in your source module.

 

But it would be great if you can share screenshot of your source and target modules

 

Misbah

Joanna86
Occasional Contributor

Re: Forecasting with my own data. Versions.

@Misbah 

 

Thank you for the reply,

 

I tried to look and see my Model from L1 (And even if I didn't put Version in dimention it still shows the forecast..)

So, I Don't know how it happened that I'm fine with L1 model, and stuck with my own data.

I'm missing something and would like to understand better.

But I started recently.. So, for sure I need more practice and look at more examples.

 

Misbah
Moderator

Re: Forecasting with my own data. Versions.

@Joanna86 

 

The reason that you still see forecast data in target module is because in your versions settings you have marked Forecast as Current which means even if you don't have Versions as dimension in your target module it will pull up your Current Version related data which in your case is Forecast data.

 

Misbah

 

DaanishSoomar
Certified Master Anaplanner

Re: Forecasting with my own data. Versions.

Yes to add to @Misbah' s point, by marking "Forecast" as "Current" effectively "Forecast" no longer serves as "Forecast" it serves as "Current" data with that checkbox. 

 

@Joanna86 - To resolve this I would ask:

 

1) Which version do you want to mark as "Current"? 

2) If you want Forecast data to show, perhaps you can try adjusting the Version settings such that Forecast is not the "current version"?

3) Then you can leverage the Version System Modules and Settings to apply logic which shows Forecast separately from Current data.

 

Misbah- feel free to chime in if I missed any details.

Joanna86
Occasional Contributor

Re: Forecasting with my own data. Versions.

@DaanishSoomar 

I was thinking that I can have forecast period in one row (which continued from my current data) ?

It also should be possible, as long as I understand? 

(I would like to have it the same way as in L1 forecasts)

 

And I also tried to checkmark Actual (current), but it seems like it doesn't work..

I'm still missing something I guess...

 

Joanna86
Occasional Contributor

Re: Forecasting with my own data. Versions.

@Misbah 

 I just tried to change it in my Versions to Actual (Current)...

But it nothing changed..

Is there any additional formula have to be used?

may be I missed it somewhere?

DaanishSoomar
Certified Master Anaplanner

Re: Forecasting with my own data. Versions.

@Joanna86 - 

 

Yes there are some additional pieces of logic that are needed if you want everything past Jan 18 to be forecast (calculated). You can leverage a Time System Module and Version System Modules that breakdown into booleans which months are "Current" or "Actuals" vs. which months are "Forecast". From there you can say "IF Forecast then do (insert formula/logic here) ELSE 0". 

 

@JaredDolich - do you have a good way of explaining how Versions/Time Settings modules work? I will admit it is a bit of a complex topic to explain over a forum. Any good articles or resources you have come across?