Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to implement section access in my qvw. but data reduction is not happening (i mean when i enter user1 only sho1 and sho9 has to show) but it is not happening . i have checked the initial reduction in document properties. what would be the problem??
Section
Access
;
LOAD
* INLINE
[
ACCESS, USERID,PASSWORD, GROUP
ADMIN,ADMIN,123,ALL
USER,USER1,123,GROUP2
USER,USER2,123,GROUP2
USER,USER3,123,GROUP2
ADMIN,USER4,123, ALL
]
;
Section
Application
;
Permisions:
LOAD
* INLINE
[
GROUP,SH01,SH05,SH08,SH09
ALL,1,1,1,1
GROUP2,1,0,0,1
]
;
to my knowledge there is no way that tabs are automatically hidden
I use conditional show of Tabs
In your case the condition would be SH01=1 etc.
If you are referring to columns sh01 and sh09 in the 'permission' Table and not the actual sheets with ID SH01/09, then here is the explanation (else just ignore it):
Section access will reduce (restrict) access to 'rows' that a user have access to, Group2 in this case.
So USER1 does not see rows that have Group='ALL', but only those rows that have Group=Group2.
Columns/Sheets have to be conditionally hidden as Rudolf rightly mentioned.
P.S. In the document properties --> opening tab, its good idea to check mark 'Strict Exclusion' option as well along with initial reduction.
Regards,
Kalpesh
it's easily, look to the qvw attached. Use your credentials to open the application.