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.   There are two basic issues. a)   Rows are blank When opening a previously captured trace file one may not be able to see previously captured events:   b)    Events are not displayed Sometimes when one tries to…

0

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 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 a “storagemode” element and a metadata error for instantiating…


DAX over MD preview available

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/archive/2012/11/29/power-view-for-multidimensional-models-preview.aspx


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 objects (database, cube, partition, dimension etc.) manually in SQL Server Management Studio (SSMS) or Business Intelligence Development Studio (BIDS), then you get a nice progress report window that shows you all processing stages:  However, sometimes you do…


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 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=N’msolap’, @provider=N’MSOLAP.4′, @datasrc=N’servera\inst’, @catalog=N’SSASDBName’ /* For security reasons the linked server remote logins password is changed with ######## */ EXEC…

0

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 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. This applies to the SQL Server 2008 R2 and the SQL Server 2012 Powerpivot add-in for excel in…


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 2010 on Windows XP machines. When trying to open the Powerpivot window they get the following error message: “Embedded Analysis Services Engine: Could not open embedded Powerpivot data” During the investigation it turned out that the “SeIncreaseBasePriorityPrivilege” windows privilege is required for…


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 times. Quite often we get asked for the “best” information sources for the Analysis Services product. Obviously “the best” information source will depend on your level of experience with SSAS and whether you are looking from an admin, developer or troubleshooting…


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 easier to have the options together. Any additional suggestion /option/idea  is welcomed:). For disaster recovery it is  very important to have backups for SSASdatabases . In order to automate the process there are several options…


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 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/cc197552(office.12).aspx http://technet.microsoft.com/en-us/library/dd285466(office.12).aspx   But if the SSAS instance is clustered there are some points where extra information is needed.  …