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

BPC MS Signed Data convertion

Hi guru,

can I reverse the signed data value in data file trasformation using specific filter?

e.g.

I need to reverse the value for combination ACC1 and PR_R

ACCOUNT PROFIT SIGNEDDATA

ACC1 PR_S -100.00

ACC1 PR_R 300.00

hoped result in facttable:

ACCOUNT PROFIT SIGNEDDATA

ACC1 PR_S -100.00

ACC1 PR_R -300.00

someone can help me?

Marco

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 09, 2011 at 11:52 AM

    Hi,

    I set the convertion for SIGNEDDATA but it works only if I set:

    internal external formula

    • * Value*-1

    it doesn't workif I set the following specific value:

    internal external formula

    PR_R PR_R Value*-1

    Do you have any idea?

    Thanks

    Marco

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 08, 2011 at 02:11 PM

    Hi,

    What I could notice was you are trying to reverse the value of PR_R.

    So you should use a conversion file with internal and external as PR_R, and in the formula you can have as -1*value

    Hope this helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 09, 2011 at 04:27 PM

    I miss also to evaluate the parameter:

    CONVERTAMOUNTWDIM=PROFIT

    when it is not filled the default of this parameter was SIGNEDDATA.

    now it works fine.

    Thanks for suggestion.

    Marco

    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.