Ad Hoc View Types

The Ad Hoc Editor allows you to select from three view types:

Tables, which are used to view values in the database and to summarize the values in columns.
Charts, which compare one or more measures across multiple sets of related fields.
Crosstabs, which aggregate data across multiple dimensions.

This section provides an overview of each view type. The design and content tasks for working with each type of view are discussed in more detail in the following sections:

For more information on table views, see Working with Tables.
For more information on chart views, see Working with Charts.
For more information on crosstab views, see Working with Standard Crosstabs.

Tables

The architecture of a table view consists of columns, rows, and groups.

Columns in a table correspond to the columns in the data source. They are included by adding fields or measures to the table in the Ad Hoc view.

Rows correspond to rows in the database. The information in each row depends on what columns are included in the table.

Using groups, rows can be grouped by identical values in any field with intermediate summaries for each grouped value. For example, a table view of product orders might contain columns to show the dates and amounts of each order, and its rows might be grouped by city and product.

 

Date Placed

Date Filled

Payment Received

City A

Product 01

 

Date

Date

Amount

 

Date

Date

Amount

Product 01 totals:

 

Count

Sum

Product 02

 

Date

Date

Amount

 

Date

Date

Amount

Product 02 totals:

 

Count

Sum

Product 03

 

Date

Date

Amount

 

Date

Date

Amount

Product 03 totals:

 

Count

Sum

City A totals:

 

Count

Sum

City B

Product 01

 

Date

Date

Amount

 

Date

Date

Amount

 

Date

Date

Amount

 

...

...

...

For more information on working with tables, see Working with Tables.

Charts

Charts summarize data graphically. Types of charts include bar chart, line chart, and pie chart, among others. With the exception of time series and scatter charts, each type of chart compares summarized values for a group. For example, the Chart tab might show the data in a bar chart that compared the sum of Payments Received for each of the products in each of the cities.

Total Payments Received

City A

City B

City C

 

Time series and scatter charts use time intervals to group data.

For more information on working with charts, see Working with Charts.

Crosstabs

Crosstabs are more compact representations than tables; they show only aggregate values, rather than individual database values. Columns and rows specify the dimensions for grouping; cells contain the summarized measurements. For instance, the example above could be displayed in a crosstab with columns grouped by sales manager and year.

 

Tom

Harriet

Manager Totals

2012

2013

Year Totals

2012

2013

Year Totals

City A

Product 01

Payment Received

Payment Received

Payment Received

Payment Received

Payment Received

Payment Received

Payment Received

Product 02

Payment Received

Payment Received

Payment Received

Payment Received

Payment Received

Payment Received

Payment Received

Product 03

Payment Received

Payment Received

Payment Received

Payment Received

Payment Received

Payment Received

Payment Received

Product Totals

Payment Received

Payment Received

Payment Received

Payment Received

Payment Received

Payment Received

Payment Received

City B

 

 

Product 01

Payment Received

Payment Received

Payment Received

Payment Received

Payment Received

Payment Received

Payment Received

...

...

...

...

...

...

...

...

City Totals

Payment Received

Payment Received

Payment Received

Payment Received

Payment Received

Payment Received

Payment Received

For more information on working with crosstabs, see Working with Standard Crosstabs.

OLAP connection-based crosstabs behave differently than those created from Topics or Domains. See Working with Topics.