cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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.

former_member186338
Active Contributor
0 Kudos

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

It's very inconvinient to open each attached image!

View Entire Topic
former_member186338
Active Contributor
0 Kudos
Former Member
0 Kudos

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.

former_member186338
Active Contributor
0 Kudos

Formula has to be on the ACCOUNT conversion sheet SHEET1

and remove line:

AMOUNT=ACCOUNT.XLS!SHEET2

Former Member
0 Kudos

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.

former_member210696
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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.

former_member186338
Active Contributor
0 Kudos

Try AMOUNT=SIGNEDDATA in mapping

Former Member
0 Kudos

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.

former_member210696
Active Contributor
0 Kudos

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

Former Member
0 Kudos
Hi Gupta,

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

Thanks for your support.

Regards,

Raj.


former_member210696
Active Contributor
0 Kudos

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?