Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have an app with section access and reduction data in Sense Server.
If I create a task for reloading data automatically, it doesn't work.
I get an error "access denied".
In QV, if I create a reloading task with section access I can enter user and password. But in Sense Server?? Where can I enter user and pass??
I can reload data inside the app. But I can't do it in qmc.
My section access is like that:
section access;
LOAD * inline [
ACCESS, USERID,REDUCTION
USER, SERVERQLIK\admin,
USER, SERVERQLIK\user1, *
USER, SERVERQLIK\user2, 1537
USER, SERVERQLIK\user2, 1539
];
section application;
The task for reloading data in Sense server doesn't work with section access.
If I change the column ACCESS in admin user, like that:
ACCESS, USERID, REDUCTION
ADMIN, SERVERQLIK\admin,
the app will be corrupted.
If I change the column ACCESS in admin user, like that:
ACCESS, USERID, PASSWORD, REDUCTION
ADMIN, SERVERQLIK\admin, XXX,
the app will be corrupted too.
If I change the column ACCESS in admin user, like that:
ACCESS, USERID, PASSWORD
ADMIN, ADMIN, XXX,
the app will be corrupted too.
Reloading data in a scheduled task is possible with secction access in Sense Server?
Thanks a lot.
Regards
You have to add the INTERNAL\SA_SCHEDULER User to your Section Access Table. This is missing in the Documentation and will be fixed soon.
You have to add the INTERNAL\SA_SCHEDULER User to your Section Access Table. This is missing in the Documentation and will be fixed soon.
Hi, Daniel.
It works!!!
Thank you very much.
Regards.
Marcos
How to add in INTERNAL\SA_SCHEDULER and where? My section access is --
Section Access;
LOAD
'QLICKSENCESERVE\'&[USERID] AS [USERID],
Upper( [ACCESS]) as [ACCESS],
UPPER([PROJECT_ID]) as PROJECT_NAME
FROM [lib://Section Path (qlicksenceserve_administrator)/projects names with managers.xlsx]
(ooxml, embedded labels, table is Sheet2);
Section Application;
LOAD
//'QLICKSENCESERVE\'& USERID AS "USERID",
UPPER(PROJECT_ID) as PROJECT_NAME
FROM [lib://Section Path (qlicksenceserve_administrator)/projects names with managers.xlsx]
(ooxml, embedded labels, table is Sheet2);
and Table is--
KIndly guide.
Thanks
Tanushree Roy