Ad Hoc View Types

Open topic with navigation

Viewing: Working with the Ad Hoc Editor > Overview of the Ad Hoc Editor > Ad Hoc View Types

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 .

•

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	Manager 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 B	...	...	...	...	...	...	...	...
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.

Open topic with navigation