Thursday, December 23, 2010
Run two .rpd files
Wednesday, December 22, 2010
Reset -oc4jadmin - Password
Stop OC4J and the Application Server Control.
- (Windows) ORACLE_HOME\opmn\bin\opmnctl stopproc ias-component=OC4J
- (Windows)ORACLE_HOME\j2ee\home\config\system-jazn-data.xml
.
.
.
Replace the existing encrypted password with the new password.
Be sure to prefix the password with an exclamation point (!). For example:
- Must begin with an alphabetic character. It cannot begin with a number, the underscore (_), the dollar sign ($), or the number sign (#).
- At least one of the characters must be a number.
- Can contain only the following characters; numbers, letters, and the following special characters: US dollar sign ($), number sign (#), or underscore (_).
- Cannot contain any Oracle reserved words, such as VARCHAR.
Delete cached password data by deleting the contents of the following directory:
Wednesday, July 15, 2009
Tuesday, June 23, 2009
Saturday, April 25, 2009
Project Proposal
- Select a Company
- Name
- Scope
- Gather the requirement to complete each stage. Prepare Requirement Design
- Physical Sources
- Facts and Dimensions
- Hierarchies
- Subject Areas
- Answers
- Dashboards
- Functional Design
- Type of Business
- Need for OBIEE
- No. of Departments
- Existing system / Data Sources
- How the data moving from OLTP to OLAP
- What reports
- What Dashboards
- Technical Design
- Data sources / Database
- Facts and Dimension tables
i. At least two fact tables
ii. At least three dimension tables
- Columns in each table, keys, etc.
- Dimension modeling / Hierarchy
- Field naming convention
- Subject Areas
- Reports
i. Each report specifications
ii. Columns
iii. Filters
- Dashboards
- Pages
- Reports of each page
- Develop RPD (Final RPD need to be submitted)
- Develop Answers/Reports
- Develop Dashboard and Pages
- Presentation
Wednesday, February 25, 2009
Repository 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