Smart View: Pivot Member From Column to Rows in Smart View Also Creates Row with Top Level Parent

(Doc ID 2103113.1)

Last updated on APRIL 11, 2016

Applies to:

Hyperion Essbase - Version 11.1.2.4.000 and later
Information in this document applies to any platform.

Symptoms

When pivoting on a column member, the parent member is also returned in a row:

 

 

This is a change in behavior from previous versions. Steps used to replicate/test:

Start with a new Excel sheet on each test:

1. Connect to Sample / Basic.

2. Do an Ad hoc analysis. You may also want to set the Alias Table to none.

3. Manually change the dimensions to:

Product -> '100
Market -> East
Scenario -> Actual
Measures -> Sales
Year -> Mar

4. Refresh.

5. Pivot on East.

6. Pivot on 100/Colas.

Smart View 11.1.2.5.210 connected to 11.1.2.3.508 - works as it should, parent member is not returned.
Smart View 11.1.2.5.210 connected to 11.1.2.4.006 - works as it should, parent member is not returned.

Smart View 11.1.2.5.520 connected to 11.1.2.3.508 - works as it should, parent member is not returned.
Smart View 11.1.2.5.520 connected to 11.1.2.4.006 - When the Pivot on East or Colas is done, the parent is also returned.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms