6 Replies Latest reply: Jul 6, 2012 2:25 PM by Logesh Jayaraman RSS

    Section access from regional , district managers and territory sales rep

      Hi All,

       

      The problem i am facing now is that my dashboard has an alignment table and a metric table.

       

      So the alignment table is in the format

       

      RegionDistrictTerritoryZip
      AA1A1287321
      AA1A1323456
      BB2B2423457

       

      The Fact table is in the form

       

      ZipQuantityCost Per Price

       

      Now i am rolling the data based on the Zip join for the quantity and sales made.

       

      The problem is that my client wants the follow requirements:

       

      Each Sales Rep should be able to see his territory data.

      His parent district data.

      Should not see his peer territory data

      See his parent region data

      See the national data.

       

      So sales rep of A12 should not see A13 sales but is allowed to see A1's data.

       

      How do i go about this? Have read about section access but still not able to come to an approach.

      Any help would be greatly appreciated.

      Thanks,