Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
My guess is that the userid running the reload in QMC does not have access to the view?
-Rob
My guess is that the userid running the reload in QMC does not have access to the view?
-Rob
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 ?
The security access would be defined in the Dynamics server