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 FEBRUARY 03, 2019
Applies to:Hyperion Essbase - Version 18.104.22.168.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 22.214.171.124.210 connected to 126.96.36.199.508 - works as it should, parent member is not returned.
Smart View 188.8.131.52.210 connected to 184.108.40.206.006 - works as it should, parent member is not returned.
Smart View 220.127.116.11.520 connected to 18.104.22.168.508 - works as it should, parent member is not returned.
Smart View 22.214.171.124.520 connected to 126.96.36.199.006 - When the Pivot on East or Colas is done, the parent is also returned.
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