Download - 26BR Utilities
-
8/22/2019 26BR Utilities
1/13
Copyright 2010, Oracle and/or its affiliates. All rights reserved.
Using Administration Tool Utilities
-
8/22/2019 26BR Utilities
2/13
Copyright 2010, Oracle and/or its affiliates. All rights reserved.26 - 2
Objectives
After completing this lesson, you should be able to: Describe the various wizards and utilities in the Oracle BI
Administration Tool
Use the Administration Tool wizards and utilities to
manage, maintain, and enhance repositories
-
8/22/2019 26BR Utilities
3/13
Copyright 2010, Oracle and/or its affiliates. All rights reserved.26 - 3
Wizards and Utilities
This lesson describes the following utilities and wizards: Session Manager
Query Repository
Replace Columns and Tables
Repository Documentation
Generate Metadata Dictionary
Oracle BI Event Tables
Update Physical Layer
Remove Unused Physical Objects
-
8/22/2019 26BR Utilities
4/13
Copyright 2010, Oracle and/or its affiliates. All rights reserved.26 - 4
Accessing Wizards and Utilities
Select Manage > Sessions to access the SessionsManager.
Select Tools > Query Repository to access the Query
Repository utility.
Select Tools > Utilities to access remaining utilities.
-
8/22/2019 26BR Utilities
5/13
Copyright 2010, Oracle and/or its affiliates. All rights reserved.26 - 5
Managing Sessions
Use the Session Manager to monitor session activity in onlinemode.
Sessions
Requests
-
8/22/2019 26BR Utilities
6/13
Copyright 2010, Oracle and/or its affiliates. All rights reserved.26 - 6
Querying Repository Metadata
Use the Query Repository tool to query for objects in therepository.
Object type
Filter
Results
-
8/22/2019 26BR Utilities
7/13Copyright 2010, Oracle and/or its affiliates. All rights reserved.26 - 7
Replacing Columns or Tables
Use the Replace Column or Table utility to automate theprocess of replacing physical columns and tables in logical
table sources.
-
8/22/2019 26BR Utilities
8/13Copyright 2010, Oracle and/or its affiliates. All rights reserved.26 - 8
Documenting a Repository
Use the Repository Documentation utility to documentmappings from presentation columns to the corresponding
logical and physical columns.
Save in comma-separated, tab-delimited, or XML formats.
-
8/22/2019 26BR Utilities
9/13Copyright 2010, Oracle and/or its affiliates. All rights reserved.26 - 9
Generating a Metadata Dictionary
Use the Generate Metadata Dictionary utility to create a set ofstatic XML documents that describe each metadata object,
including its properties and its relationships with other metadata
objects.
Metadata object
Location
Description
Relationship with other objects
-
8/22/2019 26BR Utilities
10/13Copyright 2010, Oracle and/or its affiliates. All rights reserved.26 - 10
Creating an Event Table
Use the Oracle BI Event Tables utility to identify a table as anOracle BI event polling table.
-
8/22/2019 26BR Utilities
11/13Copyright 2010, Oracle and/or its affiliates. All rights reserved.26 - 11
Updating the Physical Layer
Use the Update Physical Layer Wizard to update databaseobjects in the Physical layer of a repository based on their
current definitions in the back-end database.
-
8/22/2019 26BR Utilities
12/13Copyright 2010, Oracle and/or its affiliates. All rights reserved.26 - 12
Removing Unused Physical Objects
Use the Remove Unused Physical Objects utility to removeobjects that are no longer needed in a repository.
-
8/22/2019 26BR Utilities
13/13Copyright 2010 Oracle and/or its affiliates All rights reserved26 13
Summary
In this lesson, you should have learned how to: Describe the various wizards and utilities contained in the
Oracle BI Administration Tool
Use the Administration Tool wizards and utilities to
manage, maintain, and enhance repositories