After upgrading from AS2000 to AS 2005, our clients using Excel 2000 and/or OWC2000 can't connect anymore.
The "Microsoft OLE DB Provider for Analysis Services 9.0" is installed, as well as msxml6. (I have verified it by making an .udl file, and tested the connection with success).
The following error is returned when connecting through OWC:
Error Error (Data mining): Either the user, ABC\123, does not have permission to access the referenced mining model, Lön och Resurs, or the object does not exist.
I've traced with profiler what happens at the serverside when connecting, and it seems like it's treating the datasource as a flattened rowset, (if that's any lead). After a series of Discovery Begin/Discovery End-statements the client sends this Query Begin event:Code Block
SELECT * FROM "ABC"
<Parameters xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"/>
<PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>ABC</Catalog><Timeout>30</Timeout><Content>Metadata</Content><Format>Tabular</Format><DbpropMsmdFlattened2>false</DbpropMsmdFlattened2><ExecutionMode>Prepare</ExecutionMode><LocaleIdentifier>1053</LocaleIdentifier></PropertyList>
After that this error event appears in the trace log:
Error (Data mining): Either the user, ABC\123, does not have permission to access the referenced mining model, XYZ, or the object does not exist. Error (Data mining): Either the user, ABC\123, does not have permission to access the referenced mining model, XYZ, or the object does not exist.
Hi! If I am not wrong Office 2000 was released in late 1999 and was the first Excel release that had a limited support for cubes in OLAP Services(SQL Server 7).
Have you any seen any official (MS) documentation that SSAS2005 is supported in Excel 2000?
It's hard to find any official statements whether it's supported or not. There have been some threads in this forum that says it's possible, this one for instance:
I've also seen other people (on the web) saying that they've managed to make the connecion.
If you do not find any official MS information regarding regarding support for SSAS2005 in Excel 2000 it is my guess that this combination do not work.
Excel 2003 have some limited support but between that release and Excel 2000 you also had Excel XP.
SSAS2005 do not support Excel 2003 web components except for the special version in the BIDS cube browser.
This is the information I have heard of.