Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I try to apply section access to sheet level. Please look on attached QVW. The code does not work if I load section access from excel.
The code will work if I load inline but cannot publish to upfront.
Can anybody help me on this issue?
Thank you very much in advance.
Best regards,
Dust
I used this, no upper and I replaced the field USERID with FIELD (in excel too)
Also in menù --> settimgs --> document properties --> opening I checked Initial data reduction..... and Strict Exclusion
Section Access;
SECURITY:
LOAD ACCESS,
NTNAME,
FIELD
FROM
[TermSheetAccess.xlsx]
(ooxml, embedded labels, table is Access);
Section Application;
SheetAccessMatrix:
LOAD upper(FIELD) as FIELD ,
[SHEET1],
[SHEET2]
FROM
[TermSheetAccess.xlsx]
(ooxml, embedded labels, table is Page);
I'm not able to open the doc, because of section access (access denied)
Maxgo,
Please see attached code. It's using NTName and will block out access. I comment this code. Un-comment and reload to see.
Let me know if you have any idea.
Best regards,
Dust
I used this, no upper and I replaced the field USERID with FIELD (in excel too)
Also in menù --> settimgs --> document properties --> opening I checked Initial data reduction..... and Strict Exclusion
Section Access;
SECURITY:
LOAD ACCESS,
NTNAME,
FIELD
FROM
[TermSheetAccess.xlsx]
(ooxml, embedded labels, table is Access);
Section Application;
SheetAccessMatrix:
LOAD upper(FIELD) as FIELD ,
[SHEET1],
[SHEET2]
FROM
[TermSheetAccess.xlsx]
(ooxml, embedded labels, table is Page);
Thank you - Maxgo.
Can you upload this qvw again. I cannot open this file.
Appreciate.
Hi Maxgro,
Your code is working but I cannot publish this testing qvw to upfront. I got this error:
(2015-11-17 16:06:52) Error: The document failed to open. Bad Username and password is the most likely cause of this problem.
Do you think where I need setup this username and password? Currently, I set myself as admin but I cannot publish.
Thank you very much.
Dust
I add program domain admin name to it and it can publish now.
Thank you very much -- Maxgro.