7 Replies Latest reply: Apr 15, 2015 8:18 AM by usha gadd RSS

    Section access

      Hi experts,

      i wanna assign different columns to different users. is it possible to assign. help me

       

      ex:-    sno     name      dob        city    country

               1          raj         1991      atp     india

               2          kanna    1990     bnglr   india

      .

      in section access in need to assign  USER1 --> SNO ( COLUMN)

       

                                                          USER2 ---->  NAME ( COLUMN )

                                 

                                                           USER3---->   DOB,CITY,COUNTY ( COLUMNS)

       

       

      In section access if i enter into the USER1  i should see only SNO  values

      similarly for USER2      i should see only NAME values.  In the same for USER3 also.

       

      Thank you.

        • Re: Section access
          jagan mohan rao appala

          Hi,

           

          This should be done with Section Access and using Enable Conditional for Dimension in each chart.

           

          Please find attached file for solution.

           

          Login with user ID :

          A - Can see all the columns

          B - Can see Sno column

          C - Can see name column

          D - Can see sno, name and dob columns

           

          Try like this

           

          Section Access;

          LOAD * INLINE [

              ACCESS, USERID

              ADMIN, A

              USER, B

              USER, C

              USER, D

          ];

          Section Application;

          star is *;

           

           

          UserColumnMapping:

          LOAD

          *

          INLINE [

          USERID,Secsno,Secname,Secdob,Seccity,Seccountry

          A, 1,1,1,1,1

          B, 1, 0,0,0,0

          C, 0,1,0,0,0

          D, 1,1,1,0,0

          ];

           

           

          Data:

          LOAD *

          INLINE [

          sno,name,dob,city,country

          1,raj,1991,atp,india

          2,kanna,1990,bnglr,india];

           

           

           

          Note: You need to select Document Properties -> Opening tab -> and select Initial Data Reduction based on Section Access option



          Regards,

          Jagan.