Work with items in an Exploration View
You can do this by
- nesting rows or columns Nest rows or columns
- swapping rows and columns Swap rows and columns
- showing or hiding rows or columns Limit items
Exploration is a process in which you explore the relationships between items to help understand your business. The Exploration View helps you discover whether the value of one item is associated with that of another.
Comparisons are key elements of nearly every exploration. The following table shows examples of different types of comparisons.
| Comparison | Example |
|---|---|
| Simple comparison | Tents versus sleeping bags |
| Multiple comparison | Tents versus golf clubs, tees, and golf balls |
| Multidimensional comparison | Products versus territories, this year-to-date versus last year-to-date |
| Mixed comparison | Tents versus similar camping products, this year versus last year, and the last quarter versus last year |
| Summaries of measures at different levels | Tents as a share of camping products, as a share of European sales |
Explorations and relational sources
Explorations can be used to transform relational sources into an Exploration View that allows dimensional style layout. Filters for relational explorations are, however, detail filters as opposed to dimensional. If dimensional style layout and filtering are common requirements, we recommend that you create a DMR model for this data source to simplify report creation.
Explorations and dimensional sources
We recommend that you use explorations for dimensional sources. Even if the report has a simple layout with no nesting and measures as columns, the query supports precise filtering if created as an Exploration View.