AS_EMEA blog

Team blog of the Microsoft EMEA support team for Analysis Services

SSAS 2017 servicing model and build numbers

As you may have noticed by now the servicing model for SQL Server 2017 has changed. For details see:...

Author: Gert Christen - MSFT Date: 09/11/2018

Some information on the SessionCubesMode property

SSAS session cubes are usually generated by grouping activity in Excel pivot tables. Or by directly...

Author: Gert Christen - MSFT Date: 12/01/2017

Silent SSAS shutdown caused by writeback timeout

A number of customers using SSAS instances with writeback functionality reported frequent crashes...

Author: Gert Christen - MSFT Date: 04/04/2016

SSAS 2012 in a hardened windows 2012 environment

All the specific details are not exactly clear. But if you harden your windows 2012 server in such a...

Author: sqlas Date: 12/09/2015

uninstall of clustered SSAS instance may disable “olap redirection service”

“OLAP redirection service” is the part of SQL browser service that supports SSAS...

Author: Gert Christen - MSFT Date: 12/04/2014

"Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014" has been released

Thanks to the efforts of our US support colleagues Karan Gulati and Jon Burchel we now have an...

Author: Gert Christen - MSFT Date: 06/03/2014

New SSAS failover clustering white paper released

I'm glad to announce that we released an SSAS failover clustering whitepaper that fills in a large...

Author: Gert Christen - MSFT Date: 04/17/2014

How to connect to clustered Analysis Services instances

While clustered SSAS instances have been around for a while, we noted that there is still some...

Author: Gert Christen - MSFT Date: 01/08/2014

Recently we have seen a number of issues where TFS cube processing failed with a file system error....

Author: Gert Christen - MSFT Date: 09/11/2013

SQL Server 2012 SP1 CU3 release fixes frequent SP1 issues

We normally don't comment much on Cumulative Update releases since the best source for this type of...

Author: Gert Christen - MSFT Date: 03/26/2013

Hi, Sorry for bringing up something not strictly related to our 'cube world', but more coverage...

Author: Guillaume Fourrat [MSFT] Date: 02/21/2013

1 hour timeout for data refreshes in Powerpivot for Sharepoint

In the previous blog post I explained that we have a 1 hour timeout in Powerpivot for Excel due to...

Author: Gert Christen - MSFT Date: 01/11/2013

1 hour timeout for data imports in Powerpivot for Excel

This article describes an issue you may face when your data import in Powerpivot for Excel takes...

Author: Gert Christen - MSFT Date: 01/10/2013

SSAS Profiler Issue with SSAS 2012 – Events appear as blank rows

This problem has been fixed with SSAS 2012 SP1. Similar problems have been seen with other versions....

Author: sqlas Date: 12/20/2012

SSAS project deployment fails with error "Internal error: Invalid enumeration value. Please call customer support."

Recently I have seen this error popping up more frequently. It can occur when you modify a SSAS...

Author: Gert Christen - MSFT Date: 12/05/2012

DAX over MD preview available

Many customers have been waiting for this important feature that let's you generate power view...

Author: Gert Christen - MSFT Date: 11/30/2012

Where did my process progress events go?

Today's post is about an elusive issue that was keeping us busy for a while. When you process SSAS...

Author: Gert Christen - MSFT Date: 10/16/2012

Issues with using msolap.x provider name in linked server definition

During a recent investigation I realised that a number of people are using MSOLAP.x as the provider...

Author: sqlas Date: 09/27/2012

4 GB Limit for Powerpivot text file imports via ACE text data source driver

We have been investigating reports that large text files are not completely imported into...

Author: Gert Christen - MSFT Date: 05/03/2012

non-admin users not able to use Powerpivot for Excel 2012 on Windows XP

Recently we investigated issues where non-admin users could not open Powerpivot 2012 window in Excel...

Author: Gert Christen - MSFT Date: 04/27/2012

Where do I find Information about Analysis Services?

The amount of information on SSAS available on the web and in book stores can be overwhelming at...

Author: Gert Christen - MSFT Date: 02/28/2012

SSAS 2008 – automating Analysis services backup

Hello everybody, I believe many of you know or already use some of this methods, but I believe it is...

Author: Alexandra Ciortea Date: 02/14/2012

Project Server 2007 – Configure OLAP cube when SSAS instance is clustered

Project Server 2007 – Configure OLAP cube when SSAS instance is clustered Project server 2007...

Author: Alexandra Ciortea Date: 02/14/2012

Profiling SSAS : where have my milliseconds gone ?!?

Hi Everyone, A short post to illustrate a pattern which I only recently clarified. Ever wondered why...

Author: Guillaume Fourrat [MSFT] Date: 02/07/2012

Parser errors for parameterized queries in SSAS 2008 R2

After migrating your solution from SSAS 2005/2008 to SSAS 2008 R2 you may run into parser errors...

Author: Gert Christen - MSFT Date: 01/23/2012

Data collection for troubleshooting Analysis Services issues

Today's blog will cover the types of logs/data that we typically request when investigating Analysis...

Author: Gert Christen - MSFT Date: 01/02/2012

Welcome to our blog!

The EMEA (Europe, Middle-East, Afrika) support team for Analysis Services welcomes you to this blog....

Author: Gert Christen - MSFT Date: 01/02/2012