Posts

ESSBASE integration with OBIEE

Image
Objective: I n this blog I will explain how to create & load data into a Cube in EAS console and import this Cube into OBIEE to build Dashboards on that Cube. Note : Assuming that the reader having basic understanding on Hyperion and OBIEE Tools. I’ll cover the following topics: A.       Overview of ESSBASE and OBIEE integration B.       Creation of a Cube in EAS Console C.       Importing & building Subject Area this Cube in BI Administration tool RPD D.      Generate Reports & Dashboard A.     Overview of ESSBASE and OBIEE integration ESSBASE   Multidimensional database storage system (MOLAP).    For complex business modelling. OBIEE   Converts Multidimensional Online Analytical Processing (“MOLAP”) data into Relational Online Analytical Processing (“ROLAP”).   With ESSBASE as a middle layer, OBIEE is very easy for End users to generate reports and design dashboards in less span of time. Overview of ESSBASE and OBIEE integrat
Post a Comment
Read more

Upgrade OracleBI(OBIEE) 11g to 12c

Image
An Overview of an OBIEE upgrade Oracle released the latest version of OBIEE — Oracle Business Intelligence Enterprise Edition 12c (12.2.1.2.0) — in October 2016 . This version offers a number of new features and considerable improvements over the previous versions of OBIEE. Features: It is now more Business friendly to offer agile and self-service; IT friendly to offer better governance, maintenance and easy installation Aligned to BI Cloud Strategy   Introduction of .bar files and extended subject-areas for data mashups Consistency across on premise and cloud with colorful icons for better visibility Comes with data visualization (separately licensed though) Several enhancements to graphs views, reports and dashboards Offers Baseline Validation Tool for comparison of data between 11g and 12c environments There are two ways to upgrade OBIEE from 11g to 12c They are   Oracle Fusion Middleware Upgrad
Post a Comment
Read more

ORACLE BI(OBIEE) Federation

Image
Modelling Federated Data using Oracle Business Intelligence (OBIEE) This is one of the most powerful features of OBIEE. Data exist in many different places. Instead of moving data to a single database, the  BI Server  can access multiple databases simultaneously to answer a single query, regardless of whether the databases are from different vendors. When the BI Server accesses heterogeneous databases, it handles automatically, database operations such as (sort and  join  ) and required transformation. The BI server can access a large of  data sources ( Relational Database Systems, Oracle, Peoplesoft Enterprise, JD Edwards Enterprise One, Oracle e-Business Suite, and SAP R/3 and mySAP, OLAP Sources like   Hyperion  Essbase ,  and   SAP BW  Infocubes etc.,.)  included XML. This capability is also called  Federation/Multi-Database Access/Cross-Database Join. In  OBIEE  terms, Data Federation involves bringing in the metadata from multiple sources into t
Post a Comment
Read more