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 18th, 2012.
Isabel
Informatica Power Center can use different sources of data. The most common sources are tables, views or synonyms, but for storing small sets of data, companies usually use flat files, MS Excel files or MS Access. Informatica treat Excel and Access file sources as a relational database, not as a flat file.
Which steps do we have to follow to load this data from these files to our Data Warehouse? How are the connections created? Where do these files have to be located? How should we configure Informatica?
In this article I will explain the way to load data from Excel files using Informatica Power Center running on Windows.
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.
December 16th, 2011.
Sabrina
The ClearPeaks Team would like to wish you a Merry Christmas and Best Wishes for a Happy New Year!
