Category Archives: SSAS

Prevent wiping out of SSAS partitions

There have been a few times when I have created SSAS partitions outside of BIDS using script code in an SSiS package, then later made a change in BIDS and deployed the cube, wiping out those partitions (since they did … Continue reading

Posted in SQLServerPedia Syndication, SSAS | 1 Comment

Visual Studio 2012 does not support BI

UPDATE 3/6/13: VS 2012 now supports BI!  Check out Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2012 In the same vein as my post Watch out, Visual Studio 2010 does not support BI, Visual Studio 2012 does … Continue reading

Posted in Business Intelligence, SQL Server, SQLServerPedia Syndication, SSAS, SSDT/Juneau, SSIS, SSRS, Visual Studio 2010, Visual Studio 2012 | 34 Comments

Comparing DirectQuery and ROLAP for real-time access

In the multidimensional model in SSAS, there is a storage mode called relational OLAP (ROLAP), which is the multidimensional solution for allowing real-time access to relational data sources and uses MDX queries.  In the tabular model in SSAS, the solution … Continue reading

Posted in SQLServerPedia Syndication, SSAS, Tabular | 2 Comments

What happens when a SSAS Tabular model exceeds memory?

If you are using the Tabular model in SSAS, it will use the xVelocity technology to load your entire database in memory (greatly compressing the database).  So what happens if your database is too big to fit in memory?  You … Continue reading

Posted in SQLServerPedia Syndication, SSAS, Tabular | 3 Comments

Being careful in SSAS to not make a cube/dimension unprocessed

A big headache in SSAS, especially when dealing with a large cube, is making a change that when deployed, causes a cube to become unprocessed, forcing you to do a full process so the cube is usable.  Nothing is worse … Continue reading

Posted in SQLServerPedia Syndication, SSAS | 2 Comments

SSAS File System Error

I received this error the other day when trying to process a particular SSAS cube: Error      18           File system error: The following file is corrupted: Physical file: file:///\\%3f\E:\SQL\OLAP\Data\Options”>\\?\E:\SQL\OLAP\Data\Options BI QA.0.db\Dim Date.0.dim\1.Year No.bstore. Logical file .                                0              0 I also could … Continue reading

Posted in SQLServerPedia Syndication, SSAS | 7 Comments

SSAS development quick tip

When creating a new cube in SSAS, you are frequently making changes that cause the whole cube to reprocess when you use the “Deploy” option (such as structure changes or aggregation design changes).  This means a lot of sitting around … Continue reading

Posted in Quick Tip, SQLServerPedia Syndication, SSAS | 1 Comment

SQL Server 2012: Multidimensional vs tabular

To expand on what I talked about in SQL Server 2012 (“Denali”): Details on the next version of SSAS, there is a new data model called Tabular.  So when you are creating a new project, which model should you use, Multidimensional … Continue reading

Posted in Data warehouse, SQL Server 2012, SQLServerPedia Syndication, SSAS, Tabular | 18 Comments

SQL Server 2012: SSAS enhancements

My previous blog, SQL Server 2012 (“Denali”): Details on the next version of SSAS, talked about the major new feature in SSAS, which is BISM.  But what other changes are there?  Well, not much.  Here are details on the few changes … Continue reading

Posted in SQL Server 2012, SQLServerPedia Syndication, SSAS | 1 Comment

BIDS Helper 1.6 for SQL Server 2012 released

BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server 2008 BI Development Studio, and now supports SQL Server 2012 (including tabular mode) and Visual Studio 2010 (SSDT).  Version 1.6 … Continue reading

Posted in SQLServerPedia Syndication, SSAS, SSIS, SSRS, Tools, Visual Studio 2008, Visual Studio 2010 | 1 Comment