Problem using hierarchical variables as Pivot Table
Last updated on JANUARY 25, 2018
Applies to:Oracle Fusion Sales Cloud Service - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Problem using hierarchical variables as pivot table
Trying to create an Analysis Report taking the Territory Hierarchy object from the Territory subject area as pivot table.
When run the report, just the top territory value is displayed in the choice list and the children and grandsons are not available from this list.
Also using Enterprise Period column as a second prompt then the choice list is presented but after we select one specific month, it is immediately discarded by the report.
Would like the Territory Hierarchy choice list in the report behaved similar to the current territory structure and it displayed the top level root node hierarchy, then its children and the third level all their corresponding grandchildren as the prompt output for the end user.
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