I have to install the following 2 components on the end user terminal for them to be able to connect to an Analysis Services 2005 cube using the OWC report.
Microsoft Core XML Services (MSXML) 6.0 Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB
Is there anything I can do on the server side to avoid this?
Well I might not be using all posible options, but here's why:
1- Users are used to (OWC) Pivot Table 2- I do not like the format in general 2- Can't control the column width 3- Prompts everytime you run a query over 500 rows 4- slower performance
You should not need Microsoft Core XML Services (MSXML) 6.0. However, you need Office Web Components (Office 2000, XP or 2003) installed on the end user machines.
Few things to improve performance of Olap Reports:
1) Increase the Maximum Rows setting from 500. Admin > Settings > Olap Report tab > Maximum Rows 2) Enable paging. 3) Use top 100 bottom or 100 feature if this fits your requirement. 4) If you are using the expand mode try using the drilldown mode instead.
The users I tested so far are running windows XP or 2003.
The issue with Microsoft Core XML Services (MSXML) 6.0 is that you need it in order to intall "Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB" the setup requires it. (I just sent a print screen of the error to support)
Once the provider is installed you can then remove MSXML 6.0 without causing any problem. Nevertheless, The OLE DB provider has to be installed on the client.
If you would like to use a client tool for use with SSAS2005 with OWC or Excel Addin etc you have to use:
Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider The Analysis Services 9.0 OLE DB Provider is a COM component that software developers can use to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2005 Analysis Services. This provider implements both the OLE DB specification and the specification’s extensions for online analytical processing (OLAP) and data mining.
Note: Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider requires Microsoft Core XML Services (MSXML) 6.0, also available on this page.
Report Portal
Requires Software on Client PC
Posted - 09/12/2006 : 12:28:21
