Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 05, 2010 at 02:02 PM

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

    BPC Version is 7.5NW

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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?

  • Oct 05, 2010 at 02:51 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 02, 2013 at 12:20 PM

    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

    Add comment
    10|10000 characters needed characters exceeded