Zooming in on Shared Members
Shared members are supported in ad hoc grids and the system recognizes whether a member is a base member or a shared member. If your administrator enables the application setting, Allow drill down on shared members in ad hoc, then zooming in on shared members is supported. In this case, zooming in on shared members is effectively the same as zooming in on the corresponding base members. You can zoom in on shared members one level at time.
If your administrator enables the application setting, Drill to All Levels in Base, you can zoom in beyond just the shared members into all levels or only the bottoms levels within the base hierarchy using the Zoom In options, All Levels and Bottom Level.
Example Shared Member Zoom In
This example describes the results you will see when Allow drill down on shared members in ad hoc is set to Yes and Drill to All Levels in Base is enabled.
Figure 19-1 shows three
hierarchies under the Entity dimension. In the entity_10
hierarchy,
all members descend from entity_10
. In the
entity_12
hierarchy, all members descend from
entity_12
. In the entity_14
hierarchy, there
are descendent members of entity_14
as well as the shared members,
entity_10
and entity_12
. The shared members
include their descendents.
Figure 19-1 Entity Dimension Showing Its Hierarchies
![Entity dimension and its hierarchies, including a shared member hierarchy Entity dimension and its hierarchies, including a shared member hierarchy](img/shared_member_zoom_hierarchies.jpg)
Figure 19-2 shows the
difference between zooming in on entity_14
:
-
Using the Zoom In to All Levels command
-
Using the Zoom In to Bottom Levels command
In both cases, in Oracle Smart View for Office, Member Options, Ancestor Position is set to Top.
Figure 19-2 Results of Zooming in on entity_14, with Ancestor Position=Top
![Hierarchy structures showing the results of zooming in on a shared member using the All Level option and the Bottom Level option Hierarchy structures showing the results of zooming in on a shared member using the All Level option and the Bottom Level option](img/shared_member_zoom_results_no_title.jpg)
Note:
In a Native mode application, you can achieve the results shown in the Zoom In to All Levels example, if Allow drill down on shared members in ad hoc set to Yes, and Drill to All Levels in Base disabled; however, you will need to zoom in one level at a time on the shared members till you reach the bottom level of each hierarchy. You will not be able to zoom in directly to the botton level of the shared members.