Opening Data Sources Directly

Note: Your data administrator determines what data sources you are authorized to view.
Data source reports are ad hoc reports that use either a list table or a crosstabulation table depending on the type of data. The following table shows the different data sources and the type of table that is used for an ad hoc report.
Data Source
Associated Icon
Type of Table
Relational information map
relational information map icon
A summarized list table that is based on a system default query or a default query that is set up by your data administrator
Multidimensional information map
multidimensional information map icon
A crosstabulation table that is based on a system default query or a default query that is set up by your data administrator
Table
table icon
A detailed list table including all underlying columns1
Cube
cube icon
A crosstabulation table that is based on a system default query
1When detail data is used, you cannot insert a crosstabulation table or any graphs except for scatter and bubble plots. To use a crosstabulation table and the other graph types, select Datathen select Summarization Options in Edit mode, and select the Summarize similar rows (Aggregated data) option.
To open a data source directly, complete these steps:
  1. Double-click an information map, table, or cube in the Open dialog box. The ad hoc report opens in View mode.
    Example of a Data Source Report Based on a Multidimensional Information Map
    Example of a Data Source Report Based on a Multidimensional Information Map
    Example of a Data Source Report Based on a Table
    Example of a Data Source Report Based on a Table
  2. Select Filethen selectSave. For information about how to complete the Save As dialog box, see Save a Report.
Tip
This is one of the quick start methods for creating a new saved report. For more information, see About the Quick Start Methods.