cancel
Showing results for 
Search instead for 
Did you mean: 

Show leading zeros of a NUMC defined InfoObject

Former Member
0 Kudos

We have a situation where we have a zip code type InfoObject defined as NUMC and it is used by Bex Query from a MultiProvider defined over an ODS. When Bex displays this field the leading zeroes do not show. The leading zeros are in the ODS, but do not show in the query. Is there any way (other than redefining the InfoObject and relading the data) to set a property or use a formula or something so that the leading zeroes of this NUMC InfoObject will be displayed from BEx?

We are trying to avoid having to get rid of all our data, redefining the InfoObject, and then reloading all the data again.

Thanks for your reponse,

Jeri McNeany

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Jeri,

Alpha conversion is the only way. But that will mean that 0123 and 00123 are two different values. Better would be to define this as a char.

Cheers

Aneesh

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Jeri,

did you try to remove the alpha conversion from the definition of the info object? But please note the side effort: if you have any variables for it, you have to enter 0123 or 123 in the selections. in other words, 0123 is different from 123.

Lilly