Author Archives: Ron Keler

Recalls dashboard

The Consumer Product Safety Commission (http://www.cpsc.gov/) collects and publishes information about product recalls. The department made its database of recalls information available to the public as a web service, which means we can have fun with this data… Leveraging our … Continue reading

Posted in BI At Large, Data visualization, HTML5 | Tagged , , | Comments Off on Recalls dashboard

Play the pie chart Dreidel

This Saturday is the first night of Chanukah, the Jewish “festival of lights” holiday. One of the games kids play during this holiday is called Dreidel. The Dreidel is essentially a top that has four Hebrew letters marked on four … Continue reading

Posted in BI At Large, Xcelsius | Tagged | Comments Off on Play the pie chart Dreidel

Infographic style webi

Web Intelligence reports are often thought of as boxy, ad-hoc’ish, somewhat sloppy collections of tables and charts. Of course, when creating quick ad-hoc analysis queries, that is completely appropriate, but when designing corporate reports for disseminating information in a way … Continue reading

Posted in BusinessObjects 4.0, Web Intelligence | 1 Comment

BusinessObjects 4.0 RESTful web service proxy

SAP introduced RESTful web services in its BI platform (BusinessObjects 4.0) for the first time in the latest service pack SP4. This is a first step in a good direction. The rest web services available in the platform are a … Continue reading

Posted in BusinessObjects 4.0 | Comments Off on BusinessObjects 4.0 RESTful web service proxy

Gmap webi mashup – live example

Recently, i received quite a few questions from folks who were trying to deploy my gmap webi mashup example on 4.0. To make the implementation more transparent, i created a LIVE WORKING version, leveraging a BI 4.0 server and some … Continue reading

Posted in BusinessObjects 4.0 | 2 Comments

Group by on the fly

One of the great features about the google visualization api we use in our html5 dashboards, is the ability to perform client side, run time group by operations. Unlike Xcelsius, which does not provide this functionality, this ability allows us … Continue reading

Posted in HTML5 | Tagged , , | 2 Comments

Integrate real time stock info using Crystal Reports

Crystal Reports was created almost two decades ago. In Software age terms, it’s a dinosaur. There are certainly sexier, slicker and faster tools to develop with, in the BI space today. But when it comes to integration, crystal reports is … Continue reading

Posted in Crystal Reports | Tagged , , , , | Comments Off on Integrate real time stock info using Crystal Reports

Get Xcelsius EIC connection to work properly in IE9

The EIC (External Interface Connection), is a key feature of Xcelsius that allows the creation of sophisticated integrated dashboard. It’s a programmatic way to pass information through javascript to and from the html container that embeds the Xcelsius swf object. … Continue reading

Posted in Xcelsius | Tagged | 7 Comments

Visualization for Unstructured Data

One of the most interesting data visualization and BI concepts these days is unstructured data analysis. To demonstrate one use case for visualization analysis of un-structured data, and digesting large amounts of information into a more palatable dish, i created … Continue reading

Posted in Data visualization, HTML5 | Tagged , , | 1 Comment

BusinessObjects 4.0 Oracle Audit Universe woes

In BI 4.0, the Activity Universe, which was used for years as the source for auditing users and system activities in business objects, was discontinued. And while initially 4.0 shipped with no auditing reporting solution, SAP developers stepped up and … Continue reading

Posted in BusinessObjects 4.0 | Tagged | 10 Comments