Hi, I'm having strange problem with MS OLAP cubes. Here's a background:
Several cubes are created on server in other domain. I have configured access via Web (by using msolap.asp file).
Anonymous access are disallowed.
Now, I'm trying to access cubes from Excel 2002 like this.
Import External Data -> New Database Querty->OLAP Cubes->New Data Source.
I'm selecting OLE DB Provider 8.0, then Analysis Server: http://
<Ip address>, specifying username and password.
I can see OLAP database and cubes.
So, data source was created successfully.
Now, I'm trying import in in worksheet, and get this error:
"Cannot connect to cube file, 'http://
<Ip address>', file may be in use." When I press OK, I get dialog, where I can choose between OLAP Server and Cube File, AND "CUBE FILE" IS SELECTED.
Moreover, if I'm trying to import data from cube using DTS, all works perfectly. It seems Excel is the problem.
Can someone help me?