Column level access using Section Access

    Hi,

     

    This thread will helps in implementing the column level access. This can be done with Section Access and using Enable Conditional for Dimension in each chart.

     

    Please find attached file for solution.

     

    Login with below user IDs and no Password required :

    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.