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