Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Using the below section access script, i assume user ADAM has ADMIN access and he should be able to see all the data as i represented in * and User PETER should be able to see only JCPenney.
Not sure what is happening, when i log with ADAM, i see only JCPenney.
Can someone help me on the same.
In b/w the below things are taken care
I have “Initial Data Reduction Based on Section Access” and “Strict Exclusion” Ticked.
Section Access;
LOAD * Inline [
ACCESS, USERID, PASSWORD, LINK
ADMIN, ADAM, ADAM, *
USER, PETER, PETER, WALLMART
];
Section Application;
Provider:
LOAD * Inline [
LINK
JCPENNEY
WALLMART ];
Hi avinashelite,
May be a typo, should be STAR is *; instead of START is *;
I tested this script. But it doesn't display 2 Link values for User ADAM.
Thanks settu_periasamy its a type error from my end
If * is not giving the right results try with the blank that should
something like
Section Access;
LOAD * Inline [
ACCESS, USERID, PASSWORD, LINK
ADMIN, ADAM, ADAM,
USER, PETER, PETER, WALLMART
];
Section Application;
Provider:
LOAD * Inline [
LINK
JCPENNEY
WALLMART ];
The star in section access means "all values listed in the section access table" not "all values in the data".
Have a look here for some examples on using section accessQlikView Section Access Examples
The star character in a link field in the Section Access table means: all values that appear in this field in the Section Access table only. NOT all values that appear in identically named fields in your entire data model.
There is no real wildcard-like "every value" concept in the associative data model. You'll have to create it yourself by entering an artificial value in this SA field (like "ALL") and mapping this value to all loaded field values by way of a new Section Application table.
Peter
Note that leaving the link field blank will only lead to showing all values for users with ACCESS=ADMIN (developers) in QV Desktop or QVB.exe. NOT in the AccessPoint where everyone is a USER anyway.