• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Developing Repository in OBIEE

Prerequisites:

Before starting this tutorial, you should:

  1. Have access to or have Installed Oracle Business Intelligence Enterprise Edition 11g.

note: This tutorial is built using Oracle Business Intelligence Enterprise Edition 11.1.1.5. Due to product enhancements in 11.1.1.5, 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 11.1.1.5 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.

  1. 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:
  1. If you already have installed version 825 or V107 of the Sample Application, verify that you have access to the BISAMPLE schema and begin the tutorial.
  1. If you are interested in downloading and installing the complete Sample Application, you can access it here on the Oracle Technical Network (OTN). Please note, however, that only the BISAMPLE schema is required to complete this tutorial. If you want to install only the BISAMPLE schema, proceed to option 3.
  1. Click here to access the ForOBE.7z file, which has the 825 version of the BISAMPLE schema and installation instructions. Save ForOBE.7z, unzip, and begin with README FIRST.txt.
Desired to gain proficiency on OBIEE 11g? 
Explore the blog post on OBIEE 11g training online to become a pro in OBIEE 11g 

STEPS TO IMPORT SAMPLE SCHEMA INTO ORACLE DATABASE

1) COPY BISAMPLEDATA_LOAD file toTO C:\data

Example folder: c:\data

c:\data

Step1) connect to sys or system user

example

step1a)

go to command prompt(start==>run==>type cmd)

Step1b) connect to oracle using following command sqplus username@databasename/pwd

example

sqlplus system@apple/apple123

step3) at the command prompt execute following command

3a)

sql>@C:\DATA\BISAMPLE_USER.sql

3b) after successful completion of above command execute below command

sql>@C:\DATA\BISAMPLE_SCHEMA_825.sql

STEP4) Open another command prompt and connect to database using following

sqlplus bisample@apple/bisample

at the second SQL connection execute following command

sql>@C:\DATA\BISAMPLE_DATA_825.sql

For indepth understanding of OBIEE click on

Summary
Review Date
Reviewed Item
Developing Repository in OBIEE
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Developing Repository in OBIEE"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.