topic Re: Section Access with Initial Data Reduction in QlikView

Section Access with Initial Data Reduction

Anonymous — Mon, 09 Feb 2015 13:02:36 GMT

Today we noticed a strange behaviour of our application.

We use Section Access and Initial Data Reduction Based on Section Access. Usually we store the application

from the start page, where no filter applies. We do have a trigger on open documents which selects the start page.

We save the application from a tab, where we filter the data according to the tab.

An enduser opens the application and selects another tab and he doesnot see data according to that tab

Example: Tab1 filters the data to company a

Tab2 filters the data to company b

We store the app beeing in Tab1

Enduser opens, and selects Tab2 -> No data from company b exists (data from company b exists for this user!!!)

The behaviour looks like after opening the document, the site Tab1 including the triggers herein are applied, then a macro switches to the start page. Now - or after Tab1 triggers applied - the section access and initial data reduction takes place.

I would have expected that the section access and data reduction first takes place before any other action is done.

Additionally - and for sure we had this phenomen with Qlikview V9 - after opening a document with any tab, no trigger from

that other tab were fired (after openng a document only the triggers on open document will be fired).

Can anybody confirm in which order section access and initial data reduction are executed or if this behaviour is an error

in Qlikview.

We use Qlikview 11 SR7.

Thanks for any advice!

Re: Section Access with Initial Data Reduction

Anonymous — Mon, 09 Feb 2015 13:44:03 GMT

Hello,

As far as I can follow,

1. You reload and save.

2. You open it with a user and save it on a specific tab.

If this is the case, it's normal behaviour because in the second behaviour above it already applies section access.

You need to do the reload and save on the same session.

Serhan

Re: Section Access with Initial Data Reduction

Anonymous — Mon, 09 Feb 2015 13:50:38 GMT

not exactyl

I save the app as an admin with all data

when I open the app as admin everything as expected, other roles without data reduction also have no problems

only the persons for which the section access reduces the data (our endusers) the problem occurs. they donot see any other data (company b as stated above)

If I would reload and store as end user I would agree to your statement!

Re: Section Access with Initial Data Reduction

Anonymous — Mon, 09 Feb 2015 13:58:53 GMT

Hello Rudolf,

More importantly do you do the decisive save right after reload?Try it that way please.

If you reload, save and open and save again that's different than just reloading and saving.

Serhan

Re: Section Access with Initial Data Reduction

Anonymous — Mon, 09 Feb 2015 14:04:26 GMT

I reloaded the data, all data complet. I saved the app.

I open the app as admin, all data complet

My collegue open the ap as enduser (I made an easy section access with inline with me as admin and my collegue as end user), he does not see all data.

Our real endusers have the problem that they donot see all data (using Access Point). I am able to get the same scenario with the desktop version and my easy section access solution

Re: Section Access with Initial Data Reduction

rubenmarin — Mon, 09 Feb 2015 14:04:53 GMT

Hi Rudolf,

I agreee with Serhan, if a document saved with section access and initial data reduction is opened and saved (no matter if it's a user or admin) it's saved with data reduction applied to the user who saved, and it doesn't applies any other reduction.

In example, if you have a table Users and you open and save the data, the Users table will kept only your user, so for any other user opening the document, table Users won't have his user and his related data.

Re: Section Access with Initial Data Reduction

Anonymous — Mon, 09 Feb 2015 14:08:22 GMT

Hi,

Can you paste the Section Access script and options from Document Settings--> Opening (Initial Data Reduction.. , Strict Exclusion)?

Serhan

Re: Section Access with Initial Data Reduction

Anonymous — Mon, 09 Feb 2015 14:26:29 GMT

Section access;

Load * Inline [
ACCESS, ROLLE, LEVEL, NTNAME
ADMIN, ADMIN, , ABC
ADMIN, ADMIN, , ABC
USER, RVTL, XYZ, DEF
USER, RVTL, XYZ, DEF
];

Connection to datamodel based on LEVEL.

DEF= my collegue for testing as end user

Initial data based on section access is set

strict exclusion is NOT set

When I reload and save while beeing on the start page without any filter set, everything works fine.

Important: All data is stored in the app. Admins and Management Roles does see all the data!

Re: Section Access with Initial Data Reduction

marcus_sommer — Mon, 09 Feb 2015 14:33:06 GMT

I could confirm this behaviour as "normal" - any saving from a app with section access without a reload led to a denied access for the application for all users. By us the user will be per NTNAME directly passed through, no userid or password is necessary.

- Marcus

Re: Section Access with Initial Data Reduction

Anonymous — Mon, 09 Feb 2015 14:34:39 GMT

Hi,

This is mostly because of your letting the LEVEL field empty. This works with plugin but does not work with AJAX.

1. Backup the app.

2. Try including all the levels for ADMIN with new rows or simple use * with the command STAR is *;

section access;

Load * Inline [
ACCESS, ROLLE, LEVEL, NTNAME
ADMIN, ADMIN, XYZ, ABC
ADMIN, ADMIN, ZYX, ABC
USER, RVTL, XYZ, DEF
USER, RVTL, XYZ, DEF
];

3. Check strict exclusion.

Serhan

Re: Section Access with Initial Data Reduction

Anonymous — Mon, 09 Feb 2015 15:44:55 GMT

sorry, there was a mistake while changing the text so you could not see my origin values

I used NOREDUCTION for the Admin to ensure that the data is not reduced to my admin fields

But even with NOREDUCTION the enduser doesnot see the required data, while the admin has access to all data

and does see all roles (so no reduction was made)

ACCESS, ROLLE, LEVEL, NTNAME

ADMIN, NOREDUCTION, NOREDCUTION, ABC

My only solution right now is to reload and store while beeing on the start page and distribute the app

(on server we have atechnical user with same definitions like above admin).

I knwo a work around but I would like to know why the current problem ist happening (reduce the data for specific users). So next time I can handle this in advance!

Re: Section Access with Initial Data Reduction

Anonymous — Tue, 10 Feb 2015 07:57:30 GMT

Hello Rudolf,

I still suggest using my solution with strict exclusion.

I'm pretty sure it will solve your issues.

Serhan

Re: Section Access with Initial Data Reduction

Anonymous — Tue, 10 Feb 2015 13:16:20 GMT

Sorry, but strict exclusion didnot work neither. Strict exclusion additionaly restricts the access to the app.

If any user who is not listed in section access, tries to access the app, will not get access to it.
if strict exclusion is not set, he gets access to the app, but maybe without data.

So strict exclusion has nothing to do with the problem we notice.

In my point of view the phenomen it is an asynchronization of when section access applies and when sheet triggers applies. The behaviour shows that first the sheet triggers are fired (and reduces the data) and then the section access reduces the data more. When we save from a page without trigger the app works fine.

We will save our app from start page and open an emergency ticket (because outside of normal deployment plans) to bring the new version to our servers.