Skip to Content
avatar image
Former Member

Displaying leading zeroes

Hi,

I am facing a problem in displaying leading zeroes for a char in a BW report. This char has length 4 and it should show the value as 0ABC in the report but instead it displays just ABC. When checked the info providers, the data is right there.

Technical details: length - 4, Conv Routine - ALPHA, BEx display - Key & text

Could someone please throw some light on this?

Thanks a lot in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    Oct 25, 2010 at 09:58 AM

    HI Bob,

    whats the char you are using and what if the data type for the char?

    check of the values are correctly populating or not?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 25, 2010 at 10:50 AM

    Hi,

    The data type is CHAR and its a custom info object which holds the locations with the length as 4.The data is getting populated correctly till the info provider level. But when I execute the report, this shows just 3 numbers (ABC) not 0ABC.

    Hope I am clear now...

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 27, 2010 at 12:11 AM

    Hi Bobs,

    Here is what I understood from your query;

    You have leading zeros for the char info object in the info provider but while running the query it is returning with the rest of the characters but not leading zeros?

    Yes while loading in to info provider ALPHA conversion does add any leading zeros according to the char size to load in to the info provider but while reporting it does the reverse ALPHA. but you have to check the values in the master data for the char info object where the default option for query results on char objects to retrieve key and text values from char object master tables. I think the master data for the char info object might not be have leading zeros.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Is there any other conversion routines (other than ALPHA) which can help add the leading zeros.

      I can see many others, but not sure what they do.

  • avatar image
    Former Member
    Jun 07, 2011 at 01:22 PM

    Hi,

    I have the same problem.

    I have one infoobject that in the cube has the following value in the cube: 00000000000012345.

    When I run the query only appears 12345. I need to see the zeros also.

    How did you solve the problem?

    thanks in advance

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 15, 2013 at 10:44 AM

    Hi,

    Remove the ALPHA conversion from the Char infoobject.

    If the data is loaded already for the Char infoobject to the data target, reload the data from the Datasource level where you are getting the values with leading 0's.

    Then try to execute the report with char infoobject in it.

    May be this could help.

    Thanks in advance.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 16, 2013 at 11:08 AM

    Hi Rahul,

       you can use the concatenate statement to precede the output value 'ABC' with leading zero as per with the length of the field.

    Eg: ABC will get displayed as "0ABC".

    This can be done using the customer exit.

    Please let me know if any help needed or doubts if you have.

    Thanks,

    Umashankar

    Add comment
    10|10000 characters needed characters exceeded