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.
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.
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:
For all the users with ADMIN right, i had outer join all the KEY combinations and populate to the KEY + USERID table.