This content has been marked as final. Show 8 replies
Why are you using OBIEE as a data extract tool, wouldn't it make more sense to get the data into Excel directly?1 person found this helpful
I completely agree with the fact that such data set will not be of any use for analysis for any business users. Also OBIEE is not meant for such purpose.
Before going to the Business users & telling them this. can we see whether is there any technical workaround which can make this happen. Frankly speaking I dont want them to have a feeling of obiee having any shortcomings, which is not true.
I totally agree with rnm1978, you shouldn't use OBIEE as an extraction tool. Get your users to define extractly what questions they need answered and create those reports in OBIEE, not on Excel.1 person found this helpful
Havign said that if you do use OBIEE as an extraction tool you should know that the 56K limitation it's an Excel problem, not OBIEE. If you use the Download Data option in OBIEE you can hundreds of thousands of rows, depending on what have you set as the maximum number of rows your BI Server allows. and if you use Excel 2007 to open this data file it can load up over 1m rows (1048576 to be precise).
Besides the fact that I tottally agree with the comments above, have a look at the DefaultRowsDisplayedInDownload tag.1 person found this helpful
see the file here:
Thanks a lot for all the help ill convey the same to the business. I am marking all responses as helpful.
When you want to export large data sets in csv files, then you really should read this article about the marketing module in OBIEE:1 person found this helpful
Ok to close this for final i want to know some OBIEE facts..
1) Can obiee download CSV file more having more than 65k rows..opening it in excel is later question.. but can it download.
2) What max size limit obiee can download files of..
with all ur exp wht u see?
1) I already said it would so you are asking the same question again.
2) I am not sure where the limits is (could be our Web App server or could be OBIEE) but files seem to be truncated if they are > than ~50 MB.