Skip to Content
avatar image
Former Member

Conversion file Formula does not work as defined in the formula column

Hi BPC experts,

I use the SAP BPC 10.0 NW version.

When i tried to implement the Conversion file formula, it does not work as expected.

To test it, I took one record in the Data file, Transformation file and Conversion file with 2 sheets (ACCOUNT & Calc).

while loading the data into BPC through Data manger package (Import), it converts the

Account from 31322170 to 31322171. (as expected)

But does not convert the signeddata as requested in the Formula column (value * 1.10).

Enclosed screen shots:

1. Data file - 1 record

2. Transformation file

3. Conversion file - Account

4. Conversion file - Calc

5. Data in the BPC cube after import.

Could you please let me know where i went wrong in this.

Regards,

Raj.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 14, 2017 at 02:05 PM
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Rajesh,

      There is nothing that seems to be wrong with your transformation, I have tested the same in my system and it works. You may want to try conversion with some other dimension, start afresh, create new transformation/conversion and check if it works on some other dimension?