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
16,400 reads
Tabular Model
Adding a dynamic ColumnId to a DAX Calculated Table
Learn how a calculated value can be added to a table with the missing key values filled in.
2019-10-01
1,954 reads
Stairway to SSAS Tabular Level 6: Creating Meaningful Measures
In this sixth level of the SSAS Tabular stairway, learn how to create meaningful measures.
2025-01-01 (first published: 2019-05-01)
6,146 reads
Creating a Date Dimension in a Tabular Model
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
Securing the Tabular BI Semantic Model
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
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
MiniMax m3 and SQL Server
Comments posted to this topic are about the item MiniMax m3 and SQL Server
Making an Impression
Comments posted to this topic are about the item Making an Impression
SQL Server Vector Support I
Comments posted to this topic are about the item SQL Server Vector Support I
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers