what is discoverer server in oracle apps
Whats is Discoverer Server ?
Discoverer is and adhoc query, reporting, analysis and publishing tool which help business users to get quick access to information from datawarehouse or OLTP systems. In Apps, Discoverer version 4i used to be installed & configured out of the box which is desupported now. You should configure Apps with Discoverer 10g (I am going to cover about how to configure discoverer 10g with E-Business Suite)
What should I know about Discoverer as an Apps DBA ?
Though each component in Apps like forms, reports, web server including Discoverer in itself are quite big and more you know about them better it is for you . Few Important things you should know about Discoverer in Apps is like how to start/stop & how to access it. In case of any issues you should be able to troubleshoot discoverer.
What is EUL ?
You will hear lot about EUL from business analyst which means End User Layer, which is the key to provide ease of use to underlying data in Oracle Apps Database.
Technical things about discoverer in Apps ..
–In Apps default discoverer version 4i, is installed under $ORACLE_HOME/discwb4
–Script to start discoverer server is addisctl.sh under $OAD_TOP/admin/scripts/$CONTEXT_NAME
– This script in turn start discoverer processes which can be start by startall.sh under $ORACLE_HOME/discwb4/util (This script is different from adstrtal.sh)
– startall.sh calls scripts like startgatekeeper.sh, startlocator.sh , startoad.sh, startosagent.sh to start gatekeeper, locator, oad & osagent resp.
– In Apps two major way to access EUL is via Discoverer view & Discoverer Plus edition (You can use Discoverer Administration Edition as well)
A. How will you find discoverer version in Apps ?
B. What URL you use to access Disco viewer & Disco plus .
Plus–http://hostname.domain:port/discwb4/html/english/welcome.htm
Viewer–
http://hostname.domain/discoverer4i/viewer
Note-
The location for looking for dis4pr is
$ORACLE_HOME/diswb4/bin
where ORACLE_HOME -> 8.0.6. Oracle Home
Oracle Discoverer is a business intelligence tool to support organizational decisions and data will show in the form of excel format.
Components of discoverer:-
1.Discoverer Adminstration Edition
2. Discoverer Desktop Edition
Architecture Of Discoverer Administartion Edition:-
i.End User Layer
ii.Business Area
iii.Business Folders
Overview of Business Areas:-
-A business area is a collection of related information in the database.
-A business area is a set of related information with a common business purpose
-For example, information about Sales may be stored in one business area, while
information about Cops is stored in another business area.
-In simple words it can be termed as collections of objects in a particular module
Overview of Business Folders:-
-Simple Folders – Folders that are based on a database table (e.g.: ITEM)
-Custom Folders – Folders that contain a custom SQL query.
-Complex Folders – Folders that are based on multiple simple folders.
Here are the steps for creating the ‘Business area’
Open Discoverer Administrative Edition
Logon to Discoverer Administrative Edition using SYSADMIN user
Click Connect
Choose a Responsibility and Click OK
Click Create a New Business Area and Click Next
Select Any User and Click Next
Expand the Node and Select Any Table or View And Click Next
Click Next
Name the Business Area and Description Appropriately And Click Finish
The Business Area Will be created and you would view the following screen
Close the Administrative Tasklist Window
Expand the Business Area
Delete The Folder under the Business Area
Click Yes
Now the business Area is Empty
Logon to SQL Plus and Create a View according to the requirement
Relogon to Discoverer Administration Edition to have the Schema Refreshed And Open the Business Area Created Earlier.
Right Click on the Business Area Created and Select the New Folder from Database Option
Click Next
Select the Schema APPS and Click Next as shown below
Expand the APPS Schema
Select the View Created at SQL Plus and Click Next
Click Finish
The Folder is Created
Expand the Business Area and you can view the Folder
Click Tools à Security Menu
Assign the Users/Responsibilities who can access the Business Area and Click OK
Here are the screen shots for creating the workbooks in the Discoverer Desktop:-
Logon to the Discoverer Desktop Edition to create Work Books
Login as SYSADMIN User
Select System Administrator Responsibility and Click Ok
Select Create a new workbook option
Select one of the Display Style as per the requirement and Click Next
Select the Business Area and the folder on which you would like to create the Workbook and Click Next
Check Show Page Items and Click Next
You could add the condition required by clicking New.
Select New Parameter Option from the List
You will get the following screen
Enter the Name, Prompt, Description and other Fields and Click OK
Click Ok
Click Next
You can create the Sort Condition so that the Workbook would sort the data accordingly.
Click Add
Select the Field on which you would like to sort the data and Click ok
Add as many sorts you need
Click Finish
You workbook is Created.
Go to File Manage wok books Properties
Give the Identifier and Description
Click OK
Click Yes
Go to Sheet Rename Sheet Menu
Give an Appropriate Name and Click OK
Click Save
Select Database
Give an appropriate name and Click Save
Go to File Manage work books sharing menu
Select the Workbook and assign it to the responsibility who can access the workbooks as shown in the screen
Click OK..
Whats is Discoverer Server ?
Discoverer is and adhoc query, reporting, analysis and publishing tool which help business users to get quick access to information from datawarehouse or OLTP systems. In Apps, Discoverer version 4i used to be installed & configured out of the box which is desupported now. You should configure Apps with Discoverer 10g (I am going to cover about how to configure discoverer 10g with E-Business Suite)
What should I know about Discoverer as an Apps DBA ?
Though each component in Apps like forms, reports, web server including Discoverer in itself are quite big and more you know about them better it is for you . Few Important things you should know about Discoverer in Apps is like how to start/stop & how to access it. In case of any issues you should be able to troubleshoot discoverer.
What is EUL ?
You will hear lot about EUL from business analyst which means End User Layer, which is the key to provide ease of use to underlying data in Oracle Apps Database.
Technical things about discoverer in Apps ..
–In Apps default discoverer version 4i, is installed under $ORACLE_HOME/discwb4
–Script to start discoverer server is addisctl.sh under $OAD_TOP/admin/scripts/$CONTEXT_NAME
– This script in turn start discoverer processes which can be start by startall.sh under $ORACLE_HOME/discwb4/util (This script is different from adstrtal.sh)
– startall.sh calls scripts like startgatekeeper.sh, startlocator.sh , startoad.sh, startosagent.sh to start gatekeeper, locator, oad & osagent resp.
– In Apps two major way to access EUL is via Discoverer view & Discoverer Plus edition (You can use Discoverer Administration Edition as well)
A. How will you find discoverer version in Apps ?
B. What URL you use to access Disco viewer & Disco plus .
Plus–http://hostname.domain:port/discwb4/html/english/welcome.htm
Viewer–
http://hostname.domain/discoverer4i/viewer
Note-
The location for looking for dis4pr is
$ORACLE_HOME/diswb4/bin
where ORACLE_HOME -> 8.0.6. Oracle Home
DISCOVERER
Oracle Discoverer is a business intelligence tool to support organizational decisions and data will show in the form of excel format.
Components of discoverer:-
1.Discoverer Adminstration Edition
2. Discoverer Desktop Edition
Architecture Of Discoverer Administartion Edition:-
i.End User Layer
ii.Business Area
iii.Business Folders
Overview of Business Areas:-
-A business area is a collection of related information in the database.
-A business area is a set of related information with a common business purpose
-For example, information about Sales may be stored in one business area, while
information about Cops is stored in another business area.
-In simple words it can be termed as collections of objects in a particular module
Overview of Business Folders:-
-Simple Folders – Folders that are based on a database table (e.g.: ITEM)
-Custom Folders – Folders that contain a custom SQL query.
-Complex Folders – Folders that are based on multiple simple folders.
Here are the steps for creating the ‘Business area’
Open Discoverer Administrative Edition
Logon to Discoverer Administrative Edition using SYSADMIN user
Click Connect
Choose a Responsibility and Click OK
Click Create a New Business Area and Click Next
Select Any User and Click Next
Expand the Node and Select Any Table or View And Click Next
Click Next
Name the Business Area and Description Appropriately And Click Finish
The Business Area Will be created and you would view the following screen
Close the Administrative Tasklist Window
Expand the Business Area
Delete The Folder under the Business Area
Click Yes
Now the business Area is Empty
Logon to SQL Plus and Create a View according to the requirement
Relogon to Discoverer Administration Edition to have the Schema Refreshed And Open the Business Area Created Earlier.
Right Click on the Business Area Created and Select the New Folder from Database Option
Click Next
Select the Schema APPS and Click Next as shown below
Expand the APPS Schema
Select the View Created at SQL Plus and Click Next
Click Finish
The Folder is Created
Expand the Business Area and you can view the Folder
Click Tools à Security Menu
Assign the Users/Responsibilities who can access the Business Area and Click OK
Here are the screen shots for creating the workbooks in the Discoverer Desktop:-
Logon to the Discoverer Desktop Edition to create Work Books
Login as SYSADMIN User
Select System Administrator Responsibility and Click Ok
Select Create a new workbook option
Select one of the Display Style as per the requirement and Click Next
Select the Business Area and the folder on which you would like to create the Workbook and Click Next
Check Show Page Items and Click Next
You could add the condition required by clicking New.
Select New Parameter Option from the List
You will get the following screen
Enter the Name, Prompt, Description and other Fields and Click OK
Click Ok
Click Next
You can create the Sort Condition so that the Workbook would sort the data accordingly.
Click Add
Select the Field on which you would like to sort the data and Click ok
Add as many sorts you need
Click Finish
You workbook is Created.
Go to File Manage wok books Properties
Give the Identifier and Description
Click OK
Click Yes
Go to Sheet Rename Sheet Menu
Give an Appropriate Name and Click OK
Click Save
Select Database
Give an appropriate name and Click Save
Go to File Manage work books sharing menu
Select the Workbook and assign it to the responsibility who can access the workbooks as shown in the screen
Click OK..
No comments:
Post a Comment