...
- It is possible to display multiple hierarchical relationships in Semarchy - for example, in the Product Retail demo application it is possible to configure hierarchy navigation by Product Family, Product Sub-Family, Product and Item, and also to navigate (in the same tree view) into the permitted sizes that are appropriate for each Product Family.
- If a recursive, self-join is used to represent a hierarchy, then you would want to add need a Root Filter to the business view to only display the top-most member of the hierarchy. You can access all descendant members (see definition of "descendant" below) by drilling down the hierarchy tree view. The This root filter is can be used to identify the root member of the hierarchy (ie. the value of the parent foreign key is null). Here is an example based upon an earlier data model example:
...