Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Session Access with Publisher has problem (Urgent)

Hi All,

     I encounted a problem with Session Access after implemented Publisher.

Background :

There are 2 fact tables in on QVW showing different data from different data sources. Now, would like to implement a security model to it and apply to 2 fact tables. Data model as attached.

PublisherSecurity.jpg

At first, when without a publisher, I implemented the above model with security and it works perfect.

But after implemented publisher and distribute the reloaded QVW (in Location A) to a specific location (Location B), the whole QVW suddenly doesn't work and prompt for sign-on in Access Point.

PublisherSecurity1.jpg

then I checked both QVW and have the following findings:

1) The file size in Location B is smaller than in Location A

2) I am using a user account on my PC, then I open the QVW in Location A, it can recognize I am User A. But if I open the Location B QVW, it recognizes me as the SYSTEM account.

3) Then I copy QVW of Location A to Location B manually, access point works fine again.

My setting on the "Opening" tab as follow:

PublisherSecurity2.jpg

For all the users with ADMIN right, i had outer join all the KEY combinations and populate to the KEY + USERID table.

So, anyone knows what's going on?

Many thanks for your help.

0 Replies