Issue with Currency Conversion Business Rule in BPC 10.1 NW Standard

[Former Member]

I am trying to use the [AS_IS] keyword in the formula of one of my rules, which I have done successfully in previous versions of BPC NW.

The rule is as follows:

ID: END

Source Flow: REVAL

Destination Flow: TRANS

Formula: AS_IS

Force Closing: checked

There is local and group currency in the accounts with RATETYPE "END" for the ENTITY I am running this for.  I ran the rule with Formula [AVG] and it produced the translated results for that rate.  When I use AS_IS in the formula, no results are produced.

Has anyone run into this issue in NW 10.1?

Thank you!

[former_member225135]

Hi Scott,

Currency Conversions - SAP BusinessObjects Planning and Consolidation - SAP Library

Try to enclose AS_IS with square brackets []

ex: [AS_IS]

Regards,

Rahul

[Former Member]

Hi Rahul,

I had tried it with and without brackets, same result...nothing calculates.

[former_member225135]

Hi Scott,

Are you trying to load the figures at the combination of NON_GROUP & LOCAL CURRENCY?

Regards,

Rahul

[Former Member]

Hi Rahul,

The figures are loaded to BPC from the source system in LC and USD (reporting/group currency).  However, most accounts are re-translated using month-end spot or monthly average rate for USD.  There are some accounts (e.g. retained earnings) that I want to leave the existing USD amounts as they are from the source system.

Everything works fine when using [AVG] or [END] (monthly average and month-end spot), but [AS_IS produces no results.

Thank you,

Scott

[former_member225135]

Hi Scott,

are you loading USD data as USD or LC?

Because AS_IS will only work if you have data at the combination of group currency and non group.

So if you are loading entire amount as local currency, AS_IS will not work

Regards,

Rahul

[Former Member]

Rahul,

Loading as both USD and LC.

[former_member225135]

Hi Scott,

Can you please show the 2 line items of your bpc database ? (one with lc and second with USD- base data)

Regards.

Rahul

[Former Member]

Hi Rahul,

I got it to work.  I changed the destination flow to a new flow I created and it works with no other changes.  Not sure why that made a difference.

Thanks for your help!