Pivot tables training

Download Report

Transcript Pivot tables training

OBIEE Training
Pivot Tables and Hierarchies
Ronda Stemach
EDM Group
April 8, 2013
Today’s Two Topics
1. Pivot Tables
•
•
Data Summarization Tool
Change of Perspective – View Data Different
Ways
2. Data Hierarchies
•
•
Cascaded Data, Summary to Detail
Created using business-specific logic
Humboldt’s Hierarchies
Level Based Hierarchy
• Fixed Number of Levels
Special Level Based Hierarchy:
Ragged
• Not all “parent” members have “child”
member
Special Level Based Hierarchy:
Skip-Level
• Not all “child” members have a direct or
immediate “parent” member
Special Level Based Hierarchy:
Mixed Example
Value Based Hierarchy
• Not often used
• Based on Values within the same table
• Classic Example – Org chart
Pivoting Lab
Create a Pivot Table to look initially like this…
Pivoting Lab
…and then change it to look like this…
Pivoting Lab
…then like this…
…to this…
Pivoting Lab
…to this…
OBIEE Graphs
• A graph view displays numeric information
visually, which makes it easier to understand
large quantities of data.
• For displaying a single data value, a gauge is often
more effective than a graph.
• A gauge usually plots one data point with an
indication of whether that point falls in an
acceptable or unacceptable range.
• Gauges are useful for showing performance
against goals.
Types of Gauges
• DIAL - Shows data with one or more
indicators that point to to where the
data falls within predefined limits.
• HORIZONTAL BAR - Shows data using a
horizontal bar that changes color to
indicate whether the data is within
predefined limits. The inner rectangle
of the horizontal bar shows the current
level of data against the ranges marked
on an outer rectangle.
Types of Gauges, continued
• VERTICAL BAR - Shows data using a vertical
bar that changes color to indicate whether
the data is within predefined limits. The inner
rectangle of the vertical bar shows the
current level of data against the ranges
marked on an outer rectangle.
• BULB - Shows data using a circle that changes
color to indicate whether the data is within
predefined limits. Useful to display status,
not a specific value or threshold.