![]() ![]() Yes, they take time to learn, but can produce excellent results. And I'll freely admit to being partial to SSAS OLAP and MDX. I've seen it grow into a mature, full-blown solution for creating analytic databases. I've been using SSAS for many years now to create OLAP databases for clients. Depending on how much (or how little) you've used either approach, the results might surprise you. In this article, I'll take several tasks and functionality that database developers often need to implement, and I'll compare the approaches using SSAS OLAP and SSAS Tabular. Some believe that the new Tabular model is easier to use than SSAS OLAP. ![]() The latter contains a somewhat different set of tools than SSAS OLAP and a new supporting language (DAX). SQL Server 2012 contains a new BI semantic model that allows developers to create analytic databases either by using OLAP or by using a new Tabular model. SSAS OLAP offers many powerful features, although some developers view the learning curve of OLAP (and its supporting language, MDX) as very steep. For over a decade, many Microsoft database developers have used SQL Server Analysis Services (SSAS) OLAP to create database cubes for advanced business analytics.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |