Category Archives: Tabular

Tabular model: Not ready for prime time?

While the tabular model in SSAS makes it much easier to build cubes than the multidimensional model, I am not seeing it used as much as I expected.  One reason is if you are a BI developer and have been … Continue reading

Posted in SQLServerPedia Syndication, Tabular | 13 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

Tabular query modes: DirectQuery vs In-Memory

When using the Tabular model in SSAS, the deployment options screen offers four choices for “Query Mode”: DirectQuery, DirectQuery with In-Memory, In-Memory, In-Memory with DirectQuery.  Query Mode is used to specify the source from which query results are returned when … Continue reading

Posted in SQLServerPedia Syndication, Tabular | 3 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 | 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 | 17 Comments

SQL Server 2012: xVelocity

After SQL Server 2012 was released this past week, I saw a few mentions from Microsoft about a new feature in SQL Server 2012 called “xVelocity”.  I have been using SQL Server 2012 for months now, playing with all the new … Continue reading

Posted in SQL Server 2012, SQLServerPedia Syndication, Tabular | 2 Comments

SQL Server 2012: Tabular Models vs PowerPivot Models

In SQL Server 2012, there is a new data model, called tabular, that is part of the new feature called the Business Intelligence Semantic Model (BISM).  BISM also includes the multidimensional model (formally called the UDM). The Tabular model is based on … Continue reading

Posted in Power Pivot, SQL Server 2012, SQLServerPedia Syndication, Tabular | Leave a comment

SQL Server 2012 (“Denali”): Installing SSAS Multidimensional vs Tabular Mode

As I play with the recently released CTP3 of SQL Server 2012, code name of Denali, I wanted to point something out about installing SSAS, since there is now two “modes” you can choose from due to the the new BI Semantic Model … Continue reading

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

SQL Server 2012 (“Denali”): Details on the next version of SSAS

At the recent TechEd North America 2011 conference, details on the next version of SQL Server 2012 (codename “Denali”) were released.  Part of those details were an update on the SQL Server Analysis Services (SSAS) roadmap.  The main new feature in … Continue reading

Posted in BISM, SQL Server, SQL Server 2012, SQLServerPedia Syndication, SSAS, Tabular | 19 Comments