Hi,
I have to implement a few of the security and the reduction features.
1. Sheet level security. Based on the OsUser, I need to restrict the sheets. That I have done without using section access on the conditional section of the sheet by using the expression
count({<username = {'$(vCurrentUser)'}, sheetname={'Sheet_Wholesale'}>}sheetname) >0
This is based on a table
load * inline
[
username, sheetname
abc.xy,Sheet_Retail
efg.yz,Sheet_Wholesale
hij.za,Sheet_Deliveries
klm.ab,Sheet_Salesrep
]
This is all working fine. But I would like to implement the same using Section access.
2. Reduction. I need to use the NTNAME for reduction. e.g. There is a field Sale Year, I need to reduce based on this column. But please note we have document1.qvw which is an extract and we binary load into document2.qvw. And this reduction needs to be implemented on document2.qvw.
3. Omit. Certain fields need to be restricted from being shown.
Does someone have an example that covers Sheet level security, Reduction and Omit, based on NTNAME and in a document that is loaded as a binary load?
Thanks,
Ram
