cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

Hi,

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)

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Anil

Former Member
0 Kudos

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,

Eugene

Former Member
0 Kudos

Hi,

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.

Eugene