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 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
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.



EXPECTED BEHAVIOR
-----------------------

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.

Changes

 

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