data is not reduced based on section access

[ali_hijazi]

Hello attached is a sample document with section access and a table that contains 2 columns user and brand

each user has the brands that (s)he can see

you can access the document via the following credentials:

userName: ABC\FEID

password: pass

ABC\FEIS is supposed to see only ADOLF,CARL

upon selection of the user ABC\FEID the white data will be ADOLf, CARL and the rest of the brands is gray

however I don't want that user ABC\FEID to see the rest of the user brand combinations

[gandalfgray]

Hi

Check "Initial Data Reduction Based on Section Access" in Document Properties -> Opening!

hth/gg

[ali_hijazi]

this doesn't help

the data will be reduced once ABC\FEID opens th document OK but if another user opens the document the data will stay reduced for the above ABC\FEID and not the new user

I already tried this

No this doesn't help

[gandalfgray]

Hi Ali

well you must have  that setting checked for it to work.

There must be some other errors.

If you publish a version here where we can see the complete script I may be able to help.

regards

/gg

[Miguel_Angel_Baeyens]

Hi,

What Gandalf says is correct. And what happens to you is exactly how QlikView is expected to work. When you open a document with section access reduction, the reduction takes place in the document, so in other words, QlikView removes from memory all the records that are not associated with the reduction field in the section access.

However, when the document is published in a Server, the physical file is not changed, but the copy in memory is, so virtually every user has his recordset according to the section access. Or said in other words, when the user opens the document using his user id and password, the copy that is loaded into memory is reduced, but the file is available for the next user with all the records.

There is no way to reduce some data and keep the reduced data for the next user. Perhaps using the same document replicated (something similar to what Publisher does)...

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[magavi_framsteg]

You must log in with an ADMIN user and tick the boxes which Saruman's enemy stated.

Then save the document.

Then you can try and close the doc and reopen it logging in as ABC\FEID.

This should reduce ok.

Then close the doc, reopen it and try to logon as a different user.

It should reduce ok.

If it does not, something is wrong in your data model/secion access.

Each user in section access shall be associated with the actual data model.

[Miguel_Angel_Baeyens]

Hi Magnus,

Just a note: if the users are the reduction field, and they are exclusive, when USER1 opens and reduces, it may leave no records associated with any other user. So any other user with USER ACCESS will not be granted access, because they don't have any actual value associated in the data model. And if USER2 is granted access, the information will be reduced based on what is kept from USER1, so USER2 might not see his complete data set.

Only ADMIN users will be able to open the document, reload it, and leave it for the next user.

Hope that makes sense.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[magavi_framsteg]

Miguel, yes you are correct.

This will be the case when using loop and reduce on the user field.

Instead you can use the dynamic distribute without reducing. And instead distribute to the user field.

[magavi_framsteg]

Miguel, how do you add your signature automatically?

I can't find it anywhere on this site.

[Miguel_Angel_Baeyens]

Hi Magnus,

I don't. I have a file and just copy/paste the text. We discussed that just after moving, and Jason taught us to do so, because there is actually no setting or preference to store the signature. Good point for the next version!

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica