My Oracle Support Banner

OAC Essbase: 'Ancestor Position' Option Does Not Reflect in Smart View (Doc ID 2633244.1)

Last updated on JULY 26, 2022

Applies to:

Oracle Analytics Cloud - Classic - Version 105.1.0 to 105.4.0 [Release 105.1 to 105.3]
Information in this document applies to any platform.

Symptoms

Setting Ancestor Position to "Top" in Smart View does not have any effect on zoom operation. 

Smart View Options -> Member Options-> Ancestor Position -> Top, does not reflect in Excel.

Example:

  1. In Smart View, Navigate and connect to "EssbaseCluster > ASOSamp"
  2. Select "Basic" and choose "Ad hoc analysis" from Smart View panel options
  3. Select "Measures" and "Zoom In"
  4. Notice, the hierarchy is expanded with members above the Ancestor: 

           Original Price         #Missing

           Price Paid              #Missing

           Returns                 #Missing

           Items per Package  #Missing

Measures                          #Missing 

Instead "Ancestor Position -> Top" should list the members below the Ancestor:

Measures                         #Missing   

           Original Price         #Missing

           Price Paid              #Missing

           Returns                 #Missing

           Items per Package  #Missing

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.