Posted on June 30th, 2008 by admin
The Business Intelligence and Data Warehousing Glossary
I have collected and compiled this from a very nice website.Some of the terms are relating to Microsoft’s tool (Microsoft’s Analysis Services ) but that can be generalised to other non-microsoft tools also.
Link >>
Agent
An application that searches the data and sends an alert when a particular pattern is found.
Aggregations
Information […]
No Comments »
Filed under: Business Intelligence, DataWarehousing, Discoverer, Interview Questions(& answers), OBIEE, PL/SQL, Reports, SQL
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 23rd, 2008 by admin
STEPS REQUIRED TO CREATE A SIMPLE FLEX FIELD REPORT (continued to FLEX Field Reports )
1. Open the Report in Report Builder.
2. Create User defined parameters as per our requirement.
3. Call FND SRWINIT User Exit in Before Report Trigger.
BEGIN
SRW.USER_EXIT (’FND SRWINIT’);
RETURN (TRUE);
END;
4. Call FND SRWEXIT User Exit in After Report trigger.
BEGIN
SRW.USER_EXIT (’FND SRWEXIT’);
RETURN (TRUE);
END;
5. Call FND […]
1 Comment »
Filed under: AOL (Application Object Library ), DBA (DataBase Administrator), ERP, Forms, Interview Questions(& answers), Oracle Apps, PL/SQL, Reports, SQL
Posted on June 23rd, 2008 by admin
USER EXITS: USER EXITS are the 3rd party programs (i.e. java,Pro*c, etc.) that we can link with our reports to perform a particular task.
We can link 3rd party programs with our reports with SRW.USER_EXIT ( Name_of_the_User_Exit)’. We can reference the input parameters in user exist with SRW.REFERENCE( input_parameters).
FND SRWINIT: This User Exit is used to […]
No Comments »
Filed under: AOL (Application Object Library ), ERP, Interfaces, Interview Questions(& answers), Oracle Apps, PL/SQL, 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 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 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