January 23rd, 2012.
Enrique
In the process of building the OBIEE repository, there is a lot of information defined in there which eventually, we would like to make accessible for users without having to grant the access to the repository itself.
The generation of the Metadata Dictionary will create a set of XML/HTML webpages with the documentation data about the objects in the repository and their relationships.
Furthermore, the use of the metadata dictionary could be very useful when you are developing, or once everything is developed to check quickly the metrics, attributes, and dependences for the repository objects, with the only need of web browser.
At the end of this blog article what we are going to obtain as a result is an automatically generated documentation, which is also linked properly within Answers. This feature is available for OBI 10.1.3.4. Continue reading this post >
January 3rd, 2012.
Wilinton
Sometimes there is a need to have OBIEE system operating during planned or unplanned downtime. Because of this reason OBIEE provides a high availability capability: it is possible to configure all OBIEE components in order to offer high availability. In this entry I am going to describe the process of configuring a high available OBIEE 10g system.
Before going to the configuration I want to clarify some concepts:
Availability is the degree to which an application, service, or function is accessible on demand. Based on this concept we can conclude that High Availability is a system continuously operational as long as possible.
High availability systems can be categorized into local high availability systems which are configured in a single data center and disaster recovery solutions systems which are usually geographically distributed. OBI Server only can be configured in the first case; all components of the BI Cluster Server feature must reside on the same LAN.
High availability comes from redundant systems and components. Local high availability solutions can be categorized, by their level of redundancy, into active-active where two or more active instances are working at the same time and active-passive where only one instance is active and others are in standby.
OBIEE provides for high availability through the use of native clustering, failover and load balancing capabilities. Let’s analyze the OBIEE 10g components and how they are communicated in a clustered environment.
November 28th, 2011.
Sergi
Some Oracle Application like BI Publisher 10g uses OC4J, which is an Oracle Application Server which enables J2EE applications to run. These set of containers, API and services have to be started manually at system start up and after system downtime.
It is annoying for system administrators to have manual task to take care of. So, if we are in a Windows environment, these tasks can be avoided if they are defined as an automatic start-up process within the MS Windows Service.
Installing OC4J as a MS Windows Services we will solve that inconvenience we will take a step further in automation wise and we will decrease the services downtimes.
Continue reading this post >
October 27th, 2011.
Jordi M.
Every company aims to have its own BI dashboard which settles a monitoring tool within the working environment to check the current status of the enterprise metrics and KPIs on a single screen. These interfaces need to be tailored depending on the company needs.
One of the topics that strongly helps to have success when delivering a BI dashboard is its navigation.
Having this property well configured is fundamental to improve the user satisfaction as it provides the following features:
Consistent navigation across different dashboards or pages
Drill down; roll up to access different levels of data
Access to stand alone reports
Ability to filter the target report by the desired filter conditions (based on the clicked value)
Continue reading this post >
October 5th, 2011.
Sabrina
Abu Dhabi Gas Industries Ltd (GASCO) is a major global player, conducting onshore gas processing and the transportation of gas and liquid products.
GASCO is fully aware of the need for an up-to-date BI system to stay ahead in this challenging market, and decided to call in the ClearPeaks specialists to guide them through this development.
GASCO wants to develop an Oracle Business Intelligence (BI) System from scratch, building an Oracle data warehouse and BI system both based on 11g, the latest product version. Before going ahead with the project, ClearPeaks recommended running a Global Analysis Program in order to scope the project better and prepare a realistic project plan.
Continue reading this post >