GROUPING Function In Oracle

The Grouping function can be used with either the cube or rollup operator.  Using this function we can find the basis on which the groups are formed and it’s subtotal. It accepts a single column as a parameter and returns numeric values to identify the column value in an aggregated row. It returns 1 if the column contains a null value generated as part of a subtotal by a ROLLUP or CUBE operation and zero if it is NOT NULL

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

Hierarchical Retrieval In ORACLE or Hierarchical Queries

There is provision to display the reporting pattern in an organization.  In the select query we can use the level (pseudocolumn), which returns 1 for a root row and 2 for a child of a root and so on.The start with clause specifies the root of the rows. Connect by specifies relationship between the parent and the child prior clause is required for a hierarchical query.

Example:

ADVANTAGES AND DISADVANTAGES OF UNIX

UNIX computer operating system (A command Line based OS) was developed in early 1970’s at Bell Laboratories in the USA.
Because of the High reliability, scalability and powerful features UNIX remains as popular operating system. Some of big companies like Sun Microsystems, Apple Inc., Hewlett-Packard and AT&T, which is the original (parent company) uses UNIX. 

Depending on the kind of use of UNIX  has both Advantages and Disadvantages. Talking about the Advantages: