cancel
Showing results for 
Search instead for 
Did you mean: 

Enter "99999" where there is blank in conversion file for SAP BPC 10.0 (NW)

Former Member
0 Kudos
529


Hello Experts,

I am working on legal consolidation. While uploading transaction data from BW, there are few fields which are blank for a table:

For eg: In case of cost of sales approach, for balance sheet items there is no functional area. Hence the field is blank.

I want to add "999" to Balance sheet items in 0FUNCAREA at the time of uploading TRANSACTION DATA.

Since my system is showing an error for blank fields, Can anyone of you help me on how my conversion file will look like.

Any help on this will be highly appreciated.

thanks

View Entire Topic
Former Member
0 Kudos

Hi

Instead of writing a conversion file for your requirement, try the below in your  'Mapping' section of 'Transformation file'

BPC_DIMENSION_NAME=*If (0FUNCAREA = *Str() then *Str(999);0FUNCAREA)


The above function will add '999' in place of all blank' values of the functional area field.



Thanks

Venkat

Former Member
0 Kudos

Hi

Thks for your reply!

However, I am getting the below error

Start validating transformation file]

Validating transformation file format

Validating options...

Validation of options was successful.

Validating mappings...

[line 18] Unexpected  ')' at position 24 in the mapping formula [*If (0MOVE_TYPE = *Str() then *Str(other);0MOVE_TYPE)]

Validation of mapping failed; check the worksheet for highlighted errors

Validating conversions...

Validation of the conversion was successful

Saving transformation file failed

I also tried validating with the below logic

However I am getting the below error

RamanKorrapati
Active Contributor
0 Kudos

Hi,

Two of your mappings are wrong.

0MOVE_TYPE? what is this info obejct refers at bw?

If you bw cube have 0FUNCAREA then

at MAPPINGS you can write as mentioned by cvraman

FLOW = *IF (0FUNCAREA = *Str() then *Str(999);0FUNCAREA)

Thanks

Former Member
0 Kudos

Hi Raman,

Apologies for the confusion. My query and content is different.

Instead of functional area , I am now trying to map the flow dimension.

OMOVE_TYPE: is consolidation transaction type used for Cash flow purpose.

Where the field in my flow dimension is blank, I want "Others" in my Flow dimension.

 

Now I request you to kindly refer to my reply again wherein I have given the screenshots of error faced.

Thanks


RamanKorrapati
Active Contributor
0 Kudos

Hi,

Your bw info object is 0MOVE_TYPE  and bpc dim is FLOW which going hold 0MOVE_TYPE values. when is 0MOVE_TYPE is blank you need to store value "OTHERS".

if yes then just under mappings for flow you can write as below and try it.

FLOW = *IF(0MOVE_TYPE = *STR() THEN *STR(OTHERS);0MOVE_TYPE).

Thanks

Former Member
0 Kudos

Hi Raman

Your interpretation is correct. However, I am getting the below error:

Please see below my transformation file for data upload from BW

Please see the below error I got

Thanks

CA

Former Member
0 Kudos

Hi CA

Just copy paste the below code in your 'MAPPING' section of 'TRANSFORMATION' file and try once.

FLOW=*If(0MOVE_TYPE = *Str( ) then *Str(Other);0MOVE_TYPE)


It works!


Thanks

Venkat

Former Member
0 Kudos


Hi Cvraman

Please see the below error I got after applying your logic in my mapping section

Thanks

CA

Former Member
0 Kudos

I used the same *if formula for my below case :


My Source Transaction file document is:

In Transformation file's MAPPING' section, I wrote the 'Code' like below to replace all the blank values with 'C_4000'

BP_COMPCODE=*If(BP_COMPCODE=*Str( ) then *Str(C_4000);BP_COMPCODE)


I got the output successfully like below without any error pop-ups.


I could not understand why it is not working in your system?

Can you try the same *if function with other dimension values for testing..(by creating a scenario of your own)?

Thanks

Venkat

former_member215589
Active Participant
0 Kudos

Hi,

What is the EPM version and SP on which you are working.

Regards,

Priyanka