Data Source Comparison 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 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.
|