We have created a Multidimentional Datasource of SQL Server analysis Services.
I have followed the Denodo article - https://community.denodo.com/kb/view/document/SSAS%20as%20data%20source?category=Data+Sources (have also followed all the Previous considerations listed)
While trying to "Create Base view" I am getting the error as "Unable to connect to the multidimensional server:
org.olap4j.OlapException: This connection encountered an exception while executing a query."
I have checked on the issue and it seems to come when there is an access issue but I have checked the access of the account used to connect and the account has access in denodo and SQL server both. Can you please help on what we might be missing here?