Browse by Tags

Tagged Content List
  • Blog Post: "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 updated version of the SSAS performance guide available. The " Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014 " document can be downloaded from MSDN via the following link: http...
  • Blog Post: 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 confusion about the recommended way for connecting to clustered instances and our supportability policy. Let’s start with the hopefully well known behavior for non-clustered SSAS instances. Stand...
  • Blog Post: you may obtain a .dstore related file system error when processing TFS cube

    Recently we have seen a number of issues where TFS cube processing failed with a file system error. The error is always referencing the decode store (.dstore) of the primary key attribute (FileSK) of the "File" dimension. The error message typically looks similar to this: Exception Message: File...
  • Blog Post: 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 information is the blog of the SQL server release services team : http://blogs.msdn.com/b/sqlreleaseservices/ . However, adding to the SP1 issue that was described in previous blog by Guillaume Fourrat...
  • Blog Post: SQL 2012 SP1 : Recommended udpate.

    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 as quickly as possible . This is announced...
  • Blog Post: 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 the inherited default SSAS instance properties. Now you might argue that this timeout should not pose a problem in the Powerpivot for Sharepoint environment. After all we are using a standalone SSAS instance...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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”...
  • Blog Post: 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...
  • Blog Post: 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 with parameterized MDX or DMX queries. Typically this would be Reporting Services queries, but other client applications can be affected as well. The Error Message: Parser: The syntax for 'XXX' is...
  • Blog Post: Data collection for troubleshooting Analysis Services issues

    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 of tools (mps reports, Support Diagnostic Platform...
  • Blog Post: Welcome to our blog!

    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 years of SSAS troubleshooting. We hope that you...
Page 1 of 1 (16 items)