BI Beans and Export to Excel

Lucas Jellema 6
0 0
Read Time:1 Minute, 55 Second

BI Beans only provides export to CSV to be imported into Excel, at least up to the 9.0.4 release:

News from the BI Beans product team:

In the 9.0.5 release of BI Beans, export to Excel is native feature. It maintains all formatting and has options for how logical pages are exported (i.e. as separate Excel sheets.

See this post by Mark Ritmann with a reference to a Java to Excel open source project: Java Excel API project. It allows developers to read Excel spreadsheets, and to generate Excel spreadsheets dynamically. In addition, it contains a mechanism which allows java applications to read a spreadsheet, modify cells, and write the new spreadsheet.

The following post on OTN describes the Java code to export BI Bean Cross Tab data to be used with Java Excel API: How to Export the BI Beans report to Excel sheet?

Another framework for Java-to-Excel of course is Apache POI – which tries to do the same thing. Both seem to offer only a Java API, not an XML to Excel transformation. Although POI with Cocoon maybe can do something along those lines. See this introductory article to POI: Excel Reports with Apache Cocoon and POI by Steve Punte (2003)

Oracle will shortly announce an Excel plugin that will support OLAP operations. BI Beans technology is underlying this plugin too. I am not sure whether BI Beans defined for a Web Application can somehow be applied to this plugin as well. The following description comes from Vlamis Software:

Discoverer for OLAP is an ad-hoc query tool that is built in BI Beans. It allows a user to browse through 9iOLAP cubes (ROLAP star schemas and MOLAP analytic workspaces). It is built in BI Beans and exposes much of the power of BI Beans in a pre-built application.

The “spreadsheet add-in” allows Excel to run BI Beans against 9iOLAP cubes. In effect, Excel serves as the “middle-ware”, launching the BI Beans query wizard and the calculation wizard. The results are then dropped into an Excel spreadsheet, along with drill-down and paging capability. If you users require direct access to their data from Excel, you will be interested in this tool. No more exporting to Excel–access your entire OLAP cube directly!

About Post Author

Lucas Jellema

Lucas Jellema, active in IT (and with Oracle) since 1994. Oracle ACE Director and Oracle Developer Champion. Solution architect and developer on diverse areas including SQL, JavaScript, Kubernetes & Docker, Machine Learning, Java, SOA and microservices, events in various shapes and forms and many other things. Author of the Oracle Press book Oracle SOA Suite 12c Handbook. Frequent presenter on user groups and community events and conferences such as JavaOne, Oracle Code, CodeOne, NLJUG JFall and Oracle OpenWorld.
Happy
Happy
0 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleepy
Sleepy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

6 thoughts on “BI Beans and Export to Excel

  1. I found a useful Excel tool recently.
    It can easy to find your excel files in seconds.And then split multi-sheet excel files into single sheet excel files with high speed.
    It do help me a lot.
    So, I want to share it to you:
    http://www.excelpedia.com

  2. See also the following link: http://linkopedia.blogspt.com or http://www.inkorus.com which contains:
    OLAP, an alternative technology

    OLAP, or Online Analytical Processing is a technology that was termed as such in 1993 by Dr. Codd[5] who invented the relational database model. OLAP was used originally as a buzzword to differentiate it from OLTP (On-Line Transaction Processing). T was replaced by A to emphasize the Analytical capabilities of the new technology as opposed to the transactional capabilities of the relational database technology. Today, OLAP is used as an umbrella term for various technologies that used to fall under the terms decision support, business intelligence and executive information systems among others.
    Hope you will find it useful

Comments are closed.

Next Post

BC4J and Distributed deployment (in particular of JHeadstart Applications)

Thusfar we have been lucky – or careless – to not have had to consider distributed application deployment. However, web-applications running in the DMZ accessed by internet users directly through HTTP (no SSL/HTTPS), as we encounter more and more often at our projects (as opposed to ‘intranet style applications’ within […]
%d bloggers like this: