My Oracle Support Banner

Is it Possible to Return All Levels of a Hierarchical Dimension With a Single Record Search Query? (Doc ID 2002232.1)

Last updated on APRIL 03, 2017

Applies to:

Oracle Commerce Guided Search / Oracle Commerce Experience Manager - Version 6.1.0 and later
Information in this document applies to any platform.


In our application, the catalog tiers are stored in a hierarchical tree structure in Endeca (a hierarchical dimension). During a record search, only the top level dimension values are returned from the hierarchy. We have a requirement to display intermediate and perhaps even leaf nodes of the hierarchy when doing a record search. Is it possible to do this with one query?


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.