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.


No comments

Post a Comment

Text Widget