Remove zeros in LOVs of BW Infoobjects on Webi report

[Former Member]

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

[former_member4998]

Hi

Try to make use of custome display fomrat option in business layer.

Find the below link for custome date format...same process for Numeric objects also