How to remove leadign zero's while loading transaction data from BI to BPC

[Former Member]

Hi,

I have data like as below in SAP BI, i need to remove leading zeros while loading these records in BPC because in BPC id's are like CH28_832361 format,

Is there any way out in conversion mapping in BPC?

CH28 _0000832361

US00 _00008997

CH28 _0000842929

CH28 _0000832833

US00 _00008411

CH28 _0000843422

GB00 _0000421

[Former Member]

Harish,

check with the code.

CLEAR : ct_data.

  ct_data = <lt_final>.

  DESCRIBE TABLE <lt_final>   LINES l_linecount.

  SHIFT l_linecount LEFT DELETING LEADING '0'.

  CONCATENATE l_linecount ' records have been written to the application'

              lv_datum_char 'at' lv_uzeit_char

           INTO l_log

           SEPARATED BY space.

  cl_ujk_logger=>log( i_object = l_log ).

Regards

Mohan

[RichHeilman]

You can use a START_ROUTINE or END_ROUTINE BAdI implementation in your transformation file. You can write ABAP code to remove the zeros before loading into BPC.

Regards,

Rich Heilman

[Former Member]

Thanks for the update Rich

[Former Member]

I am trying to load transaction data using DM infoprovider package.

BPC Version is 7.5NW

[Former Member]

Check for below option(how to guide for loading to bpc 75nw)

Scenario 3

If your BPC Cost Center member id design follows scenario three, then you seek to remove the

Controlling Area and to add a prefix (CC_) to the master data. This scenario can be implemented in

two variations.

How To Import Master Data and Hierarchies into BPC 7.5 from SAP NW BW

July 2010 6

Scenario 3a

In Scenario 3a users want the CC_ prefix added to both the Cost Centers and to the hierarchy text

nodes. An *IF condition is used to check for the Controlling Area in the first four positions of the

hierarchy text node IDs and an offset is used to avoid it.

*MAPPING

ID=IF(ID(1:4)=STR(SAP1) then STR(CC_)+ID(5:12);STR(CC_)+ID)

CURRENCY=0OBJ_CURR

PROFIT_CTR=0PROFIT_CTR

COMPANYCODE=0COMP_CODE

Scenario 3b

However your users may not want the prefix added to the hierarchy text nodes shown above. This

can be avoided using the mapping below which contains an *IF condition to test if the first four

positions of the record contains the Controlling Area (SAP1) which is indicative of a hierarchy text

node record and therefore it skips to position 5 of the node ID, otherwise the record is a Cost Center

which should have the CC_ prefix appended.

*MAPPING

ID=IF(ID(1:4)=STR(SAP1) then ID(5:12);*STR(CC_)+ID)

CURRENCY=0OBJ_CURR

PROFIT_CTR=0PROFIT_CTR

COMPANYCODE=0COMP_CODE

Other option maintain conversioin file, with little java scirpt code: check below sap help page

http://help.sap.com/saphelp_bpc75_nw/helpdata/en/bpc_nw_index.htm

[Former Member]

Naresh,

Thanks for your reply, I have no issues in transformation files as my scenario is a mix of how to guide solution 2 & 3 which was already done.

My transformation file code is as below.

D_ACCT=0CO_AREA*STR(_)PL_COSTEL

Now the problem is leading zeros are retriveing when trying to load transaction data into BPC. In DM package we dont have an option to choose internal format to eliminate leading zeros.

Now the point is that, without writting any start or end routines to elimimate zeros' in BI, is there any possiblities to do so in BPC conversion files using wild cards or so?