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

FXTRANS - notrans

Hi

I have a number of KPI the I would like to exclude from the currency conversion logic. To make sure that these accounts are not translated I have set the RATETYPE property to NOTRANS.

When running the currency conversion these accounts are not ignored but the are set to zero. How do I get the currency conversion logic to ignore these accounts. According the help that is what NOTRANS should do?

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 28, 2009 at 01:00 PM

    Unfortunately the help files of SAP BPC aren't that update or misleading sometimes.

    To use the NOTRANS you should add that in de Currency conversion rule table and set the formula to 1. More easy is just to leave the RATETYPE empty. This also will also result in de the fact no x-rate conversion will take place.

    HTH

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      The thing you would like is not possible. Currency translation will always copy the relevant data to DKK (either being the same as LC or 0 in case of NOTRANS.) The term that it is skipped means it will be set to 0 in the next group.

      Sorry for that.

  • author's profile photo Former Member
    Former Member
    Posted on Sep 28, 2009 at 01:09 PM

    would be nice if one could rely on help being correct.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 28, 2009 at 01:36 PM

    Blank means same as LC it should be ignored

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 29, 2009 at 06:52 PM

    Hi

    I have exactly the same issue. We have a a number of KPi accounts that are only correct after we run a package and after we consolidated the numbers into the consolview because of the eliminations.

    Whenever an sprunconversion is run it reverses the amounts to 0 and we have to rerun the KPi packages even though none might have changed.

    I have also read up and tried notrans, asis etc and tried different datasources with no translation and this did not work. This limitation in BPC means that we generate several million extra records during a month end process and is impacting performance.

    Last week I requested and enhancement from SAP for a rate type that does "nothing" in any reported or group currencies.

    If you ever come up with an answer I would like to know.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Would it be possible to limit the accounts with the following lines in the FX trans logic

      *SELECT(%ACCLIST%,"[ID]","Account","[RATETYPE] not in ('NOTRANS')")

      *XDIM_MEMBERSET ACCOUNT = %ACCLIST%

      *RUN_STORED_PROCEDURE=SPRUNCONVERSION([%APP%],[%CATEGORY_SET%],[DKK],[GLOBAL],[%SCOPETABLE%],[%LOGTABLE%])

      *Commit

      Or will the account list be reset by the SPRUNCONVERSION procedure?

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.