Displaying leading zeroes

[Former Member]

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.

[former_member182516 · Accepted solution]

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?

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[vasanth_gutta]

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.

[Former Member]

Hi,

Please let me know the solution as I also have the same problem.

I have defined the info-object as char and I have checked that the Bex report behaves in the same way when ALPHA is given or not. How to display leading zeros in bex report.

Thanks in advance for suggestions.

[Former Member]

Hi Colleagues,

do you get the same problem when you execute the Query in RSRT on the backend or the zero is only suppressed in Bex Analyzer, or in Web environment?

Best Regards,

Laszlo

[Former Member]

Hi All,

Can you please change the setting of info object.

conversion routine- blank.

Display-3 Text

I think now it should work.

Thanks

yatendra

[Former Member]

Hi

Thanks for the suggestions.

The display is 'text' in Info object maintenance and in bex report. Still there is no change in the output of the query.

I think ALPHA proceudre does not work for this.

Is there any way of writing routine for the conversion to take place.

[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.

[Former Member]

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...

[former_member182516]

This might the problem with the ALPHA conversion.

can you give a try by removing the ALPHA Conversion and execute the report.