Trailing zero's in obiee11g

Hi,

If you have 15 digit's Account number on your dashboard prompt with varchar data type its loosing the trailing zero's.

to resolve this issues, to the below

can you try below on your column prompt --> edit formula --> try below

cast(cast( Column as int) as char)

Thanks