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

Enter "99999" where there is blank in conversion file for SAP BPC 10.0 (NW)


Hello Experts,

I am working on legal consolidation. While uploading transaction data from BW, there are few fields which are blank for a table:

For eg: In case of cost of sales approach, for balance sheet items there is no functional area. Hence the field is blank.

I want to add "999" to Balance sheet items in 0FUNCAREA at the time of uploading TRANSACTION DATA.

Since my system is showing an error for blank fields, Can anyone of you help me on how my conversion file will look like.

Any help on this will be highly appreciated.

thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2013 at 10:18 AM

    Hi

    Instead of writing a conversion file for your requirement, try the below in your 'Mapping' section of 'Transformation file'

    BPC_DIMENSION_NAME=*If (0FUNCAREA = *Str() then *Str(999);0FUNCAREA)


    The above function will add '999' in place of all blank' values of the functional area field.



    Thanks

    Venkat

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 02, 2014 at 06:38 PM

    Hi..

    I think its because of no space between open and close parenthesis

    ..So at position 23 we have Close Parenthesis")" .. instead of that just give a space in between

    *str( SPACE ) .. and try to to re execute it.. Thanks

    Hari

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 02, 2014 at 09:48 PM

    Hi

    The formula seems ok , try to copy paste the same formula in other row & try..

    Also check the spaces as suggested by Hari.

    JAck

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello CA,

      This is how our company deals with blanks:

      FLOW=*IF(0MOVE_TYPE+*STR(NOVAL)= *STR(NOVAL) THEN *STR(Other); 0MOVE_TYPE)

      So basically, if 0MOVE_TYPE + "NOVAL" is just "NOVAL" (aka, the 0MOVE_TYPE is empty), then replace with "Other". You can put whatever you want for the "NOVAL" text, that is just what we chose to call it.

      Let me know if this helps,

      Alexander

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.