We normally don't comment much on Cumulative Update releases since the best source for this type of information is the blog of the SQL server release services team : http://blogs.msdn.com/b/sqlreleaseservices/ . However, adding to the SP1 issue that...

Hi, Sorry for bringing up something not strictly related to our 'cube world', but more coverage can't hurt here : If you have installed SQL Server 2012 Service Pack 1, or if you plan to, it is highly recommended to apply a specific subsequent update...

In the previous blog post I explained that we have a 1 hour timeout in Powerpivot for Excel due to the inherited default SSAS instance properties. Now you might argue that this timeout should not pose a problem in the Powerpivot for Sharepoint environment...

This article describes an issue you may face when your data import in Powerpivot for Excel takes longer than 1 hour. Typically you should not run into this type of issue because Powerpivot for Excel was designed as an interactive tool with moderate amounts...

Recently I have seen this error popping up more frequently. It can occur when you modify a SSAS project in Visual Studio 2008 (or BIDS 2008) and try to deploy it against an existing SSAS 2008 R2 database. The full error message will usually also mention...

Many customers have been waiting for this important feature that let's you generate power view reports from multi-dimensional Analysis Services instances. Here you can get details and download the bits for testing: http://blogs.msdn.com/b/analysisservices...

Today's post is about an elusive issue that was keeping us busy for a while. When you process SSAS objects (database, cube, partition, dimension etc.) manually in SQL Server Management Studio (SSMS) or Business Intelligence Development Studio (BIDS...

During a recent investigation I realised that a number of people are using MSOLAP.x as the provider name for a linked server e.g. MSOLAP.4 when creating a linked server... e.g. EXEC master . dbo . sp_addlinkedserver @server = N'lsname' , @srvproduct...

We have been investigating reports that large text files are not completely imported into Powerpivot. And indeed a thorough investigation showed two unexpected things happening. The text import is cut off at 4 GB Import is shown as successful...

Recently we investigated issues where non-admin users could not open Powerpivot 2012 window in Excel 2010 on Windows XP machines. When trying to open the Powerpivot window they get the following error message: “Embedded Analysis Services Engine...

The amount of information on SSAS available on the web and in book stores can be overwhelming at times. Quite often we get asked for the "best" information sources for the Analysis Services product. Obviously "the best" information source will depend...

Hello everybody, I believe many of you know or already use some of this methods, but I believe it is easier to have the options together. Any additional suggestion /option/idea is welcomed:). For disaster recovery it is very important to have backups...

Project Server 2007 – Configure OLAP cube when SSAS instance is clustered Project server 2007 has two very good articles to configure OLAP cube SSAS 2005 and SSAS 2008 for Project Server 2007. http://technet.microsoft.com/en-us/library...

Hi Everyone, A short post to illustrate a pattern which I only recently clarified. Ever wondered why your "time" columns in a SSAS profiler trace had all .000 values for milliseconds (therefore giving you only a precision level of a second) ? ...

After migrating your solution from SSAS 2005/2008 to SSAS 2008 R2 you may run into parser errors with parameterized MDX or DMX queries. Typically this would be Reporting Services queries, but other client applications can be affected as well. The...

Today's blog will cover the types of logs/data that we typically request when investigating Analysis Services issues. Most of these logs (excluding dumps) are easily readable and you can use them for your own investigation. MS support uses a number...

The EMEA (Europe, Middle-East, Afrika) support team for Analysis Services welcomes you to this blog. We are a small and experienced team of Analysis Services specialists. Through this blog we will share some of our experience gathered from many...