Dense or sparse dimension designation | Not relevant | Relevant |
Multiple hierarchies enabled, dynamic hierarchy, or stored hierarchy designation | Relevant | Irrelevant |
Accounts dimensions and members on dynamic hierarchies | Support with the following exceptions: No two-pass calculation (however, for information on specifying the calculation order, see Calculation Order) No association of attribute dimensions with the dimension tagged Accounts Additional restrictions for shared members. See Alternate Hierarchies.
| Full support |
Members on stored hierarchies | Support with the following exceptions: Support for the ~ (no consolidation) operator (underneath label-only members only) and the + (addition) operator Cannot have formulas Restrictions on label only members (See Member storage types.) No Dynamic Time Series members Stored hierarchy dimensions cannot have shared members. Stored hierarchies within a multiple hierarchies dimension can have shared members. See Stored Hierarchies.
| Full support |
Member storage types | Support with the following exceptions: Dynamic Calc and Store not relevant On stored hierarchies, two limitations if a member is label only:
Note: On dynamic hierarchies, ability to tag any member as label only Note: On conversion from a block storage database, attribute dimension members are tagged as Dynamic Calc. On standard dimension members Dynamic Calc tags are converted and tagged as stored members, which changes the Members Stored value on the Dimensions tab of the Database Properties window in Administration Services. | Support for all member storage types in all types of dimensions except attribute dimensions |
Ragged hierarchies and hierarchies with more than 10 levels | Support, with possible performance impact | Support |
Outline validation | | When outline is saved When user requests
|
Outline paging | Support | No support |
Database restructure | Levels of restructure; see Aggregate Storage Database Restructuring | Levels of restructure; see Optimizing Database Restructuring |