topic Re: Section Access in QlikView

Section Access

tmumaw — Thu, 08 Sep 2016 11:38:11 GMT

When I am using section access what user name and password do I use for the reload from QMC?

Thanks

Re: Section Access

Clever_Anjos — Thu, 08 Sep 2016 11:42:30 GMT

It would be simpler you add the user that runs the Distribution Service to your application Section Access

Re: Section Access

tmumaw — Thu, 08 Sep 2016 11:47:04 GMT

Here is what I have. I have tried making DBO_QVREADERSVC the User on the QMC with no luck.

Section Access;
LOAD * INLINE [
ACCESS, USERID, PROFITCENTER
ADMIN, DBO_QVREADERSVC,*
ADMIN, ADMTEM, *
USER, MUMAWT, 732271
];
Section Application;
LinkTable:
LOAD * INLINE [
PROFITCENTER, PROFIT CENTER
732271, 732271
];

Re: Section Access

Clever_Anjos — Thu, 08 Sep 2016 11:48:24 GMT

Is DBO_QVREADERSVC the user that runs your Distribution Service?

Re: Section Access

tmumaw — Thu, 08 Sep 2016 11:50:53 GMT

Yes

Re: Section Access

Clever_Anjos — Thu, 08 Sep 2016 11:53:18 GMT

So uncheck "Section access" box. It should be enough.

You can make a double check, logging as DBO_QVREADERSVC and trying to open your qvw using Qlikview Desktop

Re: Section Access

Clever_Anjos — Thu, 08 Sep 2016 11:54:21 GMT

Re: Section Access

tmumaw — Thu, 08 Sep 2016 12:05:46 GMT

I removed it from the QMC and got this:

/8/2016 8:04:26 AM Error Document open call failed. The document might require username and password.9/8/2016 8:04:26 AM Error The document failed to open.9/8/2016 8:04:27 AM Error Document could not be opened9/8/2016 8:04:27 AM Error The task "Pesticide with section access" failed. Exception: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.FailedDocumentCheckoutException: Failed to check out document with path: D:\Qlikview\Pesticides\Pesticides with section access.qvw at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) --- End of inner exception stack trace --- at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) --- End of inner exception stack trace --- at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

Re: Section Access

Clever_Anjos — Thu, 08 Sep 2016 12:10:16 GMT

Let´s try one more thing

Log in as DBO_QVREADERSVC
Open your app, add a textbox with =UPPER(OSUSER())
Copy and paste this value this user into your Section Access script
Copy and paste this value into Section Access section into QMC

Re: Section Access

tmumaw — Thu, 08 Sep 2016 13:48:57 GMT

Thanks....Got it to work.

Re: Section Access

Clever_Anjos — Thu, 08 Sep 2016 13:54:50 GMT

Good to read that

Re: Section Access

tmumaw — Thu, 08 Sep 2016 14:08:50 GMT

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, PROFITCENTER
ADMIN, KENT\QVSVC, *
ADMIN, KENT\ADMTEM, *
USER, KENT\MUMAWT, 732271
];
Section Application;

LinkTable:
LOAD * INLINE [
PROFITCENTER, Profit Center
732271, 732271
];

Okay. ADMTEM should be able to see everything, and MUMAWT should only be able to see 732271 through Accesspoint. Is there a reason why when ADMTEM signs on he only sees 732271, and MUMAWT see nothing.

Thanks

Re: Section Access

Clever_Anjos — Thu, 08 Sep 2016 14:12:59 GMT

Do you have

Star is *;

in your script before the Section Access load?

Re: Section Access

Clever_Anjos — Thu, 08 Sep 2016 14:13:57 GMT

Re: Section Access

tmumaw — Thu, 08 Sep 2016 14:28:25 GMT

Here is what I have. Do I also have to put in the LinkTable *,* ?

Re: Section Access

Clever_Anjos — Thu, 08 Sep 2016 14:33:40 GMT

No, you´re supposed to use it only once

Re: Section Access

tmumaw — Thu, 08 Sep 2016 15:31:13 GMT

Here is my logic...... can you explain why I mumawt and admtem can only see 732271? I'm confused.

STAR is *;

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, PROFITCENTER
ADMIN, KENT\QVSVC, *
ADMIN, KENT\ADMTEM, *
USER, KENT\MUMAWT, 732271
];
Section Application;

LinkTable:
LOAD * INLINE [
PROFITCENTER, Profit Center
120301, 120301
129905, 129905
130331, 130331
130531, 130531
130631, 130631
130831, 130831
131531, 131531
732271, 732271
732273, 732273
732275, 732275
732276, 732276
];

Re: Section Access

Clever_Anjos — Thu, 08 Sep 2016 16:08:59 GMT

Please make a small test

STAR is *;

LinkTable:
LOAD * INLINE [
PROFITCENTER, Profit Center
120301, 120301
129905, 129905
130331, 130331
130531, 130531
130631, 130631
130831, 130831
131531, 131531
732271, 732271
732273, 732273
732275, 732275
732276, 732276
];

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, PROFITCENTER
ADMIN, KENT\QVSVC, *
ADMIN, KENT\ADMTEM, *
USER, KENT\MUMAWT, 732271
];
Section Application;

Re: Section Access

tmumaw — Thu, 08 Sep 2016 17:00:05 GMT

No difference.

Re: Section Access

Clever_Anjos — Thu, 08 Sep 2016 17:08:47 GMT

Is is possible to send a sample of your app?