Skip to Content
0

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

Jul 14, 2017 at 01:55 PM

111

avatar image

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.

10 |10000 characters needed characters left characters exceeded

Why not to insert pictures correctly? As a pictures using "Insert Image" button?

It's very inconvinient to open each attached image!

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Jul 14, 2017 at 02:05 PM
0
Show 10 Share
10 |10000 characters needed characters left characters exceeded

Hi Vadim,

Thanks for the reply and the reference link.

I followed the ref link and updated the Options section and Conversion section with below.

*OPTIONS

CONVERTAMOUNTWDIM=ACCOUNT

*CONVERSION

ACCOUNT=ACCOUNT.XLS!SHEET1

AMOUNT=ACCOUNT.XLS!SHEET2

Again, I get the same result as before. Just only the Account Id is changed.

It does not convert the signeddata amount. SHEET2 does not get executed.

Could you please check and let me know, what needs to be corrected?

Enclosed the SHEET2 for ref.

Regrads,

Raj.

sheet2.png (10.7 kB)
0

Formula has to be on the ACCOUNT conversion sheet SHEET1

and remove line:

AMOUNT=ACCOUNT.XLS!SHEET2

0

Hi Vadim,

Moved the 'value*1.10' into the Formula column in SHEET1 and removed the AMOUNT=ACCOUNT.XLS!SHEET2.

And also, deleted the SHEET2 from the conversion file. Validated conversion file and Transformation file.

Ran the Import package and get the same result again.

It converts the Account ID and not the signeddata.

Screen shots attached.

Thanks for your support, Mr.Vadim.

Regards,

Raj.

0

You will still need below line in transformation file -

AMOUNT=ACCOUNT.XLS!SHEET1

While working with formula in conversion file, you need two mappings, one for the dimension (account in this case) and one for AMOUNT both referring to the same conversion file.

If working with account dimension, CONVERTAMOUNTWDIM is optional as by default it is account dimension.

0

Hi Gupta,

I updated the Transformation file as advised.

Even after that, the result is same as last time.

It does not convert the Signeddata. But converts the Account id only.

Screen shot attached.

Regards,

Raj.

0

Try AMOUNT=SIGNEDDATA in mapping

0

Hi Vadim,

Made the change as suggested below:

*MAPPING

AMOUNT=SIGNDATA

*CONVERSION

ACCOUNT=ACCOUNT.XLS!SHEET1

AMOUNT=ACCOUNT.XLS!SHEET1

Validated the transformation file and ran the Import package.

Does not convert the signed data as requested. Same value as loaded 2000.00

Screen shots attached.

Regards,

Raj.

0

Hi Rajesh,

I have tested and this works fine. Do you mind sharing your transformation/conversion/data file again and be sure on the files you are using while running DMP

0
Hi Gupta,

Enclosed the text format of Data File, Transformation file and Conversion file here.

Thanks for your support.

Regards,

Raj.


0

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?

0