Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

ggerber
New Contributor II

Reduce and Distribute a document via Publisher

Hi

Currently I use publisher to reload ad distribute my models.

I use the Loop Field in Document to add AD security to the model.  This works 100%.  The field I use is QV User which sits in a table that is not link to any data in the model.

Now I want to reduce the model per company (Field "COMPANY" is link to rest of data in the models) by using Reduce by Field option.  This works 100%.

The problem I sit with is that after the model is reduced to 5 smaller models, users see all 5 models, but can only access 1 model (the one to which they have access).  I would like that the user can only see the model to which he have access and not all 5. 

Any suggestions?

1 Solution

Accepted Solutions
Employee
Employee

Re: Reduce and Distribute a document via Publisher

I would create a link table

LOAD

* INLINE [

    User, Comapny

    Bill, A

    Bob, B

    Steve, C

    Sam, D

    John, E

]
;

Now you have the users linked to the Comapnies.

Bill

2 Replies
kouroshkarimi
Contributor III

Re: Reduce and Distribute a document via Publisher

If you publish the models to seperate folders on the server you could set the AD rights for each folder individually within the folder properties (set up a group in server manager, makes it easier). That is what I do to stop one legal entity seeing documents from the other.

Employee
Employee

Re: Reduce and Distribute a document via Publisher

I would create a link table

LOAD

* INLINE [

    User, Comapny

    Bill, A

    Bob, B

    Steve, C

    Sam, D

    John, E

]
;

Now you have the users linked to the Comapnies.

Bill

Community Browser