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

BPC 10 Keep Formulas but sending data

Hi experts:

We are creating a planning layout in BPC 10. We choose the option "Keep formulas" and the layout keep the formulas but it doesn't send data. We have the following example.

Cost Center 01.2012 02.2012 003.2012 Q1.2012 (Read Only)

A = (Q1.2012/3) = (Q1.2012/3) = (Q1.2012/3)

We I put data in Q1.2012 the system divides the amount and inform data in the monthly basis according to the formula. This is just what we need to do but we need month data being sent to the system. is it possible to keep the formula and send the data.

Thanks in advance for your help



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 13, 2012 at 12:47 PM

    Hi Manuel,

    Normally, there is no problem in Keep Formulas and Send Data.

    What could happen is the log brings error on node member.

    ie. Taking your case, the log message will brings: 3 succeed and 1 error (The quarter member).

    Please, make sure that the report in question is set as Input Form (In case there are more than one, the only way the button Save Data be available), and the month members are unlocked.

    Also, make a test by inserting a number in place of formula and click on send data.


    In 7.5 version, we used the following document to insert values at Node Level, but I'm not sure if is working in BPC 10.



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi JosManuel, you're welcome.

      I thing that the Badi could be cutomized as you need, but this customization has to be done in ABAP code. In version 10, there is some changes from that HTG...however I can't guide you...

      About the issue, it's really a strange behavior...The formula exist in the Input Form, but the database sees just the value, the number.

      All I can do, is to give a kick about the problem.

      If I were you, certainly would start by Format Number applied in the cell, Dynamic Formatting...Report options...

      Sorry don't help you more.



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.