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…)
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.
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:
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…)
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…)
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:
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…)
|
||||
