13 October, 2020
Before starting this tutorial, you should:
Note: This tutorial is built using Oracle Business Intelligence Enterprise Edition 220.127.116.11. Due to product enhancements in 18.104.22.168, if you use an earlier version of the product to complete this tutorial, you will notice some differences in functionality:
New Diagramming Capability: The Physical and Business Model Diagrams have enhanced capabilities in the 22.214.171.124 release, including an improved look-and-feel, the ability to display columns in table objects in the diagram, and new diagram options like auto-layout, marquee zoom, and zoom to fit. Additionally, joins in the Physical and Business Model Diagrams are now represented by a line with an arrow at the "one" end of the join, rather than the line with crow’s feet at the "many" end of the join that was used in previous releases. When creating joins in the Physical and Business Model Diagrams, you now select the "many" end of the join first and then select the "one" end of the join. In previous releases, joins in the diagrams were created by selecting the "one" end of the join first.
When setting up query logging, you must select Action > Set Online User Filter in Identity Manager to view users in the repository.
To complete this tutorial you must have access to the BISAMPLE schema that is included with the Sample Application for Oracle Business Intelligence Suite Enterprise Edition Plus. There are three options for accessing the BISAMPLE schema:
STEPS TO IMPORT SAMPLE SCHEMA INTO ORACLE DATABASE
1) COPY BISAMPLEDATA_LOAD file toTO C:data
Example folder: c:data
Step1) connect to sys or system user
go to command prompt(start==>run==>type cmd)
Step1b) connect to oracle using following command sqplus username@databasename/pwd
step2) at the command prompt execute following command
step 3b) after successful completion of above command execute below command
STEP4) Open another command prompt and connect to database using following
at the second SQL connection execute following command
For an in-depth understanding of OBIEE click on
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .