does this solution work for you?
Oracle Support Document 1929503.1 (OBIEE 11g CSV Export Drops Leading Zeros When Imported Into Excel) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=1929503.1
Honestly saying what they propose is not a solution, it is workaround.
- The CSV format used to export raw data and import to another system.
- If you have leading zeros in your data, you should use a formula either in your request or in the rpd to enclose the data in quotes if you want Excel to not treat these as numbers.
- Another option is to open CSV file in Notepad, save it, and then open it in Excel.
When I download to Excel it is fine, but results are too wide to do it and there is export error.
Problem is in CSV.
And I can't send to user TXT/Plain text and ask for manual import to Excel.
Any suggestion what formula do they mean in point two? CAST, CONCAT do not work, as you can't add single quote.
Well: the limit is not in Oracle-BI, but in EXCEL and how it opens CSV files.
You can change this by including a ' in the column to prevent Excel from doing this. Otherwise do a manual import in Excel.
I understand, but the requirement is to find a solution on OBIEE side.
How you would like to add single quote?
If you will just add it in the formula, there is OBIEE error: End of the input has bean reached. Illegal syntax.
1 person found this helpful
Your formula must be wrong with the wrong number of quotes to get the single quote. Try: