4 Replies Latest reply: Aug 23, 2017 3:18 PM by akshata tare RSS

    Sense Data reduction with Hierarchical Section Access

    akshata tare

      I want to provide user access based on their reporting hierarchy. So if Parent 1 has access to node 2,4,6 those are the only records they can see. I have created the user Hierarchy as shown on Sheet 1 in attached file and Access information is available in Organization worksheet. Following is the code I have so far but this shows all the information.

       

      TempTree:
      
      HierarchyBelongsTo(NodeID,ParentID,Employee,TreeID,TreeName)
      Load
          NodeID,
          ParentID,
          UPPER(Employee) as Employee
      
      FROM [lib://QVD Folder/Employee_Hierarchy.xlsx]
      (ooxml, embedded labels, table is Sheet1);
      
      //  Trees:
      
      // Load *,
      //      Upper(NodeID) as REDUCTION
      //      Resident TempTree;
      // Drop Table TempTree;
      
      Section Access;
      
      Auth:
      
      LOAD
          "ACCESS",
          NTNAME,
        //  Username,
          NodeID as REDUCTION
      
      FROM [lib://QVD Folder/Employee_Hierarchy.xlsx]
      (ooxml, embedded labels, table is Organization);
      
      Section Application;
      
      Link2:
      Mapping
      Load
          ParentID as REDUCTION,
          Employee
      
      FROM [lib://QVD Folder/Employee_Hierarchy.xlsx]
      (ooxml, embedded labels, table is Sheet1);