Posted on June 20th, 2008 by Kamlesh Jethwa
create JAVA_HOME quickly with following steps on Windows XP (Home Basic)
The goal is to create a new variable called JAVA_HOME in Windows Operating system,so get access to System Properties window and create new variable called ‘JAVA_HOME’ and insert value where your BIN folder of JDK within your system.
more detailed steps as below.
1)Right Click on “computer”
2)Select […]
1 Comment »
Filed under: Business Intelligence, DataWarehousing, Discoverer, Oracle Apps, Software
Posted on June 18th, 2008 by Kamlesh Jethwa
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 Kamlesh Jethwa
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 17th, 2008 by Kamlesh Jethwa
How to find a column in database
Once, at a client site I was asked to do a drill through report from Purchasing to Fixed Assets. I don’t remember the exact details but it had something to do with Purchase orders. I knew little bit about Oracle Purchasing but had not worked enough on Fixed Assets. […]
1 Comment »
Filed under: 11i, Business Intelligence, DataWarehousing, Discoverer, ERP, Oracle Apps, PL/SQL, SQL
Posted on June 16th, 2008 by Kamlesh Jethwa
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 Kamlesh Jethwa
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 Kamlesh Jethwa
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 Kamlesh Jethwa
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 Kamlesh Jethwa
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 Kamlesh Jethwa
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 Kamlesh Jethwa
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 Kamlesh Jethwa
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 […]
3 Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Interview Questions(& answers), Oracle Apps
Posted on June 16th, 2008 by Kamlesh Jethwa
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 Kamlesh Jethwa
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 Kamlesh Jethwa
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 Kamlesh Jethwa
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 11th, 2008 by Kamlesh Jethwa
Thermometer in Dashboard
To create this chart, your SQL should return only one column and one row
select sum(quantity_sold) as qty_sold
from [detail_data$]
where fiscal_year = 2001
and country_region like ‘Americas’
(Complete Steps) Create Thermometers in Dashboard
Tags: thermometer chart, dashboard thermometer, dashboard gauges, jfreechart thermometer
Read the full Article
google.load(”visualization”, […]
No Comments »
Filed under: Business Intelligence, Oracle Apps
Posted on June 9th, 2008 by Kamlesh Jethwa
Quick post links
http://www.infopurple.com/open-interface-logic-and-interface-components
The provided program logic validates the records.
Any errors are transferred into another table (called Error Table).
The correct records are then transferred through a process into destination application table.
http://www.infopurple.com/interfaces-types-of-interfaces-open-interface-custom-interface
These can be used to either transfer data from Oracle Applications to a flat file or data from legacy system to Oracle Applications.
http://www.infopurple.com/interface-utl_file-sqlloader-oracle-general-ledger
sample code of Interface […]
No Comments »
Filed under: Business Intelligence, Oracle Apps
Posted on June 8th, 2008 by Kamlesh Jethwa
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
Posted on June 7th, 2008 by Kamlesh Jethwa
Dashboards continue to get a lot of attention in most organizations, Not just because of their visual appeal but they help organizations communicate strategy, monitor and adjust the execution of strategy, and deliver insights to all.
Let us break this into simple terms.
Dashboards, in the most simplest terms is a collection of different reports, all in […]
No Comments »
Filed under: Business Intelligence, Oracle Apps