I have been able to connect to a cube in Excel using MSOLAP.5 provider and it works perfectly. I have been trying to connect to the same cube using the datasource SQL Server Analylsis Services but I am getting the error:
unable to connect
we encountered an error while trying to connect
details: "AnalysisServices: object reference not set to an instance of an object
Can anyone suggest a solution ?
I am looking to do the same thing. I think this is the only way I can connect to NICE InContact data, but it does not currently work. Would love to know if anyone was able to find a workaround.