Section Access - Binary load

Wed, 14 Aug 2013 23:05:14 GMT

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

topic Section Access - Binary load in QlikView

Section Access - Binary load