Friday, March 18, 2016

Oracle Endeca : Return All Levels of a Hierarchical Dimension With a Single Record Search Query

In application, the catalog tree are stored in a hierarchical tree structure in Endeca (a hierarchical dimension). Only the top level dimens... thumbnail 1 summary
In application, the catalog tree are stored in a hierarchical tree structure in Endeca (a hierarchical dimension). Only the top level dimension values are returned from the hierarchy during record search query. 

Currently in a record search it is not possible to return all intermediate and leaf dimension values from all levels (essentially a whole "branch" of the tree hierarchy) with one query. It would require multiple queries to return dimensions values that were beneath the top level of the hierarchy in the left-navigation of a record search.

Find out the way below to solve above issue:-

The Dimension Search feature does allow you to return all dimensions values for a Dimension with the D=* and the Di= parameter where Di is a dimension ID, but this is a different mechanism than the Dimensions that are returned for the left-navigation of a regular record search. The Dimension search feature search againest only dimension values and fires a light weight query.


2 comments

Unknown said...

Ajay,

Thanks for the post. Do you have Sample code to achieve the above solution

Ajay Agrawal said...

you need to fire Dimension Search query and provide you flat results(non Hierarchical) and need to write a code to make it hierarchical.

Post a Comment

Note: Only a member of this blog may post a comment.

Text Widget