topic All posible values with '*' in Section Access in QlikView

All posible values with '*' in Section Access

Thu, 23 Feb 2012 09:52:54 GMT

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,

All posible values with '*' in Section Access

lescoulm — Wed, 04 Apr 2012 09:20:11 GMT

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.

Re: All posible values with '*' in Section Access

raajeshn — Mon, 06 Aug 2012 10:39:41 GMT

Hi All,

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

Thanks & Regards,

Raajesh N

Re: All posible values with '*' in Section Access

lescoulm — Mon, 06 Aug 2012 14:02:26 GMT

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>