OBIEE 10G/11G - Pivot View

Saw Object

About

This view displays results in a pivot table, which provides a summary view of data in cross-tab format.

New in 11g

Pivot tables provide the ability to rotate rows, columns, and section headings to obtain different perspectives of the same data. They are interactive in that they are drillable, expandable, and navigable, providing the perfect vehicle for trending analyses.




Discover More
Saw Object
OBIEE - (Answer|Analytics) Views

View (data displays) are used to display the data result set of an analysis. They are build using ADF DVT. Adding...
Obiee Total Label At
OBIEE - At Sign (@)

The at sign (@) indicate the value of a column. In a narrative, you use the @n to include the results from the column n in the narrative. @1: value of the first column @2: value of the second...
Obiee Narrative Template For Excel
OBIEE - How to create an HTML view (Narrative, Static Text) to get a good Excel formatting ?

When you download an answer to Excel, you have all the chances to get a bad alignment of the cells when you use a view with HTML tag (such as a narrative view of a static text). OBIEE uses MHTMLMHTML...
Obiee Filter On Internet
OBIEE - How to perform a pivot in a table view

This article explains how to obtain a pivot view in a table view through the creation of pivot measures. A pivot table is just the same table where : the pivot column has been suppressed for...
Obiee Pivot Varchar Max
OBIEE - How to pivot a character column ?

The pivot of a character is just an easy way to split one character column in two or more columns. By default, the pivot view take the measures (the column set with an aggregation rule) and place them...
Obiee Pivot Sort On Column Total
OBIEE - How to sort on the column grand total value of a pivot view ?

In a pivot view, you don't have any options to choose the sort order on the column grand total (Amount sold in our case). To sort on a measure column (Direct Sales for instance), see this article : ...
Obiee Pivot Measures
OBIEE - Pivot Measures (The Filter Function)

Indicator, description of Measures are generally the sign that you need to pivot your measure (i.e. to create a Pivot Measure) The revenue is booked. Revenue is the measure and booked is a description...
Obiee Conditionnal Formating
OBIEE 10G - Cross conditional formatting on a pivot

OBIEE does not support cross column conditional formatting in Pivot view. For instance, it's not possible to set a red background of a column based on the value of an other column. Below is a workaround...
Obiee Goal Suppress Detail Row Of Group
OBIEE 10G - How to suppress detail rows of a master group in a pivot view ?

You have detail row of a group in a pivot view that you want suppress as this : We have two solutions : if you don't need a total by “promo Category” (by post or by internet), you can create...
Saw Object
OBIEE 10G/11G - Answer/Analytics

(Answers 10g|Analyses 11g) is the base component of BI Presentation Service to create Web report . It provides: ad-hoc query and analysis capabilities. The definition of an answer is principally...



Share this page:
Follow us:
Task Runner