Data Source Comparison: Relational Versus Multidimensional

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
Functionality
Relational
Multidimensional
When Functionality Is Available
Comments
Filtering category values for section queries (by selecting predefined filters or by creating custom filters)
yes
yes, but only predefined section filters
designing
A data source administrator determines whether the data source supports this functionality.
Filtering and ranking data in tables, graphs, and maps
yes
yes
viewing and designing
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
yes
yes
viewing and designing
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
yes
no
designing
For multidimensional data, records are always grouped and the aggregation method of a measure cannot be changed.
Viewing detail data
no
yes
viewing
A data source administrator determines whether the data source supports this functionality.
Drilling and expanding
no
yes
viewing
A data source administrator determines whether the data source supports this functionality.