WEBI - Supression of Zero's

[Former Member]

Hi All,

We have designed Relational Universe (BW - DSO) and when it is displayed using BW Query, the leading zero's are automatically truncated.

However in WEBI ,leading zero's are not getting truncated. Business scenario requires no leading zeros. not only for this object but for all the infoobjects with this property ( BW Alpha conv - Objects).

1) We have tried trucate option but this is not feasible as there might be data loss due to the length of the object.

2) Universe variable ( as the LOV still retains the leading zeros when used in the report)

3) Data type mapping its throwing error while using WEBI.

Please help with some options...

-

[Former Member]

There is a note about that topic:

1831669 - InfoObjects keys are shown in Internal format while creating the universe in IDT using JCO connection

[Former Member]

Hi,

In your object

In IDT write following formula

ltrim([YOUR_TABLE.COLUMN],'0')