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.
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.
Recommended Comments
There are no comments to display.