- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Require Idea on using pattern in section access
Hi All,
We have a requirement where users should be authorized to see specific BU's.
USER | BU |
U1 | 6J |
U2 | 2N |
U3 | 1N |
But in the transactions, for every order no, we get more than one BU's associated and the assignment varies from one to many.
OrderNo# | BU |
100 | 6J,2N |
102 | 2N,1N,6J |
103 | 1N,6J |
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
- Tags:
- qlikview_scripting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Kaushik,
BU's are huge in general.
and the association to ordernos are not fixed. It varies from 1 to 20.
Regards
Bala