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

Forecasting based on a Driver in SAP BPC 10.0 NW


I'm trying to create an input template that has say for example actuals for 6 months and 6 months of forecast that I want to save. I have a column "Driver" that the user enters the number of months of actuals he wants to consider for forecasting for a particular account. So I've used excel offset formulas to come up with the forecast data so he can just submit the data.

The actuals that are on the excel are dynamically generated based on a property I have on the Time dimension. So when a new month of actuals are present I update this field on the Dimension and the excel should get the actuals for that month. Here is my problem. When I refresh the excel workbook, because the new Actual column had formulas (I selected "keep formulas on Sheet") I don't see the actual data from the database as the value in the formula is overriding the data.

Is there an alternate option for me to accomplish what I want. I want the Actual data for the months I have actuals and the forecast data is based on a calculation. Not all accounts have a standard calculation. Please advice.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Feb 06, 2014 at 07:45 PM

    Hi Vamshi,

    It's a long text description of complex input schedule but it's close to impossible to understand your requirements without number of screenshots and Excel formula samples...


    Add a comment
    10|10000 characters needed characters exceeded

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.