3 Replies Latest reply: Nov 2, 2015 5:26 AM by Ruben Marin RSS

    Section Access * Issues

    sundarraj ramchandran

      Hello All,

       

      For the Section access I use excel and then load it in to INLINE table.

      Now my problem is regarding * .

      When I use * for all values it doesn't work.

      Please provide me alternate solution.

       

      Regards,

      Sundar

        • Re: Section Access * Issues
          Peter Cammaert

          Loading an Excel into an INLINE table is pretty much impossible. I guess you mean something else.

           

          Did you use the STAR IS *; statement?

           

          What do you mean with '...I use * for all values...'? The *-mechanism in a Section Access table is limited to 'all values in the same column in that same table. Not all values you encounter in your data model.

           

          Peter

          • Re: Section Access * Issues
            balraj ahlawat

            Try Peter's suggestion with Star statment.

             

            Else you need to define all the fields one by one if not Star statement

            • Re: Section Access * Issues
              Ruben Marin

              As said above '*' in section access means something like "all the values previously loaded in section access for this field". To use * like it was "all values" I first load the admin security with all values, after this all the fields has all values and '*' works as expected, in example:

               

              Section application;

              Data:

              LOAD COUNTRY, Sales From...

               

              Section access:

              Access:

              LOAD * INLINE [

                  ACCESS, NTNAME

                  ADMIN, ADMINISTRATOR

              ];

               

              Join LOAD Distinct COUNTRY Resident Data;

                  

              Concatenate (Access) // From here you can add usual security and '*' in COUNTRY will load all loaded values.

              ...