Posted on June 26th, 2008 by admin
Life cycle of a DW ( Data Warehouse ) project
After many requests ,I am compiling everything in one page for easy page navigation and easy learning.hope you like it.
1 )Requirement Gathering
Requirements Gathering is started by directly discussing or with JAD sessions (Joint Application Development) with the End users .The help of Business leader or Business […]
1 Comment »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Interview Questions(& answers), Oracle Apps, Reports, SQL
Posted on June 20th, 2008 by admin
This short Article shows the basic Installation steps in installing OBIEE on your windows PC.
Pre-requisite
Computer with Windows XP (Home Basic) ,RAM 2GB, HDD approx 80 GB
JDK 1.5 installed and JAVA_HOME created.
Download the OBIEE setup from the www.Oracle.OTN.com. After downloading, I recommend to unplug the internet (turn off wireless internet or unplug the LAN wire )from […]
9 Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, OBIEE, Reports
Posted on June 18th, 2008 by admin
Benefits of data warehousing
Some of the benefits that a data warehouse provides are as follows:
A data warehouse provides a common data model for all data of interest, regardless of the data’s source. This makes it easier to report and analyze information than it would be if multiple data models from disparate sources were used to […]
No Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, PL/SQL, SQL
Posted on June 18th, 2008 by admin
Repository is a place where data are stored and maintained. A repository can be
a place where data is stored
a place where specifically digital data are stored
a site where eprints are located
a place where multiple databases or files are located for distribution over a network,
a computer location that is directly accessible to the user without […]
1 Comment »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, PL/SQL, SQL
Posted on June 16th, 2008 by admin
Incremental Enhancements
After the system is up and running in the Production environment,there are situations where small and minor changes arises.(Incremental Enhancements).The task can be as simple as to do the changes in the production environment,but is highly risky to do on live (production)systems.Do the chnagses on the Developmetn and roll out the changes in the […]
1 Comment »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, Interview Questions(& answers)
Posted on June 16th, 2008 by admin
Development life cycle of a DW ( Data Warehouse ) project.
The DW project follows following different stages.
1. Requirement Gathering
2. Physical Environment Setup
3. Data Modeling
4. ETL
5. OLAP Cube Design
6. Front End Development (Reports )
7. Performance Tuning
8. Quality Assurance
9. Rollout To Production
10. Production Maintenance
11. Incremental Enhancements
google.load(”visualization”, […]
No Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, DBA (DataBase Administrator), DataWarehousing, Discoverer, ERP, Interview Questions(& answers), Oracle Apps
Posted on June 16th, 2008 by admin
Production Maintenance
After the DW project goes live activities like taking backup on regular time period and mangaging crisis becomes very important and needs to be planned well in advance.
The other task is to monitor the Users and to know how much they utilize the DW; so future enhancements can be planned.
Next >> Incremental Enhancements
[…]
1 Comment »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, Interview Questions(& answers)
Posted on June 16th, 2008 by admin
Rollout To Production
After the QA team completes the testing ,they will give thumbs up(signoff document) to go to Production servers. It will take less then a week to go to live once everything is tested and approved.
Deliverables
· Delivery of the data warehousing system to the end users.
Next >> Production Maintenance
[…]
2 Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, ERP, Interview Questions(& answers), Oracle Apps
Posted on June 16th, 2008 by admin
Quality AssuranceThis phase is shown in the form of flowchart of the process of QA to Production. Once the DW team completes the development work, the QA team which is from the Client side starts doing testing and the reports.
If there is any changes to be done, the Development team will work on the CR […]
1 Comment »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer
Posted on June 16th, 2008 by admin
Performance Tuning
The Performance tuning of 3 areas to look for are as below. These tasks can easily take around a week.
1) ETL - Since Loading data is very time consuming ,its best to put that activity in a night load job.The ETL process needs to be tuned more and more as possible,since some problems are […]
2 Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, ERP
Posted on June 16th, 2008 by admin
Front End Development of Reports
In this phase of DW project if the reports are not bringing any value to the end user or executive, then the efforts to build the OLAP cube is wasted. so its very important to think about the end reports and timely delivery of reports to the end user. It is […]
2 Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, Interview Questions(& answers), Oracle Apps, Reports
Posted on June 16th, 2008 by admin
what is OLAP Cube Design ?
OLAP databases provide aggregated summary information quickly using a schema that is easily understood by end users.
In the OLAP design it is not required to join tables together the way it is done in relational database. It contains all the relationships required to enable a specific sets of queries for […]
2 Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Interview Questions(& answers), Oracle Apps
Posted on June 16th, 2008 by admin
ETL ( Extraction ,Transformation and Loading )
This phase of ETL ( Extraction ,Transformation and Loading ) takes the most of any Datawarehousing project.
This phase has to get the source data and following:
· Understand the Business Rules
· Understand the necessary Columns of tables.
· Understand the Logical data model
· Understand the Physical data model
The Developer has to […]
1 Comment »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, Interview Questions(& answers)
Posted on June 16th, 2008 by admin
Physical Environment Setup
After the Requirements are gathered, its necessary to set physical Envioronment by installing database and maintaining the Physical servers.The usual set of servers include 3 sets of instances.
Development servers: where the developers work on the database and roll it for testing.
Testing Servers: the objects developed by the developers are tested on this server […]
2 Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, ERP, Hardware
Posted on June 16th, 2008 by admin
Requirement Gathering
Requirements Gathering is started by directly discussing or with JAD sessions (Joint Application Development) with the End users .The help of Business leader or Business managers is required for this meeting and department co-operation is needed since individual departments will need to share their part of information.
The goal of this discussion is to identify […]
1 Comment »
Filed under: Ad Hoc Reporting, Business Intelligence, DBA (DataBase Administrator), DataWarehousing, Discoverer, Interview Questions(& answers)
Posted on June 16th, 2008 by admin
Data Modeling
Data modeling is the process of identifying the data sources.Its observed that many a times this step is often delayed.
The data identification step is important and is better to be done by an experienced person and in this phase, else it might become tough to solve it in the later stages,until the ETL process.It […]
1 Comment »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, ERP, Interview Questions(& answers), Software
Posted on June 8th, 2008 by admin
Discoverer Plus is intended as a web version of Discoverer Desktop.
Advantage of Discoverer Plus :Plus offers the benefit of enabling access via a web browser instead of installing Discoverer Desktop on each
user’s PC.
Features currently in Discoverer Desktop 4.1 BUT not available in Discoverer 4i Plus.
Query Building Subqueries Find in Item Navigator
Reporting […]
No Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, Discoverer, ERP, Reports