ClearPeaks is pleased to sponsor and exhibit at Oracle´s upcoming ‘Business Intelligence Enterprise Edition 11g Launch Event’ in London, July 7th.
An important global event for Oracle, the unveiling of Oracle BI 11g, will be attended by Oracle President, Charles Phillips and Executive Vice President of Product Development, Thomas Kurian who will be presenting on why OBI 11g technology is the Best-in-Class BI Solution out there.
Continue reading this post >
Pivot Tables are a great feature of Oracle BI. It is arguably one of the most used views when designing reports, and offers immediate hindsight on data with drilldown capabilities on both rows and columns.
Such intelligence power comes with a few limitations though.
Pivot Tables aren’t made to visualise large amounts of data (data dumps are best managed through normal tables or even better, direct download to Excel/flat files).
When reviewing sales data, sometimes there is a need to show not only the data that exists, but also the data that does not exist. For instance, in the tables below we can see that no revenue was generated in the month of April and also that no revenue was generated from customer JKL between January and June.
In this entry I will explain how to set up Single Sign-On for OBIEE in IIS environment. For those unfamiliar with the terminology, I’ll start with just a quick overview to explain what IIS and OC4J are:
OBI is by default deployed on OC4J (Oracle Containers for Java) web application server. What does it actually mean? It simply means that the core OBI application will run on OC4J platform. This application by default is called “analytics” and the default port for OC4J is 9704 (as in http://hostname:9704/analytics).
Apart from the default installation we have other deployment options. One of the most popular being the IIS deployment – using Microsoft’s Internet Information Services instead of OC4J. Again we will have application called analytics, but the default IIS port will be 80 (as in http://hostname:80/analytics or simply http://hostname/analytics as 80 is the default HTTP port).
Oracle BI EE not only helps you to visualize information using charts and graphs, but it also gives you the opportunity to add geographical dimension to your reports.
With today’s globalization of business, many organizations have their branch offices located in various countries or even across different continents. Viewing individual branches and their performance, presented on the geographical map, can give companies further insights into their business. Oracle provides a powerful engine that can analyze and display the data from your data warehouse on the map or even integrate it with Google maps.
Welcome to the ClearPeaks Business Intelligence blog. We invite you to read our posts related to Oracle BI EE, Data Management and other BI topics, written by our consultants. If you have questions or comments, please let us know.
