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

NQSConfig.ini is the main configuration file of Bi Server and contains a lot of parameters.

The parameters in the Query Result Cache Section provide configuration information for Oracle BI Server caching. The query cache is enabled by default. After deciding on a strategy for flushing outdated entries, you should configure the cache storage parameters in Fusion Middleware Control and in the NQSConfig.INI file.

Aggregate Persistence Wizard automates the creation and initial population of aggregates, persists them in a back-end database and configures the BI Server metadata layer so that they’re used when appropriate.

Note: The Administration tool is used to manage OBIEE server and have some capabilities to automate some repetitive tasks and principally his embedded tools.

Oracle Business Intelligence Administration Tool is available only for Windows operating systems.

The Administration Tool is a Windows application that allows the BI Server administrator to create and edit repositories.

Repositories can be edited with the administration tool in either online or offline mode.

The Administration Tool also includes a session manager and a cache manager which are available in online mode. The Cache Manager displays what queries have been cached and how frequently they have been accessed. You can also select and delete items

Creating Logical Time Dimensions

Compared to modeling an ordinary dimension, the time dimension requires just two additional steps: selecting the Time option in the Logical Dimension dialog, and designating a chronological key for every level of every dimension hierarchy.

Note: Time dimensions and chronological keys. You can identify a dimension as a time dimension. At least one level of a time dimension must have a chronological key. The following is a list of some guidelines you should use when setting up and using time dimensions:

* At least one level of a time dimension must have a chronological key.

* All time series measures using the AGO, TODATE, and PERIODROLLING functions must be on time levels. AGO, TODATE, and PERIODROLLING aggregates are created as derived logical columns.

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:

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

B: The problem with caching of any kind is how to deal with stale data. How you decide to deal with this depends on how time critical your business intelligence queries happen to be. OBIEE provides a wide variety of mechanisms for dealing with stale data. The cache can be purged automatically at intervals. Caching can be enabled selectively for individual physical tables, so that data in a frequently updated table is never cached. OBIEE provides a set of ODBC procedures that can be called when ETL processes complete to programmatically purge designated tables. But, by far the best way to selectively purge the cache is to use an event polling table. This table is populated by the client database whenever changes are made to any table (by an ETL process for a data warehouse or by a table-based trigger for an OLTP database). At specified intervals the BI Server polls this event polling table and deletes from its cache any query results that are dependent on the changed data.

Pull the table and column definition into the physical layer

Use the OBIEE “import metadata” wizard to pull the table and column definition into

the physical layer. The wizard is used so that all of the column definitions do not need to

be manually added into the physical layer.

Figure:

Note: The physical layer is the layer of the Logical Business Model where you define the physical data model of your data source. It contains information about the physical data sources.

You have three sort of fragmentation:

Fact-based / Dimension-based fragmentation

Content-based / Value-based fragmentation

Level-based fragmentation / aggregate navigation

You can combine the techniques above to construct powerful design that are known as Complex partitioning / fragmentation. When you fragment a dimension, you are automatically in a complex fragmentation.

All others are names for level-based measure but Sales is a base measure.

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.

Users in Oracle BI Answers can create queries that span multiple subject areas, as long as the subject areas correspond to the same business model.