Time Intelligence is a common methodology in Dimensional Modeling that allows for calculations of measures based on relative dates. These include “To-Date” measures like Year to Date or Quarter to Date as well as Previous Period comparisons. Once these are created within a model, other DAX functions can be used for metrics like Year over […]
2022-10-24 (first published: 2019-07-10)
5,179 reads
In the ninth level of this stairway, learn how to add security to the tabular model.
2022-06-22 (first published: 2020-03-11)
7,151 reads
In this first level of the SSAS Tabular stairway, learn the benefits of implementing an SSAS solution.
2021-10-06 (first published: 2018-07-11)
18,919 reads
2020-10-28 (first published: 2020-10-14)
4,375 reads
In this level of the stairway, learn about multiple dates in fact table
2020-06-10
4,364 reads
In this eighth step of the SSAS Tabular Stairway start to expand the model beyond one fact table.
2019-10-09
13,223 reads
The recent blog post on PASS.org announces that Microsoft has renewed its sponsorship of SQLSaturday events. They are even, at the own discretion, sponsor individual events with more money...
2019-08-03
19 reads
In this sixth level of the SSAS Tabular stairway, learn how to create meaningful measures.
2019-05-01
4,200 reads
The fifth article in the SQL Server Analysis Services Tabular Model has been released on SQLServerCentral.com. Please start at the...
2019-02-03
161 reads
The fifth article in the SQL Server Analysis Services Tabular Model has been released on SQLServerCentral.com. Please start at the beginning article before reading this one in order to...
2019-02-03
23 reads
By Steve Jones
I get asked questions by salespeople all the time. Usually this is because a...
By Steve Jones
jouska – a hypothetical conversation that you compulsively play out in your head –...
The invitation this month for #PGSqlPhriday comes from Dian Fay. The topic is pretty...
I've noticed in one of our applications a cursor uses operation 40 and that...
Ok, need someone to talk me off the cursor ledge on this one. I...
Comments posted to this topic are about the item Better Communication Through Less Messaging
Ask SSC