Home » Posts tagged "epm"

Posts Tagged ‘epm’:


OBIEE – Configuring Multiple Repositories and Presentation Service in the same Machine

Published by in BI & ETL, OBIEE on December 16th, 2009

This chapter explains how to go about setting up multiple Oracle BI presentation services, each configured to access a different repository file (RPD) running on the BI Server. The thing is that you can easily set up the BI server so that it manages more than one RPD file. This is done by the follow

(Read More…)

OBIEE – Checking Global Consistency before saving

Published by in BI & ETL, OBIEE on December 16th, 2009

When you save the repository, make sure the system will check the Global Consistency first. NOTE:  YOU MUST REMOVE ALL ERROR AND WARNING PROBLEMS.  THE WARNING MESSAGES CAN CAUSE PROBLEMS WHEN YOU DESIGN THE REPORTS.

OBIEE – Defining Presentation Column Names

Published by in BI & ETL, OBIEE on December 16th, 2009

Define the friendly column names to make easier the users interpretation. Don’t use the same name defined on the Logical Column name. See the example below:

OBIEE – Oracle BI EE 10.1.3.3.2 – Connectivity to Essbase – First Impressions

I had some time today to quickly install Essbase and BI EE 10.1.3.3.2 to test out the newly added feature of Essbase connectivity. Following are the list of bare minimum components that you would need to get this up and running. 1.   BI EE 10.1.3.3.2 – If you are doing an upgrade from an earlier release

(Read More…)

OBIEE and Essbase – Defining OLAP Integration

In this second part of our OBIEE series, the integration between OBIEE and Essbase is a seamless transition from our OLAP cube to the OBIEE suite managed by using OBIEE’s Administration Tool. This Administration tool has been designed with wizards, utilities, and interface design elements to help administrators work more efficiently. Using an existing Essbase

(Read More…)

OBIEE – Validating the Physical Diagram

Published by in BI & ETL, OBIEE on December 11th, 2009

After you drag and drop the physical tables to the Business Model and Mapping, you have to validate the tables and constraints on the Business Model Diagram. It will prevent many problems when you check the repository consistent. See image below: If necessary, create new relationships using the toolbar:

OBIEE – Importing Tables to the Repository

Published by in BI & ETL, OBIEE on December 9th, 2009

As a best practice, import all tables once, it will allow the OBIEE Administration Tool to identify the constraints and automatically create them on your repository. See the image below: Rather than importing Foreign Keys, define relationships using “Physical Diagram” – “Object(s) and all joints” in the Physical Diagram layer to create relationships between tables

(Read More…)

© This website and its content is copyright of © Cintra Software and Services 2011. All rights reserved.