9 Replies Latest reply: Feb 8, 2016 10:05 AM by Tamil Nagaraj RSS

    Section Access on Sheet Level

    Carolin Borchert

      Hi,

       

      I´ve the following script that is not working:

       

       

      SECTION Access;
      LOAD
      NTNAME,
      ACCESS,
      Upper(USERFULLNAME) as USERFULLNAME,
      upper(SOLDTOBUSINESSPARTNER.EXTERNALSALESREPNAME) as SOLDTOBUSINESSPARTNER.EXTERNALSALESREPNAME,
      upper(AREASALESMANAGERNAME) as AREASALESMANAGERNAME,
      upper(GENERALMANAGERNAME) as GENERALMANAGERNAME,
      upper(GLOBALREGION) as GLOBALREGION,
      upper(SHEETFLAGTEST) as SHEETFLAGTEST
      FROM  $(vQVDPath)\SecurityFile.qvd (qvd)
      where 1=1;

       

       

      SheetFlag:
      LOAD
        upper(SheetFlagTest) as SHEETFLAGTEST
      FROM $(vQVDPath)\SecurityFile.qvd (qvd);

       

      Now I´m using the following function on my Sheet Properties:

       

      Conditional =SheetFlagTest=1

       

      Unfortunately this is not working as expected. As soon as I use the conditional the sheet can´t disappears although there are users which have a sheetflag = 1. What do I do wrong?

       

         

      NTNAMEACCESSSheetFlagTest
      User 1ADMIN1
      User 2ADMIN1
      User 3USER