Here are general guidelines to keep in mind when using Advanced Relational Access:
Only outlines that are valid for aggregate storage can be Advanced Relational Access outlines. Block storage is not supported.
Advanced Relational Access requires MDX formulas.
Note: | An MDX query made against a ragged hierarchy in an Essbase cube returns data results that can differ significantly from the results obtained when the same MDX query is made against a ragged hierarchy in an Advanced Relational Access cube. See the section Different Values Loaded in Ragged Hierarchies. |
Members enabled for Advanced Relational Access are shown in Administration Services Console Outline Viewer but are not shown in the Outline Editor.
A Time dimension from the Fact table is not supported. strongly recommends that you create a separate Time dimension table with time data only.
When there are multiple measures defined in a metaoutline, consolidation at the highest level is based on the first measure only.