1 / 16

OBIEE Training

OBIEE Training. Pivot Tables and Hierarchies. Ronda Stemach EDM Group April 8, 2013. Today’s Two Topics. Pivot Tables Data Summarization Tool Change of Perspective – View Data Different Ways Data Hierarchies Cascaded Data, Summary to Detail Created using business-specific logic.

elvis
Download Presentation

OBIEE Training

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. OBIEE Training Pivot Tables and Hierarchies Ronda Stemach EDM Group April 8, 2013

  2. Today’s Two Topics • Pivot Tables • Data Summarization Tool • Change of Perspective – View Data Different Ways • Data Hierarchies • Cascaded Data, Summary to Detail • Created using business-specific logic

  3. Humboldt’s Hierarchies

  4. Level Based Hierarchy • Fixed Number of Levels

  5. Special Level Based Hierarchy:Ragged • Not all “parent” members have “child” member

  6. Special Level Based Hierarchy:Skip-Level • Not all “child” members have a direct or immediate “parent” member

  7. Special Level Based Hierarchy:Mixed Example

  8. Value Based Hierarchy • Not often used • Based on Values within the same table • Classic Example – Org chart

  9. Pivoting Lab Create a Pivot Table to look initially like this…

  10. Pivoting Lab …and then change it to look like this…

  11. Pivoting Lab …then like this… …to this…

  12. Pivoting Lab …to this…

  13. 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.

  14. 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.

  15. 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.

More Related