topic Re: Filtered Views (MS Dynamics CRM ) in QlikView Dashboard in QlikView

Filtered Views (MS Dynamics CRM ) in QlikView Dashboard

ssquare — Fri, 29 May 2020 16:48:34 GMT

I am having trouble in using Filtered Views in the QlikView Dashboard. When i use the Filtered views and run locally dashboard works fine. But, problem occurs when i publish to the QMC & it won't retrieve any results from the view . This problem doesn't occur when i use tables instead of Filtered Views

For eg., Using following table works fine

LOAD id,

name

SQL SELECT *

FROM Contact (NOLOCK);

But if i use the following Filtered View, the view doesn't execute & won't retrieve any results after publishing to QMC.

LOAD id,

name

SQL SELECT *

FROM FilteredContact (NOLOCK);

Does anyone has a fix to this or any suggestions on how to handle this ?

Re: Filtered Views (MS Dynamics CRM ) in QlikView Dashboard

rwunderlich — Fri, 29 May 2020 21:03:20 GMT

My guess is that the userid running the reload in QMC does not have access to the view?

-Rob

Re: Filtered Views (MS Dynamics CRM ) in QlikView Dashboard

ssquare — Fri, 29 May 2020 21:17:27 GMT

Rob,

Thanks for the reply ! Do you know how to check about the access ? Is that something that needs to be done on QMC ? or Server ?

Re: Filtered Views (MS Dynamics CRM ) in QlikView Dashboard

rwunderlich — Sat, 30 May 2020 16:16:26 GMT

The security access would be defined in the Dynamics server