Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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$]);
Document properties> Opening Sheet > Initial data reduction based on section access(check this option)
Hope this helps!!!
Document properties> Opening Sheet > Initial data reduction based on section access(check this option)
Hope this helps!!!
Many thanks - that has done the trick!!
Many thanks - that has done the trick!!
Many thanks - that has done the trick!!
Many thansk for your prompt response
most welcome...