I want to build security for hierarchical data.
I have the data in hierarchy (product , entity , management) , but if i am implementing security at entity level i can only make selections in entity hierarchy but not with other hierarchies.
One of the reason i found is that we dont have data for parent node available in fact table but that is applicable for entity also then also i can make selections at any level i want in entity hierarchy.
If in security i am giving access to all the management levels and product levels , its restricting me to make selections in entity also which was earlier working with no access to any hierarchy.
If any one can guide me that will be very help full , beacause its on high alert .