How to Hide or Disable "Create Bookmark Link" in OBIEE? | How to Hide or Disable "Create Prompted Link in OBIEE

The Create Bookmark Link is enabled by default in OBIEE. The following entry in the instanceconfig.xml under the "ServerInstance" node decides the feature of create bookmark link and create prompted link. 

<Dashboard>
<EnableBookmarkURL>True</EnableBookmarkURL>
<EnablePromptedURL>True</EnablePromptedURL>
<BookmarkExpirationDays>30</BookmarkExpirationDays>
</Dashboard>

Calculated Percentage Column always showing result as 0% Zero Percentage in OBIEE 11g

You may also face similar issue while upgrading OBIEE to a newer version or if you upgrade some of your dashboards from OBIEE 10.1.3.4 to 11.1.1.5. The issue is that, some of the calculations under certain columns in the reports were showing zeros instead of the calculated values.  The requirement was to calculate a match rate % for some data based on another field that showed 'MATCH' or 'NO MATCH'. 

 The real-time scenario was

(SUM(CASE Table1.Column1 WHEN 'MATCH' THEN 1 ELSE 0 END)/COUNT(Table1.Column1))*100

However, this was returning 0% as the result. With the help of some blogs and questions raised on OBIEE threads I came to know that this happens when you have an integer in a calculation. The solution which I used is very simple and was successful in achieving the requirement. The very easy fix to this issue is to multiply the calculation by 1.0.  The updated calculation which works is shown below and provides a meaningful result.

(don't use 1, as this will not work.  Use 1.0)

((1.0*SUM(CASE Table1.Column1 WHEN 'MATCH' THEN 1 ELSE 0 END))/(1.0*COUNT(Table1.Column1)))*100

DATAWAREHOUSE CONCEPTS- TOP 10 TOPICS OF 2014

This post is just a recap of the most discussed topic in Dwhlaureate for the year 2014.

1. VIRTUAL COLUMN IN ORACLE 11G 
   Virtual Column is one of the new features introduced in Oracle 11g….. 

2. OBIEE 11.1.1.7- New Features 
   OBIEE 11.1.1.7 has been released by Oracle and they included more than two hundred enhancements, designed to add new functionality for improved performance and deliver an enhanced end user experience….. 

3. Hierarchical Retrieval In ORACLE or Hierarchical Queries 
   There is provision to display the reporting pattern in an organization….. 

4. Invisible Indexes - Oracle 11g New Feature 
   Before 11g, Oracle didn’t have the facility to make an Index Invisible or visible…… 

5. “ VoltDB ” - NewSQL DBMS For High Velocity Applic... 
   VoltDB is a high performance scalable RDBMS and NewSQL Database primarily for Big Data, high velocity OLTP and Real-time analytics designed by…… 

6. Introduction To NewSQL 
   NEWSQL is a new class of Databases products that offers high performance and scalability like NoSQL for online transaction processing and also 

7. What is Massively Parallel Processing (MPP) With the advent of Big Data sets mainstream technologies like Massively Parallel Processing (MPP) systems is experiencing vital growth…. 

8. Oracle Database 12C New Feature-Fetch& Offset 
   In this post we will discuss about a new feature that was introduced in Oracle 12c to limit the rows returned in an easier and effective manner compared to methods …. 
   
   
9. How to Unlock the Locked Table in ORACLE 
   Oracle puts locks while performing any DDL or DML operation on oracle tables. When table locks is present on any tables in Oracle we cannot run DDL on those tables. 

10. Informatica Scenario: How to Load Data in Cyclic Order 
    In this scenario we will load the records present in the DEP table to Flat files in a cyclic order such that the first record will go to TargetFile01 ,2nd to TargetFile 02 ,3rd to Target File03 and 4th record again to TargetFile01. 
    
    
    
    
    If you like this post, please share it on google by clicking on the Google +1 button.
    
    
    Please go through our latest post TOP 6 BIG DATA TRENDS IN THE NEAR FUTURE
    
    

Inline Prompts in OBIEE 11g

A prompt that is created at the OBIEE analysis level is called an inline prompt. This is referred as inline prompt because the prompt is embedded in the analysis and is not stored in the Oracle BI Presentation Catalog. That means the prompt is created for that particular analysis and therefore cannot be added to other analyses.

Application Roles in OBIEE

Default OBIEE Application Roles
Application Role	LDAP Group	Description
BIConsumer	BIConsumers	Base-level role that grants the user access to OBIEE analyses, dashboards and agents.
BIAuthor	BIAuthors	All BIConsumer rights, grants and permissions + allows users to create new analyses, dashboards and other BI objects
BIAdministrator	BIAdministrators	All BIAuthor and BIConsumer rights, grants and permissions + allows the user to administer all parts of the system.

By default, OBIEE 11g have three application roles:

• BIConsumer : The base-level role that grants the user access to existing analyses, dashboards and agents, allows them to run or schedule existing BI Publisher reports, but not create any new ones. That means user can view the existing reports and dashboards.
• BIAuthor : A role that allows users to create new analyses, dashboards and other BI objects. This role will recursively granted the privileges of BIConsumer role.
• BIAdministrator : This role has the privileges of BIAuthor &BIConsumer roles. In addition to that this role allows the user to administer all parts of the system, including modifying catalog permissions and privileges. This user is the most privileged user in OBIEE environment.

In some cases, a need may arise to add another role that suits well between the BIConsumer and BIAuthor roles; one called BIAnalyst, that allows users to create and edit analyses, but not creates new dashboards.

OBIEE 11.1.1.7- New Features

OBIEE 11.1.1.7 has been released by Oracle and they included more than two hundred enhancements, designed to add new functionality for improved performance and deliver an enhanced end user experience.

The major features and enhancements are listed down based on my reading and collection from various online portals and articles.

Check it out!!!

1. New UI Features:

a. New graphs: Performance Tile, Waterfall, and 100 percent stacked bar

b.Breadcrumbs:

• A feature taken from Endeca
• Breadcrumbs have been added to help users understand their current location within Oracle BI content and the path that they have used to navigate Oracle BI content.
• Breadcrumbs display at the bottom of the page, and users can click a breadcrumb or the breadcrumb overflow button to navigate to a specific location on their breadcrumb trail.

c. Enhancement to Dashboards - This release provides the following enhancements to dashboards:

• The ability to create custom print layouts for high-fidelity printing of dashboard pages (i.e. automatic creation BI Publisher reports or by integration with BI Publisher).
• The new default style is FusionFX(instead of "BLAF : Browser Look and Feel")
• The Freeze Column option under the Column Properties menu is newly added feature in OBIEE11.1.1.7. This option allows you to freeze a column at an edge (top or left) of a dashboard layout.
• The newly added option listed down allow us to control the position and size of columns and sections: 

o    Size option in the Additional Formatting Options area of the "Section Properties dialog" and the "Column Properties dialog"

o    Page Size option in the "Dashboard Properties dialog

Types of Dimensions

Dimension

A dimension table typically has two types of columns, primary keys to fact tables and textual\descriptive data.

Eg: Time, Customer

Types of Dimensions

1. Slowly Changing Dimensions
2. Rapidly Changing Dimensions
3. Junk Dimensions
4. Inferred Dimensions
5. Conformed Dimensions
6. Degenerate Dimensions
7. Role Playing Dimensions
8. Shrunken Dimensions
9. Static Dimensions 

Slowly Changing Dimensions

Attributes of a dimension that would undergo changes over time. It depends on the business requirement whether particular attribute history of changes should be preserved in the data warehouse. This is called a slowly changing attribute and a dimension containing such an attribute is called a slowly changing dimension.

Types of Fact Table

The Types of Fact Table are

1. Snapshot
2. Cumulative
3. Factless Fact Table

Snapshot

This type of fact table describes the state of things in a particular instance of time, and usually includes more semi-additive and non-additive facts. The second example presented here is a snapshot fact table.

Eg: Daily balances fact can be summed up through the customers dimension but not through the time dimension.

Types of Facts

Fact

A fact table typically has two types of columns, foreign keys to dimension tables and measures those that contain numeric facts. A fact table can contain fact’s data on detail or aggregated level.

Eg: Sales, Cost, and Profit

Types of Facts

1. Non-Additive
2. Semi-Additive
3. Additive

Different Types of Logging Levels in OBIEE

Logging Levels	Logging Level Information That Is Logged
Level 0	No logging
Level 1	Logs the SQL statement issued from the client application. Logs the elapsed times for query compilation, query execution, query cache processing, and back-end database processing. Logs the query status like whether it is a success, failure, termination, or timeout. Logs the user ID, session ID, and request ID for each query.
Level 2	Logs everything logged in Level 1. Additionally, for each query, Logs the repository name, business model name, presentation catalog name which is called as Subject Area in Answers. Logs the SQL for the queries issued against physical databases. Logs the queries issued against the cache. Logs the number of rows returned from each query against a physical database and from queries issued against the cache, and the number of rows returned to the client application
Level 3	Logs everything logged in Level 2 Additionally, Adds a log entry for the logical query plan, when a query that was supposed to seed the cache was not inserted into the cache, when existing cache entries are purged to make room for the current query, and when the attempt to update the exact match hit detector fails
Level 4	Logs everything logged in Level 3 Additionally, logs the query execution plan.
Level 5	Logs everything logged in Level 4 Additionally, logs intermediate row counts at various points in the execution plan.
Level 6 & 7	For future purpose