Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ssquare
Contributor
Contributor

Filtered Views (MS Dynamics CRM ) in QlikView Dashboard

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 ?

 

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

-Rob

View solution in original post

3 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

-Rob

ssquare
Contributor
Contributor
Author

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 ? 

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

The security access would be defined in the Dynamics server