Pass the Oracle Other Certification 1z0-591 Questions and answers with ExamsMirror

In online mode, you connect to a catalog on a running web server. In this mode your permissions are applied, you can select a locale, and you can see the effects of any localization on the catalog. You can see only those objects for which you have the appropriate permissions. Both Presentation Services and the web server must be running for you to open catalogs in online mode.

Use online mode when you want to make minor incremental changes or additions to the catalog, such as changes to permissions, updates to a single object, or migration of new objects to a production environment.

Note:

* You can open a catalog in one of two modes — online or offline. Both modes can operate against an actual production catalog, with no need for any downtime.

* Repository changes can be done in either online

or offline mode. Online mode is when BI Server

is actively reading the repository file (when a

user is logged in). Offline is when BI Server is

idle. Best practice is to develop in Offline mode.

Minor changes can be made when in online

mode.

Initialization blocks are used to initialize dynamic repository variables, system session variables, and nonsystem session variables.

After creating your base metrics, try using the Calculation Wizard to automate the process of creating time-series metrics or comparison metrics such as: Change, Percent Change, Index, and Percent. The Wizard may save you many hours of time and frustration, especially if you have to create more than a handful of these metrics. In addition, the Wizard allows you to include customized logic to handle nulls in the base metrics. You may refer to the Oracle documentation for further detail.

A data warehouse is a database used for reporting and data analysis. It is a central repository of data which is created by integrating data from multiple disparate sources. Data warehouses store current as well as historical data and are commonly used for creating trending reports for senior management reporting such as annual and quarterly comparisons.

The “Edit Column Formula” dialog box has a second,

very tiny tab called, “Bins.” You can use this tab to have OBIEE

build a CASE statement for you in a formula (you can also create

a CASE statement yourself by using one of the functions that

appears under “Expressions” if you want). A CASE statement is a

lot like an IF-THEN-ELSE statement, except that it’s a little easier

to read when you have multiple options. Basically, it puts values

in different buckets that you define.

Note:

Figure:

Identity Store: It is directory server to perform the authentication. It contains user name , password and groups membership information .When a user name and password combination is entered at log in, the authentication provider searches the identity store to verify the credentials provided.

See figure below.

All metadata for cubes and dimensions is stored in the Oracle database and revealed in the data dictionary views, so that you can query the entire business model in SQL.

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.

A: Much of the configuration of OBI that used to be done in the NQSConfig.ini files can now be done using this front end console, which in turns updates the NQSConfig.ini file. Things in the NQSConfig.ini file that are set by EM are noted in the file with '# This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager'. Some things that needs to be setup manually in the NQSConfig.ini file are:

1. Usage Tracking

2. Dynamic Libraries

3. Query Optimization Flags

4. MDX Member Name Cache Section (SAP BW)

5. More specific General Settings where EM doesn't contain the level of detail required

D: Cache Management Techniques include

• Inspecting the cache reports

• Configuring the cache parameters

• Setting caching and cache persistence for tables

• Using the Cache Manager

• Inspecting SQL for cache entries

• Modifying the Cache Manager column display

• Purging the cache entries manually using the Cache Manager

• Purging the cache entries automatically

• Using event polling tables

• Seeding the cache

CurrentMonth can be calculated by a sql statement.

Note:

REPOSITORY VARIABLE(DYNAMIC)

· Initialized when BI server is started

· Assigned value dynamically based on the result of a query

· Value is dependent of the sql provided in Initialization Block

Create a dynamic variable and provide a Name and Default Initializer.Create a new initialization block by clicking on the New button in the above screen.

Provide Intialization Block variable Name

Click on “Edit Data Source” button and provide the sql to be used for the variable, e.g.

select lower(sys_context('USERENV','SESSION_USER'))||

'@'||

lower(sys_context('USERENV','DB_NAME'))

from dual;