Oracle Analytics determines the default result view according to the types of columns included in the analysis. Oracle documentation states that when an analysis contains only attribute and measure columns, the Compound Layout initially contains a table . However, when the analysis contains at least one hierarchical column , Oracle automatically creates a pivot table view .

This behavior is intentional because a pivot table is designed to represent hierarchical structures effectively. It supports expansion and collapse of hierarchy members, multidimensional presentation, and hierarchical navigation in ways that a conventional flat table doesn't.

A trellis view is useful for repeated visual comparisons across dimensions but isn't automatically generated merely because a hierarchy is present. Graph and gauge views must generally be added explicitly when appropriate. Likewise, the statement that every analysis defaults to a table is incorrect because Oracle specifically distinguishes hierarchical analyses from analyses containing only attribute and measure columns.

Therefore, once the author selects Results for an analysis containing a hierarchical column, the default result visualization is a Pivot Table . This behavior is directly documented in Oracle's Analysis Results guidance.

Reference Topic: Managing and Creating Analyses, Views, and Content — Hierarchical Columns and Default Views

===============