Pivot Tables are a data summarization tool, enabling you to "pivot" or rotate data and allowing you to look at data from different perspectives and to see a variety of patterns which may not be immediately obvious.
You can use Pivot Tables to automatically sort, group, and total data. You can also choose columns to include or exclude from a Pivot Table or move columns to rows or rows to columns.
|Where Term Appears|
|Institutional Assessment and Research|
|Logical Transformation / Calculation|
|OBIEE Folder and Column|
"One of the nice features of OBIEE is being able to view your data from various angles. Pivot tables make it easy to process and summarize large data sets in seconds. Pivot tables are a data summarization tool, enabling you to 'pivot' or rotate data, looking at it from different perspectives and seeing a variety of patterns which may not be immediately obvious. You can then automatically sort, count, total or give the average of the data."
- Humboldt State University. Enterprise Data Management. OBI Training, April 2013. Retrieved from: https://www.clarosoftware.com/login/chromeextension/pdf/?pdfUrl=https://its.humboldt.edu/sites/default/files/docs/datawarehouse/obiee_pivot_table_class.pdf.