Smart View with HFM (both are same versions,188.8.131.52)
We are in production now, when the users are refreshing the Smart View sheet for production, it is pointing to UAT.
We suggested them to delete the UAT connection and connect to production and refresh the sheet. They are getting #No Connection.
We have deleted all links and created for data source (connection) for Production alone, but we are getting the same error, #No Connection (before deleting it is showing UAT data)
We have checked the link in Independant Provider Connections and Default URL(which is in Options-->Ad Hoc tab) , both are Production links.
Note: A user is able to access the production link correctly. But this problem is for remaining users. The application name for UAT and Production are same. but both are in different servers.
We have created a smart view sheet for ad hoc analysis, which is throwing #No Connection Error, to check for the issue is with link or sheet, we have done below:
We created a new Smart View sheet and gave few C1 Dimension( since our reporting is done based on C1 dimension),
For Eg: the following values are given for all dimensions,
and remaining dimensions in POV. When we refresh the sheet, it connecting to Production link but giving some junk values. (We have checked these values by creating a grid in HFM Application.)