Smart View: Pivot Member From Column to Rows in Smart View Also Creates Row with Top Level Parent
Last updated on APRIL 11, 2016
Applies to:Hyperion Essbase - Version 126.96.36.199.000 and later
Information in this document applies to any platform.
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
5. Pivot on East.
6. Pivot on 100/Colas.
Smart View 188.8.131.52.210 connected to 184.108.40.206.508 - works as it should, parent member is not returned.
Smart View 220.127.116.11.210 connected to 18.104.22.168.006 - works as it should, parent member is not returned.
Smart View 22.214.171.124.520 connected to 126.96.36.199.508 - works as it should, parent member is not returned.
Smart View 188.8.131.52.520 connected to 184.108.40.206.006 - When the Pivot on East or Colas is done, the parent is also returned.
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