Oracle 1z0-591 - Oracle Business Intelligence Foundation Suite 11g Essentials

The Oracle Business Intelligence (BI) Administration Tool can be used to build, modify, enhance, and manage an Oracle BI repository.

C: To add a new user to a repository

1 Open a repository in the Administration Tool.

2 Display the security manager by selecting Manage > Security.

3 Select Action > New > User to open the User dialog box.

4 Type a name and password for the user.

5 If you want to log queries for this user in the query log, change the query logging level to 1 or 2.

6 Click OK.

This creates a new user with default rights granted to it.

Note: What is Oracle BI Admin Tool/Oracle Business Intelligence Administration Tool?

Oracle Business Intelligence Administration Tool is Used to manage OBIEE server

Available only for Windows operating systems.

A Windows application that allows the BI Server administrator to create & edit repositories.

Can edit repositories in either online or offline mode.

Having a session manager and a cache manager in online mode.

Steps for Creating Aggregate Tables in OBIEE

1. Create all Dimension Tables, Fact Tables & Hierarchies, which are required to be aggregated.

2. Go to ToolsàUtilities (from Administration tool menu bar), a dialog box will pop up with all available utilities.

3. Select Aggregate Persistence Wizard, and then click Execute Button.

4. Now Select appropriate path where you need to generate Aggregate Table SQL.

Note : Click Generate DDL file for first time generation of Aggregate Table

Click Next, to move to next page (Select Business Model & Measure Page)

In Select Business Model & Measure Page, Select Appropriate Business Model & then select associated Fact / Measure.

Etc.

Oracle Essbase developers creating planning and budgeting applications have been keenly aware of the advantages and disadvantages of the two different storage types available to them:

* Block storage option (BSO) databases support a wide range of calculations, including forecasts, allocations, and aggregations through procedural calculation scripts. The results of these calculations can be written back to the database, but applications that use BSO storage are limited to about 10 dimensions and member counts in the low hundreds of thousands.

* Aggregate storage option (ASO) databases can support about 20 dimensions and member counts in the millions. ASO databases use multidimensional functions rather than procedural scripts to perform calculations, but the results of queries cannot be stored back in the database, making ASO unsuitable for most financial management applications.

C: OBIEE Caching and Cache Seeding

Cache is a component that improves performance by transparently storing data such that future requests for the same criteria can be served much faster. Like other application cache is not virtual memory in OBIEE. In OBIEE cache will be stored as files on the Hard Disk of the OBIEE Server in the form of files. By Default caching is enabled in the OBIEE server configuration.

For time-consuming Dashboard Pages, we can use the concept of cache seeding in OBIEE, this can be configured as a scheduled job that will ensure that the data is cached and readily available as and when the user runs the dashboard.

The value of a static repository value is initialized in the Variable dialog box. This value persists, and does not change until an Oracle BI Administrator decides to change it.