Prior Forecast is coming incorrect in Revenue forecasting

Post Reply
Nitish
Posts: 8
Joined: Mon Nov 26, 2012 4:35 am
OLAP Product: TM1 BI Cognos
Version: 9.5.1
Excel Version: 2010

Prior Forecast is coming incorrect in Revenue forecasting

Post by Nitish »

Dear all experts,

Good Morning!

I need help from you in an issue in which I am struck.

1) Incorrect rules were saved in revenue forecasting cube on 7th Jul 2013. ('Prior forecast' element missed in one calculation)

2) Month end closing done on 16th Jul i.e. Jun period set to actuals after 2 TIs were ran.

a) 1st TI - Copy forecast to prior forecast - Project revenue - forecast months (cleared)
b) 2nd TI - Copy forcast to prior forecast - Project revenue - forecast months

3) Rules again rectified and saved in revenue forecasting cube on 21st Jul.

Because of this, the prior forecasting for the period of Jul onwards is coming with incorrect numbers but the prior forecast till June is correct all the way.

Please suggest what should I do?

Shall I open the Jun period again and run the both TIs again? Is this a right way??


Thanks!
Nitish
declanr
MVP
Posts: 1831
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Prior Forecast is coming incorrect in Revenue forecastin

Post by declanr »

Nitish wrote: Please suggest what should I do?
Shall I open the Jun period again and run the both TIs again? Is this a right way??

Nitish,

I don't think anyone here can really answer this for you.
We don't know enough about your setup and security procedures etc to know the "correct" course of action.

It should be quite simple though, things do go wrong and when they do you need to work out what numbers should be where. If you have the ability to automate the process of them getting back in (because you already hold it elsewhere in TM1 or in another source system/source file etc) then you can write a TI to get it in.
If not, someone is going to have to type those numbers back in...

Due to the fact that you are talking about "opening a period" I assume this is in the realms of Management Accounting and the decision of what the end result needs to be will probably sit with the Senior Accountant/s responsible... then it's up to you how you go about meeting that end result.

Sorry I can't be of more help, if you are able to provide more specific information then people here may be able to help with pointing you int eh right direction over the TI code etc.
Declan Rodger
Post Reply