Topic: SSAS
-
If you created a Tabular model using one of the preview versions (CTP, RC, …) of Analysis Services 2019, you don’t have the final structure for the Ordinal attribute that Microsoft defined in the final version of compatibility level 1500.… Read more
-
This article provides information to help choose between DAX and Power Query when a table needs to compute additional columns. Read more
-
This article describes the differences in the levels available in Azure Analysis Services (Azure AS), comparing them with the features in SQL Server Analysis Services (SSAS) on-premises. Read more
-
In 2015 I released the first version of VertiPaq Analyzer, a tool to quickly analyze the structure and data distribution of a Tabular model that can be used with Analysis Services and Power BI. Read more
-
The second edition of The Definitive Guide to DAX is now available worldwide! This blog post explains why we felt the need to rewrite the book and describes what happens behind the scenes when producing a book. Read more
-
SQLBI offers a new introductory DAX video course called Introducing DAX. This article describes which users will benefit more from this learning experience, and how to enroll in the course. Read more
-
Microsoft announced at SqlBits a very important feature for DAX: Calculation Groups. These are my first impression about the new feature and the impact it will have on Analysis Services and Power BI. Read more
-
In an Analysis Services cube you can define drillthrough actions on a cube. This feature has been working since SQL 2005 and now it will be available in both BISM Multidimensional and BISM Tabular in the next version of SQL… Read more
-
When you create a Tabular model for Analysis Services, the Culture and Collation properties are set automatically and cannot be changed by the SSDT user interface in Visual Studio. The biggest issue is the workspace database, because these properties cannot… Read more
-
This article describes the pros and cons of using SQL Server Analysis Services Tabular as the analytical engine in a service or application, based on the experience of companies who have adopted it. Read more