My Oracle Support Banner

"More..." option only appears 25 times when Trying to scroll through values in Parent-Child Hierarchy Selection (Doc ID 2822928.1)

Last updated on NOVEMBER 22, 2021

Applies to:

Business Intelligence Suite Enterprise Edition - Version and later
Information in this document applies to any platform.


Parent-Child Hierarchy Selection Limitation where one parent of the parent-child hierarchy has about 2000 children.

In selection steps or dashboard prompt, when expanding a long list of values, OBIEE will show the "More..." option to move to the next available values.
The "More..." option however only appears 25 times (which expand to exactly 520 children with default values). After that the "More..." stops displaying and the rest of the children are not shown.

The issue exists in both Selection Steps and dashboard prompt for a hierarchical column.

The issue can be reproduced at will with the following steps:

1. Create prompt for Parent-Chile hierarchical object having over 1000 members.
2. Drill into data and click on "More..." to see additional values.
3. Even though there are 1000+ values, it will stop and only display the first 520.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.