OBIEE Notes Deck Flashcards
OBIEE 10g Certification
describe saved selections options in dashboards
Ans: we need to pick 3 options and the one which we need to eliminate out of 4 is the one with excel import option
Oracle recommended OBI implementation practice?
iterative approach
In which oracle BI configuration file is the web catalog specified?
- The name of the web catalog is specified in the instanceconfig file on the web server. It is found at BI Data/ web/Config folder. You also set sessin expiration parameters in this file. The settings in this file must align with nqsconfig.ini.
what are the oracle stages of a project
There are six Implementation Project Stages.
1. Define Stage
2. Discover Stage
3. Design Stage
4. Configure Stage
5. Validate Stage
6. Deploy Stage
During the Discover Stage, the project team concentrates on refining and documenting the
functional and technical requirements that are needed to support the business goals.
what are common Oracle recommendations on performance improvements?
- using caching
- dash boards design should have less data to return
what are iBots?
Delivers makes use of intelligence agents or Bots (called iBots). iBots are software-based agents
driven by schedule or events that access, filter, and perform analytics on data based upon defined
criteria. Users receive information from iBots in the form of alerts that appear on their designated
delivery devices or dashboards.
To create an iBot, Oracle Business Intelligence administrators and users use Delivers to define the
actions the iBot is to perform. Oracle BI Presentation Services gathers information about the priority,
delivery devices, user, and other characteristics; packages that information into a job; and tells
Oracle BI Scheduler when it wants the job to execute.
The active BI Scheduler instance processes jobs and executes iBot requests.
Communication occurs between BI Presentation Services and BI Scheduler for BI Delivers. When a
web user submits an iBot request, BI Presentation Services establishes communication with BI
Scheduler. BI Presentation Services uses the username and password stored in its credential store
under the alias of “admin” to connect to BI Scheduler. This username and password must match the
BI Scheduler Administrator credential for successful authentication to occur.
connection pooling
one connection pool for each physical layer
The Oracle BI Server can authenticate users through database logons. When a user attempts to log
on to Oracle BI Presentation Services, the Oracle BI Server attempts to use the logon name and
password to connect to the authentication database, using the first connection pool associated with
it. If this connection succeeds, the user is considered to be authenticated successfully.
star schema?
normalization of dimention tables
why do we use aliases on physical layer
in order to avoid circular joins
question of expression builder utility
we need to select 3 options….I remember I selected the last 3 options.
describe the cache manager
Must open rpd in online mode to clear cache, make changes to apply directly Can set max number of rows in cache manager. Polling is managed separately and done at physical layer. Table obieecache contains table names to be refreshed at given interval
catalog manager - what are not recommended?
- giving access to every user
- modifying web catolog in on line mode
What are key terms in Partitioning?
Look for Fact Based and Value Based
what is the difference between and use of session variables and repository variables
/ System variables (e.g. user, group)
Session
\ Non-system variables
/ Dynamic (e.g. yesterday)
Repository
\ Static -- only one of these four NOT refreshed with initialization block
~(e.g. select system -1 for yesterday...)
what are scatter charts
?
question on many to many relation
bridge table - used to smoothly join via I’d relationships between two tables. joins two facts typically. Example from Yves: Passenger bridge to segment
What is a cache hit?
Doesn’t hit the database just shows result from cache
Type 1,2 and 3 slowly changing dimensions
Type 1 overwrites Type 2 tracks history (most common) Type 3 has columns with previous and new values
Setting up aggregate tables = what looks like and when you’d use it
Seema explained the use with various levels on tables. Eg by month
Configuring in the physical layer, bmm or presentation layer
Define CARDINALITY in the physical layer ONLY
What is BI publisher?
Oracle Business Intelligence Publisher is Oracle’s application for creating highly formatted reports. The Oracle BI Publisher environment consists of the Oracle BI Publisher Enterprise server and Oracle BI Publisher Add-ins to Word, Excel, and Acrobat Professional.
Publishing web catalog, web catalog manager tool
You can use Oracle Business Intelligence Catalog Manager to manage the Presentation Catalog.
Oracle Business Intelligence can copy and merge contents of selected Presentation Catalog folders
between instances of Oracle BI Presentation Services. The replication configuration can be split into
individual tasks. The replication task is an instruction to periodically merge catalog contents for
specified catalog folders from one server to another. Two-way replications are possible.
A typical scenario where replication is useful is when you use one instance of Oracle BI Presentation
Services to prepare and publish shared reports, and use two or more production instances to support
the users. In this scenario you share the catalog from Instance 1 to two production instances and
then share the catalogs on each production instance with the other. To accomplish this, you set up
the following replication tasks in the Oracle BI Presentation Services Replication Agent’s (sawrepaj)
configuration file:
■ /shared: Instance1 to Instance2
■ /shared: Instance1 to Instance3
■ /users: Instance2 to Instance3
■ /users: Instance3 to Instance2
When an instance of Oracle BI Presentation Services participates in replication, either as a publisher
or subscriber, it tracks changes made to catalog items that are marked to be replicated and keeps
them internally in replication log files. Another instance of Oracle BI Presentation Services can make
a SOAP call to request to export those changes to a file or to import and replay modifications
recorded in a file exported earlier from another instance. The Oracle BI Presentation Services
Replication Agent uses SOAP to manage replication related activities on all instances of Oracle BI
Presentation Services and performs import and export operations. For information on the SOAP calls
used, read Oracle Business Intelligence Web Services Guide.
Dynamic vs static system and non-system variables. Session variables.
/ System variables (e.g. user, group)
Session
\ Non-system variables
/ Dynamic (e.g. yesterday)
Repository
\ Static -- only one of these four NOT refreshed with initialization block
~(e.g. select system -1 for yesterday...)
Level based measures
?
passphraseFile="OracleBI_HOME\ssl\serverpwd.txt"
path="OracleBI_HOME\ssl\server-key.pem"/>
