In outlines enabled for Advanced Relational Access or Hybrid Analysis through Oracle Essbase Integration Services, you can view members stored in a relational database or data warehouse in Outline Viewer in Administration Services Console. Relationally-stored members are not displayed in Outline Editor.
Note: | You should not edit and save any changes to an outline that is enabled for Advanced Relational Access. |
The advanced relational access feature applies only to aggregate storage outlines.
In Outline Viewer, relationally-stored members look identical to regular members; there is no indication as to which members are stored in a relational source. You can view relationally-stored members, but you cannot perform any actions on these members. For example, there are no member properties for relationally-stored members.
Note: | If you have chosen to display the child count of each member in Outline Viewer, the count does not include relationally stored members. |
To view relationally-stored members:
Open the outline in view mode.
The Outline tab is displayed.
Expand a member.
When expanding parts of the outline, keep in mind the following:
"Expand to children" on a member that contains relationally-stored children displays the children, as expected.
"Expand to descendants" on a member that contains relationally-stored children displays only the children (not all descendants) of the selected member.
"Expand outline" displays only the children (not all descendants) of any members that contain relationally-stored children.
Expanding parts of the outline that do not contain relationally-stored children works as documented for all outlines.
“Retrieving Relational Data” in the Oracle Essbase Database Administrator's Guide