As I mentioned in my previous post, exporting a detailed report with columns having more than 15 digits in to excel was an issue in OBIEE 10g. Thanks to guys at Oracle, this is now fixed with OBIEE 11g.
However in case you have a big file with more than 10000 records (I know its not ideal but sometimes Users would like detail data), I follow below process which is also efficient than downloading a file with bigger size in excel format.
> Export > Download data as csv
> Save the file as a text file with .txt extension
> Open New Excel file and go to Data tab
> Click 'from text'
> Select Delimited, click Next
>Select Delimiter (Comma or Tab), click Next
> Select the columns (with more than 8 digits) and select Text on top in Data Format
> Click Finish
Excel I believe can accept data up to 1 Million records.
Hope this is helpful
However in case you have a big file with more than 10000 records (I know its not ideal but sometimes Users would like detail data), I follow below process which is also efficient than downloading a file with bigger size in excel format.
> Export > Download data as csv
> Save the file as a text file with .txt extension
> Open New Excel file and go to Data tab
> Click 'from text'
> Select Delimited, click Next
>Select Delimiter (Comma or Tab), click Next
> Select the columns (with more than 8 digits) and select Text on top in Data Format
> Click Finish
Excel I believe can accept data up to 1 Million records.
Hope this is helpful
No comments:
Post a Comment