topic Re: Require Idea on using pattern in section access in QlikView

Require Idea on using pattern in section access

Wed, 03 Jul 2013 13:59:44 GMT

Hi All,

We have a requirement where users should be authorized to see specific BU's.

But in the transactions, for every order no, we get more than one BU's associated and the assignment varies from one to many.

When U1 logs in, he should be authorized to see order no - 100,102 and 103

and when U2 logs in, he should be authorized to see order no - 100,102

and when u3 logs in, he should be authorized to see order no - 102 , 103.

Kindly help us on the above requirement?

Regards

Bala

kaushiknsolanki — Wed, 03 Jul 2013 14:06:31 GMT

Hi,

The simplest way can be that you create a nother table which will be linked to the single BU's with multi BU's.

Say for example in your case the table will be.

Load * inline [

BU, MULTIBU

6J,6J,2N

6J,2N,1N,6J

2N,2N,1N,6J

2N,6J,2N

1N,1N,6J

1N,2N,1N,6J

];

Here the BU should link to the Section Access field and the MULTIBU in your database field.

Hope this is clear.

Regards,

Kaushik Solanki

Wed, 03 Jul 2013 14:15:25 GMT

Hi Kaushik,

BU's are huge in general.

and the association to ordernos are not fixed. It varies from 1 to 20.

Regards

Bala