topic Re: Section Acces Not working In Ajax View in QlikView

Section Acces Not working In Ajax View

Wed, 05 Feb 2014 20:16:38 GMT

I am trying to publish a dashboard with section access , the publish is successful ,

but section access is working in Ajax view some computers and not In some.

Need Some help on this.

Re: Section Acces Not working In Ajax View

agilos_mla — Wed, 05 Feb 2014 20:22:45 GMT

It's not a problem with Ajax but more sthg to do with the authentication.

Do you check the strict exclusion in the document properties to ensure user that are not in SA are not authorized? What is the setup of the section access? Do you user User/Groups for authorizations?

Can you provide a short sample?

Michael

Re: Section Acces Not working In Ajax View

Wed, 05 Feb 2014 21:13:16 GMT

-----------------------------------------------------------------code starts-----------------------------------------------------------------------

Section Access;
LOAD
    upper( ACCESS) as ACCESS,
    Upper( NTNAME) as NTNAME

FROM
[..\..\QVD\Credentials.qvd]
(qvd);

Section Application;

UserNames:
Load
Upper(NTNAME)as NTNAME,
USER_NAME,
A, //A , B , C are sheet name these fields will contain value either 0,1 and
B, //and i am using these fields to either hide or show those sheets
C

FROM
[..\..\QVD\Credentials.qvd]
(qvd);

-------------------------------------------------------------------code ends-----------------------------------------------------------------

There are several problems I am facing:

1> If I put initial reduction based on selection access : the publisher distribute task works fine but , when I try to access from some other credential , shows me servers NTNAME in the table

2> RIght now I am doing initial selection based on section access , where I am having problem of it working with some computers and not working with others.

Re: Section Acces Not working In Ajax View

Anonymous — Wed, 05 Feb 2014 21:44:26 GMT

I maybe a little too cautious, but it doesn't look like a good idea to use system field (in this case NTNAME) for data reduction. I always create a separate field for this purpose. For example, use the same NTNAME data, but in a separate field:

Section Access;
LOAD
upper( ACCESS) as ACCESS,
Upper( NTNAME) as NTNAME

Upper( NTNAME) as REDUCTIONFIELD
...

Section Application;

UserNames:
Load
Upper(NTNAME) as REDUCTIONFIELD,

...

(No I don't think it will fix the problem)

Regards,

Michael

Re: Section Acces Not working In Ajax View

wernerprovelu — Mon, 17 Feb 2014 09:10:58 GMT

I experienced that when I saved the document with section access, section access didn't work.

But when I saved the document and after that I updated the document via the reload schedule (QMC), section access did work.

Hope that helps you

Regards,

Werner