Stairway to SSAS Tabular Level 6: Creating Meaningful Measures
In this sixth level of the SSAS Tabular stairway, learn how to create meaningful measures.
2019-05-01
1,825 reads
Tabular Model
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
Query Store stores dates as UTC
One of the powerful aspects of Query Store is the ability to directly query...
SpeedPASS Printing
By Andy Warren
Based on the great post and script from Wayne Sheffield I decided to try...
Accelerated Database Recovery in SQL Server 2019: Choose your own filegroup for the version store
An exciting new feature in SQL Server 2019 is Accelerated Database Recovery (ADR). Resulting...
Forums
Multiple tables created in CDC
Hello Team, I have enabled CDC for a particular database in SqlServer and enabled...
2 core machine with 4 Tempdb files
Just curious if there is a performance hit by having 4 tempdb files with...
User datareader access problem
I went to give a user (via AD account) datareader access to a number...
Ask SSC