I am trying to put together a Dashboard using VS2012 in c#. I want to connect to my Cube in order to retrieve the Data to be displayed in Graphs.
I have the following connection:
AdomdConnection myconnect = new AdomdConnection(@"provider=msolap.5;initial catalog=Cube;datasource=xx.xx.xx.xx;UID=MyUser;PWD=MyPassword;Timeout=10000;connect timeout=1000");
When I replace xx.xx.xx.xx (in AWS) by "localhost" I can connect and run MDX Queries otherwise I get the Element error.
In some forums, some people advise to increase the timeout delay but it doesn't seem to make any difference. The error message comes back straight after calling Open() whatever value I use.