Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a qlikview document with section access
Fact table is having data something like below columns
employee,
country,
department,
region,
tartgetstatus
period,
designation
section access table with auth key as combination of country_department_region as authkey
I can able to control the access successfully by giving appropriate country level,department level and region level access.
I am fine upto here...
problem is
Now i have another table called 'Controltable' with following columns.
country,
period,
showdata
so i want to show targetstatus first to some of the employee but not to some of the employee.
in the above fact table 'designation' column holds value 1 or 0. 1 being management, 0 beeing workingemployees. this is static.
using the 'showdata' column in the controltable, i want to control.
controltable:
country,period,showdata
usa,2015,0
usa,2014,1
uk,2014,1
canada,2014,1
showdata column here is going to be dynamic, i need to change it 1 or 0 based on the response from management.
since showdata for usa 2015 is 0, only the management will see 2015 data but not the rest of the employees.
how can i implement this in my existing section access.
Thanks
Gautham
Hi Gautham,
add department also in control table by that you can manage the department wise section access
regards
saikat
You need to merge the control table with the section access table. That will mean including the period and showdata fields in the authkey as well.
Thanks gwassenaar
Oh! then the Auth table becomes bigger because of the multiple field combination?
Can i use autonumber for auth keys combination?
Can i drop it at the end since its not going to be used in the front end?
Gautham
Yes, the table will become larger.
Yes, you can use autonumber.
The section access table doesn't need to be dropped. It won't be part of the data model after the script is executed. You won't see a section access table in the Table Viewer.
How about the Auth key? can i drop that fields if it consumes more memory?
No, that's used to restrict the access. If you drop it then everybody has access to all the data again.
Say my section access table is like below:
User,country,department,region,period,Showdata
A,US,IT,North,2015,1
if i have 10 years of data, then i need to add 10 rows for each user per combination???
how can i tackle for upcoming years?
Is there any best way?
if i have 10 years of data, then i need to add 10 rows for each user per combination???
Yes.
how can i tackle for upcoming years?
Add them when you need them. Perhaps maintaining the section access table in an excel file works for you.
instead of adding all periods for each user,
controltable:
country,period,showdata
usa,2015,0
usa,2014,1
uk,2014,1
canada,2014,1
section access excel
user,country, office,region
a,usa,hroffice,central
b,canada,xyzoffice,north
can i create section access table by adding all periods for each user without manually? by some means of joins?
can you help me to do that?
so that section access table inside dashboard script will be automically created like this below???
user,country,office,region,period
a,usa,hroffice,central,2015
a,usa,hroffice,central,2014
b,canada,xyzoffice,north,2014