Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 hrobertsonqv
		
			hrobertsonqv
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I have added the following Section Access under Hidden Script ( I have removed filenames here), but after reload, all users can see all datasets. This has worked before in another QV document but not this time.
Under Settings > Document Properties > Server, the 'Filter AccessPoint Document List Based on Section Access' is also ticked.
Is there something else I need to do to get this section access to work correctly?
//Security
SECTION ACCESS;
LOAD NTNAME, 
     [ACCESS]
FROM
[\\XXXXXXXXXXXX.xls]
(biff, embedded labels, table is [Step 1$]);
SECTION APPLICATION;
Star is *;
LOAD NTNAME, 
     [Business Unit]
FROM
[\\XXXXXXXXXXX.xls]
(biff, embedded labels, table is [Step 2$]);
 
					
				
		
 rajni_batra
		
			rajni_batra
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Document properties> Opening Sheet > Initial data reduction based on section access(check this option)
Hope this helps!!! 
 
					
				
		
 rajni_batra
		
			rajni_batra
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Document properties> Opening Sheet > Initial data reduction based on section access(check this option)
Hope this helps!!! 
 hrobertsonqv
		
			hrobertsonqv
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Many thanks - that has done the trick!!
 hrobertsonqv
		
			hrobertsonqv
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Many thanks - that has done the trick!!
 hrobertsonqv
		
			hrobertsonqv
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Many thanks - that has done the trick!!
 hrobertsonqv
		
			hrobertsonqv
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Many thansk for your prompt response
 
					
				
		
 rajni_batra
		
			rajni_batra
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		most welcome... 
