Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

All posible values with '*' in Section Access

Hi Experts,

We are using Section Access (option --> Initial Data Reduction based in Section Access & strict exclusion) to reduce the data Users can access when opening our HR document in QV by Organizational Unit. We have defined ADMIN users that have access to ALL posible OrgUnits in the model and USER users that can access just to specified OrgUnits.

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, UNIDADO2_ID

ADMIN, DOMAIN\ADMIN,

USER, DOMAIN\USER, 10000102

];

Section Application;

When opening the document in QV Desktop it works perfectly but when opening the document thru Access Point, the ADMIN users have no access, since users with ADMIN access are logged as USER in the access Point. The blank values in OrgUnit field is not valid for a USER.

How can we indicate int he section access that admin users have access to ALL posibles values of OrgUnit without using the blank value ¿? We tried the wildcard '*' but it means just the 'listed values in the section access'. Since new OrgUnits can be created daily and we can have more than 3000 values for them, we need a solution that dinamically sees the new OrgUnits created or than reduce to ALL posible values of a field.

Thanks in advance for your help,

3 Replies
lescoulm
Contributor
Contributor

Hi everybody,

Do you have ideas to resolve this question ?

I have exactly the same problem and I don't know how to resolve It.

I'm using QlikView V10, maybe it changes in V11 ?

Regards.

raajeshn
Partner - Creator
Partner - Creator

Hi All,

I am facing the same problem in Version 11 also - any help is highly appreciated.

Thanks & Regards,

Raajesh N

lescoulm
Contributor
Contributor

Je serai absent(e) à partir du 16/07/2012 de retour le 16/08/2012.

Je répondrai à votre message dès mon retour.

Pour toute question concernant QlikView, veuillez contacter Laurent

Vallerie.



<table>
<tr><td>
Pensez à l'environnement : avez-vous besoin d'imprimer ce message ?</td></tr>
<tr><td>
Think environment : Do you need to print message ?</td></tr>
<tr><td>
.</td></tr>
<tr><td>
Ce courrier électronique, et éventuellement ses pièces jointes, peuvent contenir des informations confidentielles et/ou personnelles et a été envoyé uniquement à l'usage de la personne ou de l'entité citée ci-dessus. Si vous receviez ce courrier électronique par erreur, merci de bien vouloir en avertir l'expéditeur immédiatement par la réponse en retour à ce courrier et effacer l'original et détruire toute copie enregistrée dans un ordinateur, ou imprimée ou encore sauvegardée sur un disque . Toute revue, retransmission ou toute autre forme d'utilisation de ce courrier électronique par toute autre personne que le destinataire prévue est strictement interdite.</td></tr>
<tr><td>
L'internet ne permettant pas d'assurer l'intégrité de ce message, l'expéditeur décline toute responsabilité au cas où il aurait été intercepté ou modifié par quiconque.</td></tr>
<tr><td>
This e-mail and possibly any attachment may contain confidential and/or privileged information and is intended only for the use of the individual or entity named above. If you have received it in error, please advise the sender immediately by reply e-mail and delete and destroy all copies including all copies stored in the recipient's computer, printed or saved to disk. . Any review , retransmission, or further use of this e-mail by persons or entities other than the intended recipient is strictly prohibited.</td></tr>
<tr><td>
Because of the nature of the Internet the sender is not in a position to ensure the integrity of this message, therefore the sender disclaims any liability whatsoever, in the event of this message having been intercepted and/or altered.</td></tr>
</table>