Oracle® Fusion Middleware Administrator's Guide for Oracle Business Intelligence Discoverer 11g Release 1 (11.1.1) B32519-01 |
|
![]() Previous |
![]() Next |
This section explains how to install the Discoverer sample data EUL, data, and workbook so that you can use the sample data. This procedure also installs the Video Tutorial Workbook.
This section contains the following topics:
"What happens when you install the Discoverer sample data EUL, data, and workbook?"
"What privileges do you require to install the sample data?"
"What conditions apply when you connect to Discoverer Administrator for the first time?"
"What steps do I follow to install the Discoverer sample data EUL, data, and workbook?"
"How to grant access privileges to the VIDEO5 database user for the sample data EUL"
"How to install the tutorial business area in another End User Layer"
"How to uninstall the tutorial business area, tables and data"
Before Discoverer Administrator users can start using Discoverer using the sample data, the following must exist in the database:
an End User Layer (EUL)
the VIDEO5 database user
the VIDEO5 data
Note: When you use Discoverer Administrator for the first time, the VIDEO5 database user might not exist. If the VIDEO5 database user does not exist, you can create it when you install the sample data (for more information, see "How to install the Discoverer sample data").
When you install the Discoverer sample data EUL, data, and workbook Discoverer Administrator does the following:
creates a new database user with a name that you specify (this user will own the EUL)
creates a new EUL
if the VIDEO5 database user does not already exist, Discoverer:
creates a new database user called VIDEO5
creates sample data tables in the VIDEO5 database user's tablespace
populates the sample data tables with sample data
populates the new EUL with metadata about the VIDEO5 tables (that is, it imports the tutorial business area from the file vidstr.eex, located in the \demo directory)
The following figure illustrates events that can occur when you install the sample data.
Key to the above figure:
Connect to Discoverer Administrator as an existing database user with sufficient privileges to install the sample data (for more information, see "What privileges do you require to install the sample data?").
Create an EUL for a new database user.
If you choose to install the sample data in the EUL, Discoverer Administrator creates the VIDEO5 user (if not already created).
Discoverer Administrator creates the VIDEO5 user tables (for example, Product, Sales Fact, Store, Time) and populates them with data from the file demodata.sql (located in the \demo directory).
Discoverer Administrator populates the EUL for the new database user with metadata about the video stores tutorial business area from the file vidstr.eex.
The choices you can make when you install the sample data are illustrated in the figure below:
To install the sample data in the current EUL, the database user that you use to connect to Discoverer Administrator must have the following database privileges:
CREATE TABLE
CREATE VIEW
CREATE PROCEDURE
Tip: You can grant the above privileges to the database user by running the script <ORACLE_HOME>\discoverer\util\eulasm.sql.
if the VIDEO5 user has not already been created, you must have the following additional database privileges:
CREATE USER
GRANT ANY PRIVILEGE
ALTER USER
if you run against an Oracle Enterprise Edition database, you must also have the following additional database privileges to use the Discoverer summary management and ASM functionality:
CREATE ANY MATERIALIZED VIEW
DROP ANY MATERIALIZED VIEW
ALTER ANY MATERIALIZED VIEW
GLOBAL QUERY REWRITE
ANALYZE ANY
Tip: You can grant the above privileges to the database user by running the script <ORACLE_HOME>\discoverer\util\eulasm.sql.
SELECT ON V_$PARAMETER
For more information about how you grant the above database privileges, click Help.
When you connect to Discoverer Administrator for the first time the following conditions apply:
you must connect as a database user having specific privileges (for example, a DBA user to install the sample data)
For more information, see "What privileges do you require to install the sample data?".
no EULs or EUL metadata will exist in the database
the VIDEO5 database user and tables will not have been created
When the VIDEO5 database user does not exist, you must create it and populate the VIDEO5 tables with sample data before you can begin learning about Discoverer Administrator. For more information, see "What happens when you install the Discoverer sample data EUL, data, and workbook?".
You must create an EUL (if an EUL does not already exist) to enable you to:
install the Discoverer sample data
create the VIDEO5 user and populate the VIDEO5 tables with data
complete the Discoverer Administrator sample data
Installing the sample data into an EUL makes the sample data available to all users who have access privileges to that EUL.
To install the Discoverer sample data EUL, data and workbook, follow these steps:
Create a private EUL - see "How to create a private EUL for the sample data".
Install the Discoverer sample data into the private EUL that you have just created - see "How to install the Discoverer sample data".
Make sure that the VIDEO5 user has the necessary privileges to access the sample data EUL - see "How to grant access privileges to the VIDEO5 database user for the sample data EUL".
You must create an EUL if one does not already exist. To create the sample data EUL, you must connect to Discoverer as a database user with sufficient privileges (for more information, see "What privileges do you require to install the sample data?") and create an EUL for a new database user.
To create the sample data EUL:
Choose Programs | Oracle Business Intelligence Tools - <HOME_NAME> | Discoverer Administrator from the Windows Start menu to display the Connect dialog.
Enter a database username with sufficient privileges (for example, a DBA user).
For more information, see "What privileges do you require to install the sample data?".
Enter the password.
Passwords are case-sensitive in Oracle databases (Enterprise Edition release 11.1 or later).
In the Connect field:
If you are logging into your default database, leave this field blank.
With Oracle Enterprise Edition databases, an entry is required in your tnsnames.ora file for this to work (for more information, see your Discoverer manager).
If you are logging into an Oracle database that is not your default database, specify the appropriate TNS alias (for more information, see your database administrator).
Click Connect.
Discoverer Administrator behaves differently depending on whether an EUL has already been created for the database user you use to connect with.
If no EUL exists, Discoverer Administrator displays a message asking Do you want to create an EUL now?
Click Yes to display the EUL Manager dialog.
Tip: If one or more EULs already exist, Discoverer Administrator displays the Load Wizard. Click Cancel in the Load Wizard and choose Tools | EUL Manager to display the EUL Manager dialog.
Click Create an EUL to display the Create EUL Wizard dialog.
Use this wizard to create an EUL and a new database user. You must create the new EUL and database user before you can install the sample data into the VIDEO5 user.
Select the Create a new user option.
Clear the following check boxes:
Grant EUL access to PUBLIC check box
New EUL is for use by Oracle Applications users ONLY check box
Enter a name for the new database user in the User field.
You can use any name for the new database user. For example, you might enter 'TUTEUL' to identify a specific user.
Enter a password into both the Password and Confirm Password fields.
Tip: You could use same username that you entered in the previous step in both the Password and Confirm Password fields.
Passwords are case-sensitive in Oracle databases (Enterprise Edition release 11.1 or later).
Make sure that the Create EUL Wizard displays the settings for options and check boxes as shown below.
Click Next to display the Create EUL Wizard: Step 2 dialog.
Select the default and temporary tablespaces.
For example, select USR as the default tablespace and TEMP as the temporary tablespace.
Click Finish for Discoverer Administrator to build the EUL
Discoverer Administrator displays a progress bar.
After Discoverer Administrator creates the new EUL, Discoverer Administrator displays a message that the EUL has been created successfully.
Click OK.
You have just created the first EUL and you must now install the sample data.
Click Yes to display the Install Sample Data dialog.
Complete the steps in the following section "How to install the Discoverer sample data".
Having created a private EUL for the sample data, you can install the Discoverer sample data into the private EUL (for more information, see "How to create a private EUL for the sample data").
How you install the Discoverer sample data depends on when you decide to install the sample data:
to install the Discoverer sample data immediately after creating the sample data EUL, start at step 5 of the following procedure
to install the Discoverer sample data into an existing EUL, start at step 1 of the following procedure
Connect to Discoverer Administrator as the owner of the EUL that you want to contain the tutorial business area (for more information, see "How to start Discoverer Administrator").
Note: Make sure that the database user you connect with has sufficient privileges to install the sample data (for more information, see "What privileges do you require to install the sample data?")
Discoverer Administrator displays the Load Wizard.
Click Cancel to close the Load Wizard.
Choose Tools | EUL Manager to display the EUL Manager dialog.
Click Install the Sample Data to display the Install Sample Data Wizard: Step 1 dialog.
Note that the EUL displayed in the EUL field is the EUL into which Discoverer Administrator imports the tutorial business area.
Click Next to display the Install Sample Data Wizard: Step 2 dialog.
Type VIDEO5
in both the Password and Confirm Password fields.
Note: You will use the password VIDEO5
if you uninstall or reinstall the sample data.
Note: You may want to use a different password to the one given above.
Click Next to display the Install Sample Data Wizard: Step 3 dialog where you specify the default and temporary tablespaces for the VIDEO5 database user.
Note: If you are not creating VIDEO5 as a new database user, Discoverer Administrator does not display the Install Sample Data Wizard: Step 3 dialog.
Choose a default and temporary tablespace.
For example, select USR as the default tablespace and TMP as the temporary tablespace.
Click Finish, Discoverer Administrator displays the Commit Status dialog.
Discoverer Administrator populates the VIDEO5 database user tables with default data using the file demodata.sql (located in the \demo directory) and imports the video stores tutorial business area into the new EUL using the file vidstr.eex (located in the \demo directory).
When the process is complete, Discoverer Administrator displays a dialog indicating that the sample data has been successfully installed.
Click OK.
Discoverer displays the following dialog.
Click No to display the EUL Manager dialog.
Click Close to close the EUL Manager dialog.
You have just completed the following tasks:
created the VIDEO5 database user
populated the VIDEO5 tables with data
imported the tutorial business area into the new EUL
Discoverer Administrator is now correctly configured so that users can start to learn about using the sample data in Discoverer.
Now that you have created a private EUL and installed the Discoverer sample data, you must make sure that the VIDEO5 database user has access to the sample data EUL. Discoverer end users connecting to Discoverer as the VIDEO5 database user can then access the sample data, EUL, and workbook.
To make sure that the VIDEO5 database user has access to the sample data EUL:
Connect to Discoverer Administrator as the owner of the private sample data EUL that you created in "How to create a private EUL for the sample data" (TUTEUL).
Choose Tools | Security to display the Security dialog.
Discoverer Administrator displays the following warning dialog.
Click Yes to display the "Security dialog: Business Area - > User tab".
You must make sure that the VIDEO5 database user is displayed in the Selected users/roles list.
If the VIDEO5 database user is not displayed in the Selected users/roles list, move the VIDEO5 user from the Available users/roles list to the Selected users/roles list.
Click OK to save the details and close the Security dialog.
Choose Tools | Privileges and display the "Privileges dialog: Privileges tab".
Click Select to display the "Select User/Role dialog" where you can search for and select the user or role whose task privileges you want to change.
Click Go.
Discoverer Administrator displays the search results in the Results list.
Select the VIDEO5 user from the Results list.
Click OK to display the "Privileges dialog: Privileges tab" for the VIDEO5 user.
You must make sure that the VIDEO5 user has Desktop and Plus privileges, but not Administration privileges.
Clear the Administration Privilege check box, and select the Desktop and Plus Privilege check box.
Clear the Schedule Workbooks check box in the Desktop and Plus privileges list.
Click OK to save the details and close the Privileges dialog.
The VIDEO5 database user now has the required privileges for accessing the sample data EUL, data and workbook.
Having installed the tutorial business area into one EUL, you can install it in other EULs (for more information, see "How to install the Discoverer sample data").
If you want users to have access to the tutorial business area but not to the EUL in which you originally installed the sample data, you can install the sample data in one (or more) alternative EULs to enable each EUL owner to have their own tutorial business area. Each time you install the sample data in a different EUL, another tutorial business area is created in that EUL. Note that every tutorial business area accesses data from the same set of tables in the database. Only one version of each table is created in the database (that is, in the VIDEO5 database user's tablespace).
To install the tutorial business area in another EUL:
Connect to Discoverer Administrator as the database user that owns the EUL in which you want to install the sample data (for more information, see "How to start Discoverer Administrator").
Note: Make sure that the database user you connect with has sufficient privileges to install the sample data (for more information, see "What privileges do you require to install the sample data?")
Discoverer Administrator displays the Load Wizard.
Click Cancel to close the Load Wizard.
Choose Tools | EUL Manager to display the EUL Manager dialog.
Click Install the Sample Data to display the Install Sample Data Wizard: Step 1 dialog.
Note that the EUL displayed in the EUL field is the EUL into which Discoverer Administrator imports the tutorial business area.
Click Next to display the Install Sample Data Wizard: Step 2 dialog.
Type VIDEO5
in the Password field.
Note: The password can be whatever you have specified for the VIDEO5
database user.
Click Finish.
Discoverer Administrator displays the Commit Status dialog.
Discoverer Administrator imports the video stores tutorial business area into the EUL using the file vidstr.eex (located in the \demo directory).
When the process is complete Discoverer Administrator displays a dialog indicating that the sample data has been successfully installed.
Click OK.
Discoverer displays the EUL Manager dialog.
Click Close to close the EUL Manager dialog.
Discoverer Administrator has created a copy of the tutorial business area in the current EUL. You can create multiple copies of the tutorial business area in an EUL by repeating the previous steps.
Note: All copies of the tutorial business area access data in the same set of tables in the database.
When you uninstall the sample data, you remove:
the tutorial business area from the current EUL
(optional) the sample data tables from the database
Note the following:
the VIDEO5 user is not removed from the database
if the sample data was installed in other EULs, the tutorial business areas are not removed from the other EULs (even though the tables that those business areas point to have been optionally dropped from the database)
removing copies of the sample data from multiple EULs must be done one at a time
To uninstall the sample data:
Connect to Discoverer Administrator as the database user that owns the EUL from which you want to remove the tutorial business area.
Discoverer Administrator displays the Load Wizard.
Click Cancel to close the Load Wizard.
Choose Tools | EUL Manager to display the EUL Manager dialog.
Click Uninstall the sample data to display the Uninstall Sample Data Wizard: Step 1 dialog.
Make sure that the EUL named in the EUL field is the EUL from which you want to remove the tutorial business area.
If the EUL name is not correct, click Cancel and re-connect to Discoverer Administrator as the owner of the EUL from which you want to remove the tutorial business area.
Click Next to display the Uninstall Sample Data Wizard: Step 2.
Type VIDEO5
in the Password field for the VIDEO5 database user.
Or this can be whatever password you specified when you installed the sample data for the first time (that is, when you created the VIDEO5 database user).
Click Finish.
Discoverer Administrator warns you that uninstalling the sample data removes the sample data and tables from the database, and the tutorial business area from the current EUL.
Click Yes to delete the tutorial business area and database tables.
If you have previously uninstalled the sample data and you want to reinstall it, follow the steps in "How to install the tutorial business area in another End User Layer".