SQL Server 2012 - SSAS Tabular Modeling
In my last post about SQL Server 2012 & the Future of BI with Dynamics AX, I mentioned that we would start with the introduction of concepts and continue to dive deeper. With that in mind, lets dive a little further into Tabular Modeling with SQL Server 2012 - SQL Server Analysis Services.
I have referenced several times, the above image, and what it shows is the current AX 2012 Analysis Services Architecture and how OLAP Cubes are consumed and made use of within an AX instance.
It's very important to understand how the out-of-the-box AX 2012 OLAP Cubes are created, and consumed, to help understand how the new offerings coming with SQL Server 2012 might be enabled by Microsoft. Keep in mind the current target for the use of SQL Server 2012 with Dynamics AX is 2013 with the release of Microsoft Dynamics AX 2012 RC2.
The purpose of the following post, was to point out how BI Analytics for AX 2012 currently works and can be used: AX 2012 - Diving into BI Analytics
With this understanding, we can move forward with looking at what's going to be new for SQL Server 2012, specifically relating to Analysis Services - Tabular Modeling. To help us understand these concepts a little better, we have a few resources already out there. First off, lets get connected to the Microsoft Published resources for this topic.
The current resource we have from Microsoft, which we can use with the download of SQL Server 2012 RC0, is the following: Tabular Modeling (Adventure Works Tutorial).
From the Tutorial:
"To better support the data analysis needs of sales and marketing teams and of senior management, you are tasked with creating a tabular model for users to analyze internet sales data in the AdventureWorksDWDenali sample database."
Taking this, there are a good bit of key concepts that you can start to understand for the use of Tabular Modeling, with a realistic scenario. The big picture parts that should have special attention applied during this exercise is around the parts that make up a Tabular Modeling Project.
Applying this understanding of SQL Server 2012 Tabular Modeling Projects, along with how OLAP Cubes are created and consumed in AX 2012 today, we can piece together how Microsoft might take advantage of this technology with Microsoft Dynamics AX 2012 RC2. Further we also can get a glimpse into PowerPivotV2 which plays a critical part in the consumption of Tabular Models from SQL Server 2012.
Finally, I will point out on this topic a book that was recommend to me, and one that I personally ordered yesterday: Applied Microsoft SQL Server 2012 Analysis Services: Tabular Modeling
The Author of this book, Teo Lachev, by far, has the most exposure and expertise on this topic right now that I can find. I expect this book to get high ratings for myself personally once I'm done with it.
Well that's all for this post, but continue to check back as we look into the future of BI with Dynamics AX, along with many, many other topics. Till Next Time!