|
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 geographical 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 Edit 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.
|