OBIEE - SPLessons
SPLessons 5 Steps, 3 Clicks
5 Steps - 3 Clicks

OBIEE Views

Views

shape Description

OBIEE or OBI is a reporting tool or application used by business users to query or requests the organization data stored over a period of time or in data warehouse or OLAP to obtain answers or results or reports for the analysis of business and make better decisions. OBIEE 11g is based on a demonstrated and modern technological establishment that backings the most astounding workloads and most complex arrangements, while giving opportune experiences to clients over an undertaking at a low general aggregate cost of proprietorship. Distinctive sorts of perspectives can be included, for example, charts and turn tables that permit penetrating down to more itemized data and numerous choices alternatives by utilizing channels. Views can be analysed and displayed using pivot and table view that entirely depends on the type of columns that it contain:

Pivot table

Pivot table is the default view if the analysis consisting of least one progressive segment.

Table view

Table view 
is utilized if the test contains just property segments or a blend of both.

Types of views

shape Description

All view sorts with the exception of coherent SQL view can be altered. Every view has its own supervisor in which the user can perform alter assignment.Every view manager contains a special usefulness for that view sort yet may likewise contain usefulness that is the same crosswise over view sorts. They are 3 types of views such as:

Edit views

shape Description

Open the test that consisting of the view to alter. Tap the "Investigation supervisor: Results tab."Tap the Edit View catch for the view. view editors is shown. Presently, utilizing the editorial manager for the view, make the required alters. Click done and after that spare the view.

Delete views

shape Description

This view can be deleted by using these view commands,such as:
  • A compound layout − If you expel a view from a compound design, it is just expelled from the compound design and not from the investigation.
  • Analysis − If you expel a view from an investigation, it expels the view from the investigation furthermore from any compound design to which it had been included.

Remove views

shape Description

This view can be remove by using these view commands,such as:
  • A compound layout − In the view in the Compound Layout and tap the Remove View from Compound Layout catch.
  • Analysis − In the Views sheet,select the view and after that tap the Remove View from Analysis toolbar button.

Summary

shape Key points

  • View - Is a database object which is used to check all the necessary priveliges.