Oracle BI EE Variables Overview

http://shivabizint.wordpress.com/2008/10/02/oracle-bi-ee-variables-overview/

IBot

http://stsrin.wordpress.com/

Project Proposal

1. Select a Company
1. Name
2. Scope
3. 
   
2. Gather the requirement to complete each stage. Prepare Requirement Design
1. Physical Sources
2. Facts and Dimensions
3. Hierarchies
4. Subject Areas
5. Answers
6. Dashboards 

3. Functional Design
1. Type of Business
2. Need for OBIEE
3. No. of Departments
4. Existing system / Data Sources
5. How the data moving from OLTP to OLAP
6. What reports
7. What Dashboards 

4. Technical Design
1. Data sources / Database
2. Facts and Dimension tables

                                                              i.      At least two fact tables

                                                            ii.      At least three dimension tables

3. Columns in each table, keys, etc.
4. Dimension modeling / Hierarchy
5. Field naming convention
6. Subject Areas
7. Reports

                                                              i.      Each report specifications

                                                            ii.      Columns

                                                          iii.      Filters

8. Dashboards
9. Pages
10. Reports of each page 

5. Develop RPD (Final RPD need to be submitted)
6. Develop Answers/Reports
7. Develop Dashboard and Pages
8. Presentation

Repository Creation.

Repository Creation. (.RPD Creation)

STOP the SERVERS

BI Admin
BI Presentations

START – PROGRAM FILES - OBIEE –
START Administration – Create New File (RPD)

Import data’s from Database - DSN or OCI (Oracle Connection Integrator)

Physical Layer - Joins
BMM - Business Model & Mapping – Drill/Down
Presentation Layer.

NSQ Configuration

C:\OracleBI\server\Config

Set default which we created only just (.rpd)

Rename the Catalog file

C:\OracleBIData\web

Start Service – BI Admin – BI Presentation - System will generate Catalog file

START – Program files – OBIEE – Presentation Services