OBIEE 11g: Pre Requisites for reporting using OBIEE 11g

As we are now using OBIEE for reporting purpose there are few important things that we need to obtain without which we cannot proceed.

Data Source: Most important is Data Source without this we don’t have the data or the metadata, so when there is no metadata there is no design and hence no reporting. Please ensure we have a data source with tables and some data and we know the details to connect to.

In order to connect to a data source (example Oracle Database) we need to have parameters that define the data source, these parameters include

• Server Name ( Where Database is hosted ex. localhost)
• Instance Name (Name of database or instance name ex. Orcl)
• Port number ( ex 1521)
• Username (Schema name or user who has access to required schema)
• Password (Password of above mentioned username )

BI System : we should have a configured and working BI domain to develop and deploy the metadata files along with login as a BI Administrator

• User Account in the OBIEE Application as BI Administrator
• Access to the installation folder ( to change config settings)

Requirements: Now the most important of all these to know what you’re doing so before we start the process of development we should get our requirements straight.

• Identify the exact data set 
• Identify the tables involved and their physical relation
• Confirm the type of view needed
• Identify the aggregations involved