2 Replies Latest reply: Jun 20, 2013 7:52 AM by Bikash S RSS

    two separate filter for same application

    anutosh_dhar anutosh_dhar

      I have two users one can view sales chart other can view purchase chart.

      How can i do this ?

      is it the right approach to make it indirect set analysis?

       

      if user A logged in then he can able to see-sales chart

      if user B logged in then he can able to see-purchase chart

        • Re: two separate filter for same application
          sivaraj seeman

          Go with section access to filter the data

          • Re: two separate filter for same application

            Hi ,
            Yes u can try This

            Create a security table

            Please find below tables ;

            Example

            Table:
            Load

            User Name  SHEET1  SHEET2  
            *                    1             1

            User1             1             0

            User2             0             1

            Left join

            Load
            ACCESS  USERID   PASSWORD UserName  Group          
            SheetView       
            ADMIN   qvadmin    123                  *               ADMIN            
            *
            USER   *                 *                   User1          Sales        
            SHEET1              
            USER   *                 *                    User2         Purchase  
            SHEET2     

             

             

             

            Sheet 1  for view Sales chart.

            Sheet 2  for view purchase chart.

             

             

            Hope above Table will work.

            Regards-Bika