|Ease of use||Needs trained developers||Empowers end users|
|Enterprise Reporting||Easy to deploy and manage||Much harder|
OBIEE Comprises Presentation Services,Oracle BI Server : The user constructs sql and passes it to the Analytic Engine and then the Oracle BI (Analytic Engine) describes the physical sql to the Data sources and recover the data back to the Engine and presents to the presentation Services .
Find out more about OBIEE in this detailed OBIEE tutorial!
There are many ways to extract the sql :
Learn Obiee in 10 hrs. Download e-book now
Click on modify and then click on sort (order by icon) on the relevant column in the criteria pane.
By clicking modify request and Narrative View and by giving @1 for the first column result and @2 for the 2nd column and so on and we can also give a heading for No Results by clicking the Narrative view.
By clicking on Administration and Manage dashboards and by adding column selector we can create interactive Dashboard.
We can give a column as updatable and then view the reports,this option is called write back option.
By clicking Direct Database Request below the subject area in we can execute Direct SQL in OBIEE.
From the Criteria Pane of the Report Created from First Subject Area
come to the bottom of the page and click combine request. By this we can create report from two subject areas.
Download Obiee Interview questions asked by top MNCs in 2017 ?
For the RPD we can use the Merge option in Admin Tool and for dashboards and reports we can use Content Accelerator Framework.
There are two types of variables in OBIEE 11g.
Looking to master Oracle Business Intelligence Enterprise Edition, go through this OBIEE training
In the NQSConfig.ini file use ENABLE under CACHE Section for System Level
For tables, if we want to enable the cache at table level , open the repository in offline mode This should be different from the current repository and click enable or disable the cache .
Check if the table is already existing if so add in physical layer ,then click on BMM and then Presentation layer, then reload server metadata ,then it will be visible to all users.
Using session variables for that user.
Table alias is used for creating self joins. Table alias can be created by right clicking the table in the physical layer then click alias.
Yes, we can create hierarchy in BMM Layer of OBIEE in dimensions for the dimension tables. This can be done by right clicking the dimension table and click create dimension and then we can manually define the hierarchy and its levels.
Level-base metrics means, having a measure held at a certain level of the dimension. Examples Monthly Total Sales or Quarterly Sales
To create a level based measure, create a new logical column based on the original measure. Drag and drop the new logical column to the appropriate level in the Dimension hierarchy.
Learn more in this insightful OBIEE video now.
Authentication is the procedure by which a system confirms, through the use of a user
If we want to connect two tables where there is no relationship we can use a third bridge table for connecting them which will have same columns in both tables.
Using Scheduler – ibots we can generate time based triggered report.
Ibot is an arrangement agent, used to arrange reports to be sent across many devices such as email, pager, mobile, other devices etc.
Using confirmed dimensions,we can fetch many metrics across various facts, but the join should be of same level of data detail.
Shared Folders – XYZ Folder – It have two folders
By clicking on the cancel button, we can stop a exact report placed on the dashboard.
A surrogate key is an artificially generated key, usually a number. A surrogate key, in the level aggregate table, simplifies this join and removes unnecessary columns from the fact table, resulting in a smaller-sized fact table.
Siebel Analytics life cycle
There are five parts of Siebel Architecture.
Metadata represents the analytical Model which is created using the siebel Analytics Administration tool.
Repository divided into three layer
In the BMM layer,we can create one logical table (fact) and add the 3 fact table as logical table source.
connection pool is needed for each and every physical database.
Java Development Kit (JDK), is a software package that contains the minimal set of tools needed to write, compile, debug, and run Java applets.
An opaque view is a physical layer table that contain select statement. An opaque view should be used only if there is no other option.
No we cant migrate the presentation layer to a different server rather we have to migrate the whole web & rpd files.
Dimension tables contain descriptions about data analysts which is used as query in the database. Every table contains a primary key that contains one or more columns; each row in a table is uniquely identified by its primary-key value or values.
To improve the performance and query response time we have multiple LTS in BMM.
There is no full form for rpd as such, it is just a repository file which is known as Rapidfile Database.
We can disable cache in the physical layer, by right clicking on the table there we can have the option which define cacheable.
We have to make a dubbed table in the physical layer.
Yes, we can have multiple data sources in Siebel Analytics.
By using expression builder we can create case statement when…then.. end .
It can by-passed by setting authententication type in NQSCONFIG file in the security section as:authentication_type=bypass_nqs.instanceconfig.xml and nqsconfig.ini are the 2 places.
We can add groups by going to manage>security>add new groups> We can give permissions to a group for query limitation and filter conditions.
We can do Aggrigation navigation ,level base matrics, time series wizard, create new logical column, comlex join.
Passwords for userid are in siebel analytics server repository.
Pipelines are the stages in a particular contract, valuation, economics etc.
The key configuration files in OBIEE 11g are NQSConfig.ini, NQSCluster.ini, odbc.ini, instanceconfig.xml
Oracle BI Enterprise Edition (sometimes simply referred to as Oracle Business Intelligence) provides a full range of business intelligence capabilities that allow you to :
The Oracle BI Presentation Catalog stores the objects, such as analyses, dashboards, and KPIs, that you and other users create using Oracle BI EE. Users have their own personal folder (My Folders), where they can store the objects that they create. The objects in a personal folder can be accessed only by the user who created and saved the content into that folder. Users can add sub-folders to their personal folders to organize their content in the way that is the most logical to them.
You can also store objects in shared folders where other users or groups can access the objects. A combination of business logic security,catalog object security, and data level security determines who has the ability to view data and objects, edit objects, and delete objects from the catalog. Your administrator creates and maintains the catalog’s shared folder structure.
Oracle Business Intelligence Enterprise Edition (OBIEE) 11g is the most significant release of OBIEE since 2006.
Oracle Business Intelligence is now more integrate with the Oracle Fusion Middleware software family.
Oracle WebLogic Server replaces Oracle Application Server and Oracle Containers for Java (OC4J).
Oracle Business Intelligence 11g Installer replaces the installer that was used in previous versions of Oracle Business Intelligence. It can perform software installation and configuration steps in the same process or separately in their own processes
This release add the following administration command-line utilities :
An Oracle BI application consists of pre-built, industry-specific Oracl e BI interactive dashboards and Oracle BI reports that are built using industry best practices and address key functional areas within an organization. Oracle BI applications are integrated with operational applications to provide business metrics in reports, in context with an organization’s business function and industry.
Oracle BI applications include Extract Transform Load (ETL) routines to extract, transform, and load data into the Oracle Business Analytics Warehouse.
Repository stores the Meta data information.The extension of the repository file is “.rpd”.With OBIEE Server, all the rules needed for security,data modeling, aggregate navigation, caching, and connectivity is stored in metadata repositories. Each metadata repository can store multiple business models. OBIEE Server can access multiple repositories.
Repository is divided into three layer
OBIEE life cycle :
An Alias table is a physical table with the type of Alias. It is a reference to a physical table, and inherits all its column definitions and some properties from the physical table. A logical table source shows how the logical objects are mapped to the physical layer and can be mapped to physical tables, stored procedures and select statements. An alias table can be a reference to any of these logical table source types.
Alias Tables can be an important part of designing a physical layer. The following is a list of the main reasons to create an alias table
Authentication is the process by which a system verifies a user with the help of a user ID and password. It checks if user has the necessary permissions and authorizations to log in and access data.
There are 4 main types of Authentication in OBIEE :
Aggregate tables store pre-computed results, which are measures that have been aggregated (typically summed) over a set of dimensional attributes. Using aggregate tables is a very popular technique for speeding up query response times in decision support systems.
Ex : If you observe that most of the queries are fired on aggregated values like yearly or monthly data rather that day level data then to speed up the report we can create an aggregate table containing month level and year level data and map it to the respective logical table and set the aggregation levels in the content tab of LTS.
Session variables are similar to dynamic repository variables in that they obtain their values from initialization blocks. Unlike dynamic repository variables, however, the initialization of session variables is not scheduled. When a user begins a session, the Oracle BI Server creates new instances of session variables and initializes them.
A repository variable has a single value at any point in time. Repository variables can be used instead of literals or constants in Expression Builder in the Administration Tool. The Oracle BI Server substitutes the value of the repository variable for the variable itself in the metadata.
Unlike a repository variable, there are as many instances of a session variable as there are active sessions on the Oracle BI Server. Each instance of a session variable could be initialized to a different value.
OBIEE can be plugged on Relational Databases, Cubes or Flat files, with the following constraints :