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

[Former Member]

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

[Former Member]

Hi

The formula seems ok , try to copy paste the same formula in other row & try..

Also check the spaces as suggested by Hari.

JAck

[Former Member]

Hi all,

I have tried everything but still its not working

Please note: My data is coming from BW.

SP is 03 and EPM 10

Reagards,

CA

[Former Member]

Hello CA,

This is how our company deals with blanks:

FLOW=*IF(0MOVE_TYPE+*STR(NOVAL)= *STR(NOVAL) THEN *STR(Other); 0MOVE_TYPE)

So basically, if 0MOVE_TYPE + "NOVAL" is just "NOVAL" (aka, the 0MOVE_TYPE is empty), then replace with "Other". You can put whatever you want for the "NOVAL" text, that is just what we chose to call it.

Let me know if this helps,

Alexander

[Former Member]

Hi..

I think its because of no space between open and close parenthesis

..So at position   23  we have Close Parenthesis")"  .. instead of that just give a space in between

*str( SPACE ) .. and  try to to re execute it.. Thanks

Hari

[Former Member]

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]

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]

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]

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]

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]

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]

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]

Hi Cvraman

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

Thanks

CA

[Former Member]

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]

Hi,

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

Regards,

Priyanka