Leading Zeroes suppressed of CSVdownload in obiee 11g

Leading Zeroes suppressed of CSVdownload in obiee 11g

Work around is: Add following code in fx and make your data format as: HTML.

'<span style ="display:none">&nbsp</span>' ||  'YourColumn' 

Make sure that your column is varchar, if not convert to varchar. 

Disadvantage with this approach is: No problem as long as you are downloading it to excel. But if you are downloading the report to pdf, then entire code will appears as value.

Alternative work around:

CAST( 'Column name' AS CHAR) || '.'

This will definitely work but you should not worry much about the 'period' after the column value. Anyways this would not appear in the csv download file though.