Skip to Content
0
Former Member
Mar 14, 2014 at 07:10 AM

Remove zeros in LOVs of BW Infoobjects on Webi report

29 Views

Dear Experts,

My BW infoobjects(0GL_ACCOUNT) showing preceding zeros in the BI4.1 WEBI Prompts LOVs, so user don't want the zeros and they need only values and also they compare BEx analyzer with BO since BEx analyzer LOVs shows only values without zeros.

Is there any function or setting either in BO or BEx designer to remove zeros in the BW infoobjects? so that in BO LOVs display only values without zeros.

Currently values is 0000123456 in BO LOVs and user want only 123456 as per BEx analyzer.

BEx query as semantic Layer

Platform: BI4.1 SP01

BW: BI7.3 SP6

Please help

Thanks in advance.

Regards

Karuppiah N