Skip to Content
0
Former Member
Jan 13, 2012 at 11:09 AM

Best way to create dataset to be exported in Excel for further elaboration

34 Views

Hello experts!

I need help with some of my custormers, that perform their work in a way that I partially disagree. They work in BOXI R3.1 SP3.

They use webi on top of relational universes (DWH layer in Oracle DB).

We created reports in webi that cover their standard analysis, but for their spot analysis they find difficult to work in webi.

I think that it partially depends on lack of known of the tool (even if they have been trained).

Anyway they need a solution to this issue:

they wont create in webi a basic set of information inserting reclassifications of information and some calculation in webi. Then they need to export information in excel to do their on spot calculations. Those dataset are often big, so they find following issues:

1)they tried to use Live Office to import the table they need but the limit of the datastream size is reached quickly (currently limit is 50Mb in our settings , but is reached even from report that exported with Save to my computer As Excel are not more than 10Mb ). I discussed with B.O. administrator and increasing much more this treashold affects general performances of other services.

2)Exporting in excel with Save As is quite cumbersome and they can't use .xlsx format as it is only supported by BI4.0 .So they get tables with more than 64K rows splitted over many sheets.

3)They also tried to export in CSV format to eventually further elaborate in Access, but .CSV only retrieve the information of the Microcube extracted by the query, not the data elaborated in the report.

Anyone can suggest further ways to behave?

Kind regards.

Roberto.