Greetings All,
I will start be stating my requirement.
I have an expense management dashboard file that I want to split by users (NTNAMES) and cost center (department). each user can see his cost center. some users can see more than one cost center and other users can see all the cost centers.
my first Idea was to use file level section access but I decided against it because cost center assignment can change from month to month although rarely happen,I don't want to tinker with QVW or excel sheets. I prefer a centralized solution.
so this is what I did.
1-in the QVW file I included the following:
//Section Access;
LOAD ACCESS,
UPPER(NTNAME) as NTNAME,
[COST CENTER]
FROM
[http://XXXX:4780/QMS/AuthTable]
(html, utf8, embedded labels, table is CostCenterAssignment);
//Section Application;
2-in Source Documents I created a new task then Reduce-->Reduce By Field Value
document name: %SourceDocumentName%_%DocumentField,NTNAME%
3- loop and Reduce: By Field Name and had selected NTNAME
4- Distribute: Loop Field in Document: I selected NTNAME and SAM Account Name and set my target to my qlikview server and user document folder.
then I went to User -> Section Access Management and I created a new section access table:
NTNAME ACESS COST CENTER
USER1 USER A
USER2 USER B
USER3 USER <ALL>
i ran the task and it generated 3 files.
file for users 1 and 2 are fine. but user 3 can't be open.
my questions:
1- is this the best was to achieve my goal?
2- Section Access; line is comment it out, if I enable it then the task fails, why?
3- the <ALL> does not seem to be working, how can I associate a user to all cost centers? is there a way I can use masking or wild character like * or %?