Stairway to SSAS Tabular Level 8: Multiple Fact Tables and Perspectives
In this eighth step of the SSAS Tabular Stairway start to expand the model beyond one fact table.
2019-10-09
12,820 reads
In this eighth step of the SSAS Tabular Stairway start to expand the model beyond one fact table.
2019-10-09
12,820 reads
Learn how a calculated value can be added to a table with the missing key values filled in.
2019-10-01
1,701 reads
In this sixth level of the SSAS Tabular stairway, learn how to create meaningful measures.
2019-05-01
4,139 reads
As well as its multidimensional model, SQL Server Analysis Services (SSAS) now has a tabular model of database that either runs in-memory or in DirectQuery mode. The in-memory analytics engine allows the users of Excel or Power View to base reports on tabular model objects. Having shown how to handle date-based information using the Multi-dimensional model, Dennes now turns his attention on the in-memory tabular model.
2016-03-31
4,032 reads
This paper introduces the security model for tabular BI semantic models in SQL Server 2012. You will learn how to create roles, implement dynamic security, configure impersonation settings, manage roles, and choose a method for connecting to models that works in your network security context.
2012-06-07
2,623 reads
This is part of a series of new job blog posts. You can find...
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
Back in December 2019, I started presenting my session on mental health with lots...
Comments posted to this topic are about the item Managed Instance Link and SQL...
Comments posted to this topic are about the item Passing parameters to query without...
Comments posted to this topic are about the item Capturing Data Changes