This content has been marked as final. Show 2 replies
For each level there is a separate table in SQL which is the source data. The hierarchy is as follows: WW->Region->Sub-Region->Manager->Sales Rep->Transaction. So for e.g., if the WW manager logs in he will be able to see the data from top level, similarly if the sub-region manager logs in he can view the data from sub-region and below and so on.