The following
table compares some of the functionality that might be available when
designing and viewing reports that are based on relational and multidimensional
data sources.
Data Source Comparison
|
|
|
|
When Functionality Is
Available
|
|
Filtering category values
for section queries (by selecting predefined filters or by creating
custom filters)
|
|
yes, but only predefined
section filters
|
|
A data source administrator
determines whether the data source supports this functionality.
|
Filtering and ranking
data in tables, graphs, and maps
|
|
|
|
A data source administrator
determines whether the data source supports this functionality.
You cannot create measure
filters or rankings for crosstabulation tables in Design mode.
|
Sorting in tables and
graphs
|
|
|
|
A data source administrator
determines whether the data source supports this functionality.
When you are designing
a report, only sorting for list tables is available.
You cannot specify a
sorting priority for multidimensional data.
|
Modifying detail and
aggregation settings
|
|
|
|
For multidimensional
data, records are always grouped and the aggregation method of a measure
cannot be changed.
|
|
|
|
|
|
A data source administrator
determines whether the data source supports this functionality.
|
|
|
|
|
|
A data source administrator
determines whether the data source supports this functionality.
|