August 23rd, 2011.
Alex
When working in a BI environment there are situations where developers need to query the production database. Such thing is not possible in many cases as access is restricted by tight security settings. Fortunately (for developers), OBIEE 11g has some back doors that can be used to win access to the underlying data sources, even if we don’t know the Connection Pool password.
In previous versions of OBIEE we could access the data sources by issuing a “Create Direct Database Request”. In OBIEE 11g, apart from this back door, we can also issue a query to the Physical Layer. Let’s see the difference between them and how the latter works in more detail.
Continue reading this post >
April 13th, 2011.
Alex
It is not unusual to find that default ports in software applications are already used or blocked in the firewall. OBIEE 11g ports are not an exception.
Knowing this, WebLogic (the application server used in OBIEE 11g) allows the administrator to change the port of the WebLogic servers.
This white paper is going to guide you step by step in order to achieve this objective. We are going to change the default port for the WebLogic Managed Server bi_server1 from the original 9704 to 8765 (any other port could be used).
Continue reading this post >
April 8th, 2011.
Alex
Starting & stopping the OBIEE 11g Domain on a Windows platform is very simple thanks to the shortcuts created during the installation. However, on a Linux platform this becomes a bit more tedious as there are no scripts for that.
In this article you will find the scripts needed to start & stop the OBIEE 11g Domain.
Note 1: In the scripts listed below, make sure you replace “$OBIEE11g_MW_HOME” with the Middleware Home folder specified during installation (e.g. “/OBIEE11g”).
Note 2: Also replace “<OBIEE_11g_server>” with the IP of the server where OBIEE 11g has been installed.
Continue reading this post >
October 27th, 2010.
Alex
Properly designing the data model of a data warehouse is well known to be key for the success of a Business Intelligence project. Today we will discuss a typical scenario that I’ve come across many times when discussing designs with other people: Modeling Related Dimensions.
Scenario
Two dimensions may have a strong relationship. For instance, we could sell personalised products for each customer. So each product is related to one customer only.
Properly designing the data model of a data warehouse is well known to be key for the success of a Business Intelligence project. Here we will discuss a typical scenario that I’ve come across many times when discussing designs with other people: Modeling Related Dimensions.
Scenario
Two dimensions may have a strong relationship. For instance, we could sell personalised products for each customer. So each product is related to one customer only. Continue reading this post >
March 19th, 2010.
Alex
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.
Continue reading this post >
