10 Replies Latest reply: May 15, 2017 3:57 AM by Marco Imperiale RSS

    Another Section Access Issue

    Marco Imperiale

      Hi,

      I add a section access to my document and when I open it with my qlik client it works perfectly.

      It seems like I don't have data when I try to open from access point portal, in fact it returns me to userid/password screen...

      Is there maybe some switch to set on management console?

      (I set "Initial data reduction" and "Strict exclusion" to ON, if I set "Strict Exclusion" to OFF I enter...)

       

       

      Some help?!

        • Re: Another Section Access Issue
          Peter Rieper

          USERID or NTNAME?

            • Re: Another Section Access Issue
              Marco Imperiale

              Here my SA.

              MyAdmin enter correctly using Qlikview Client, not in the web Portal (even if I add the DOMAIN name....):


              LOAD * INLINE [

                  ACCESS, NTNAME, CODAGENTEPORT, DOCAGENTE

                  ADMIN, MYADMIN,*,*

                  USER, AAA,*,*

                  USER, BBB,*,*

                  USER, CCC,*,*

                  USER, DDD,*,*

                  USER, EEE,*,*

                  USER, FFF,*,*

                  USER, GGG,*,*

                  USER, HHH,*,*

                  USER, III,*,*

                  USER, JJJ,*,*

                  USER, KKK,*,*

                  USER, LLL,*,*

                  USER, MMM,*, C

                  USER, NNN,*, C

              ];

              CONCATENATE

              //============================================================================= AGENZIE

              LOAD

                'USER' AS ACCESS, UPPER(LOGIN) AS NTNAME, UPPER(CODAGENTE) AS CODAGENTEPORT, 'A' AS DOCAGENTE

              FROM

                [..\QVD\DOCAGE_A.qvd](qvd);

              CONCATENATE

              LOAD

                'USER' AS ACCESS, UPPER(LOGIN_L2) AS NTNAME, UPPER(CODAGENTE) AS CODAGENTEPORT, 'C' AS DOCAGENTE

              FROM

                [..\QVD\DOCAGE_C.qvd](qvd);

              ];

            • Re: Another Section Access Issue
              Peter Cammaert

              Note that an asterisk in a Section Access link field will only expand to all values in that field in that Section Access table, not to all the field values in your entire data model.

              For example I don't see any valid values for field CODAGENTEPORT, only stars...

                • Re: Another Section Access Issue
                  Marco Imperiale

                  All values are loaded in user concatenated after the first inline section

                  So I think it's like:

                  ACCESS, NTNAME, CODAGENTEPORT, DOCAGENTE

                  ADMIN, MYADMIN, *,*

                  USER,AAA,*,*

                  ...

                  USER,NNN,*,*

                  USER,NAME1,A001,A

                  USER,NAME2,A002,C

                  USER,NAME3,A003,A

                  USER,NAME4,A004,C

                  ...


                  So the ADMIN should take all CODAGENTEPORT listed in section access table and all DOCAGENTE (A and B) loaded after that


                  Isn't so?





                    • Re: Another Section Access Issue
                      Massimo Grossi

                      I tried this script

                       

                      SECTION Access;

                      LOAD * INLINE [

                      ACCESS, NTNAME, CODAGENTEPORT

                      ADMIN, domain\user, 1 

                      ADMIN, domain\user, *

                      ];

                         

                      SECTION Application;     

                      Y: LOAD rowno() as CODAGENTEPORT, 'num ' & rowno() as FIELD1 AutoGenerate 10;

                       

                      SECTION Access;

                      LOAD * INLINE [

                      ACCESS, NTNAME, CODAGENTEPORT

                      USER, DUMMY, 3 

                      USER, DUMMY, 4

                      USER, DUMMY, 5

                      ADMIN, domain\user, 6

                      ];

                       

                      I can see the CODAGENTPORT  1 3 4 5 6

                      Concatenate seems to work in section access

                        • Re: Another Section Access Issue
                          Peter Rieper

                          Concatenation works also in my scripts.

                          Think that the major problem is the "*", which considers only the values, which are loaded in the accesstable. If you only have "*" or the underlying data contain more entries, that in the Access-Table, users will not be able to see it.

                          Am therefore using a script like:

                          SECTION ACCESS;

                          STAR IS *;

                          AccessTable: LOAD DISTINCT 'DUMMY' AS ACCESS, MYFIELD RESIDENT .....;

                          CONCATENATE (AccessTable) LOAD ACCESS, NTNAME, MYFIELD FROM ....;

                          SECTION APPLICATION;

                           

                          'DUMMY' or any other string than USER or ADMIN is ignored by QV.

                           

                          The first part may also be replaced with a more performant script like

                          LOAD 'DUMMY' AS ACCESS, FIELDVALUE('MYFIELD', RECNO()) AS MYFIELD AUTOGENERATE FIELDVALUECOUNT('MYFIELD');

                           

                          Peter

                          • Re: Another Section Access Issue
                            Marco Imperiale

                            Where are concatenations in your examples?

                            It's true, the first agents are with "*" because are particular agents and they have to see everything.

                            All other agents are concatenated by some Loads from external qvds:

                             

                            LOAD INLINE ......

                            CONCATENATE

                                 LOAD ..... FROM QVD

                            CONCATENATE

                                 LOAD .... FROM QVD

                             

                            I know "*" match only those values listed in section access. It's ok. Special agents (in the INLINE section) have to see only those listed in concatenated qvd tables, don't need to load DUMMIES values.