Skip to Content
author's profile photo Former Member
Former Member

SEM:BCS - Copying Consolidated data from one version to another


We have a situation where we do Consolidation of Forecast data. However this involves mixing Actuals data. For eg.

1) Q3 forecast would contain Q1 and Q2 as Actuals and Q3 and Q4 as Forecast

2) System has already done the consolidation for Q1 and Q2 lets say in version 0

3) Forecast is a different version eg. F1.

4) I want to be able to copy the Consolidated data of Q1 and Q2 from version 0 to version F1. Then load the data for Q3 and Q4 for forecast and perform consolidations for Q3 and Q4.

What I have seen in the system is -

a) You can copy only the non-consolidated data from one version to another and not for eg. Elimination entries etc.

b) This means that I have to perform consolidations in version F1 for quarters Q1 and Q2 again even though its already been done in the Actuals version (0).

c) Is there any way out of this. There is always the possibility that the consolidated data in Q1 and Q2 does not match between Actuals (version 0) and Forecast (F1)

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Sep 30, 2006 at 02:05 PM


    We had the same issue. In your solution you'll have to delete old (Q1 and Q2) forecast data and replace them by actuals. It's too problematic.

    And you are absolutely right about possible inconsistency between actual and forecast data.

    So, we've chosen another way.

    We make separate consolidation in actual, budget, plan and forecast versions.

    In plan and forecast we everything that is possible do periodically (including currency translation) -- to avoid the possible influence of historical data.

    In a BEx query (and Excel workbook) level we retrive: N months of fact, forecast data for N1 month and a plan data for N2 month. After summing up all figures we have predicted (name it as forecast) data for N+2 months.

    Of course, the actual, forcast and plan components are hidden in a report.

    This is possible because, in plan and forecast we use turnovers (not balances) only. Even a balance sheet is produced without problems, not talking about P&L and Cash Flow.

    Hope it helps.


    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 03, 2006 at 09:42 PM

    Thanks Eugene,

    I face one more issue on this. I expect that would have been a fair amount of effort especially for Currency Translation etc.

    One more question -- while doing a copy I see that there is no way to copy Opening Balances. I guess with your solution you did not have that issue but in general have you faced this issue and have found any resolution to this ?

    with regards


    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Anil,

      In my case I have the full number of entries (including beginning balances) of fact data until the reporting period.

      For the next period and period +2 I simply add plan and forecast consolidated turnovers. So, Factual balances plus plan and forecast turnovers formate the proper ending balances.

      Repeat once again that I do it on a query/report level.

      Best regards,


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.