Understanding OBIEE Training: Pivot Tables, Hierarchies, Graphs & More
Explore OBIEE training covering pivot table data summarization, hierarchical data structures, and graph visualization. Learn about different types of hierarchies and how to create and customize pivot tables effectively. Dive into the world of graphs for visually displaying numeric information for better data comprehension.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
OBIEE Training Pivot Tables and Hierarchies Ronda Stemach EDM Group April 8, 2013
Todays 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
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 http://sandybi.files.wordpress.com/2010/08/image003.png?w=279h=180
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.
