Tag Archives: SSAS

Another resource for Free E-Books available for Microsoft Technologies on TechNet

Leave a reply

You can download content for ASP.NET, Office, SQL Server, Windows Azure, SharePoint Server and other Microsoft technologies in e-book formats such as PDF, E-Pub or Mobi (for use on Kindle). There’s different types of books available such as References, guides, and step-by-step information.

All the e-books are free to download and new books are being posted when they become available take a look and make sure you bookmark it or add the RSS article feed to your favourite RSS Reader:

http://social.technet.microsoft.com/wiki/contents/articles/11608.e-book-gallery-for-microsoft-technologies.aspx

Connecting to SSAS 2005 from Excel 2010 Error: “XML for Analysis parser: The DbpropMsmdSubqueries property was not recognized”

Leave a reply

Issue

You may receive this error message “XML for Analysis parser: The DbpropMsmdSubqueries property was not recognized” when connecting from Excel 2010 to SSAS 2005

Cause

In most cases the machine will have had Excel 2007 previously installed and Excel 2010 has been installed side-by-side with 2007 or has been upgraded to Excel 2010

Resolution

Install the Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 R2 available in the Microsoft® SQL Server® 2008 R2 Feature Pack

Here’s an overview of what the Analysis Services OLE DB Provider is:

The Analysis Services 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 2008 R2 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 2008 R2 Analysis Services OLE DB Provider requires Microsoft Core XML Services (MSXML) 6.0, also available on this page.

The provider can be downloaded from the following links:

X86 Package (SQLServer2008_ASOLEDB10.msi)
X64 Package (SQLServer2008_ASOLEDB10.msi)

SSAS Login timeout expired when processing Cube

Leave a reply

If you receive this error when attempting to process a cube:

OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00;
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.; 08001;
SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. ; 08001.

 

Try checking the following:

  • Remote Connections are enabled on the instance your Data Source Database resides on
  • If using the server/host name in your data source connection string ensure that the named pipes protocol is enabled within SQL Server Configuration Manager > SQL Server Network Configuration on the instance your Data Source Database resides on

BIDS Helper 1.6.1 Released

Leave a reply

BIDS Helper Overview:

A Visual Studio add-in with features that extend and enhance business intelligence development functionality in SQL Server 2005, 2008, and 2008 R2 BI Development Studio (BIDS) and SQL Server 2012 SQL Server Data Tools (SSDT).

New Release

A new version of BIDS Helper (1.6.1) is available here: http://bidshelper.codeplex.com/releases/view/88092

 

Release Notes

In addition to fixing a number of bugs that beta testers reported, this release includes the following new features for Tabular models in SQL 2012:
New Features:
  • Tabular Display Folders
  • Tabular Translations Editor
  • Tabular Sync Descriptions

Fixed Issues:

  • Biml issues
  • SSIS Value cannot be null. Parameter name: adornedElement (Microsoft Visual Studio)
  • fixing bug in Tabular Actions Editor Form where you type in an invalid action name which is a reserved word like CON or which is a duplicate name to another action
  • Sync Descriptions (With Tables) Working? – fixing bug in SSAS Sync Descriptions where only the selected extra property (not all checked extra properties) are added to the description
  • Tabular: data source credentials wiped out by Tabular HideMemberIf feature – fixing bug for models with data sources with credentials, Tabular HideMemberIf wipes out the credentials
  • Edit Variable Expression in VS 2010 with BIDS Helper 2012 1.6.0 does not refresh result from expression in Task
  • Tabular drillthrough returns numbers as text