Problem using hierarchical variables as Pivot Table
(Doc ID 2214637.1)
Last updated on JANUARY 25, 2018
Applies to:Oracle Fusion Sales Cloud Service - Version 184.108.40.206.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.
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