Drilling Ancestor position should be on TOP

Ramanuj Sarda

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

National Westminster Group Plc

Description (Required):

Drilling Ancestor position is not TOP but BOTTOM.

When drilling down (or Zooming in) smartview chart of accounts hierarchy, the ancestor position is always bottom inspite of users selecting the option in their smartview sheet.

This note https://docs.oracle.com/en/database/other-databases/essbase/21/escfg/ssancestorontop.html explains how to set an admin setting, but it does not take effect in SmartView/Essbase

Use Case and Business Need (Required):

When users select the Ancestor position as Top in their SmartView sheet, it does not display at Top, but displays at Bottom always.

Setting Ancestor Position to "Top" in Smart View did not have any effect, the ancestor is always retrieved at bottom.

Ancestor option is not supported for Essbase, it is supported only on planning and smart slice.

So it will always shows lowest to highest level when it is connected to Essbase via Smart View.

Requirement is to set the Ancestor position at Top based on user selection in SmartView reports

Enhancement Request / Service Request:

SR 3-30014445921 : Drilling Ancestor position is not TOP but BOTTOM