Analysis Services (SSAS)

Stairway to SSAS Tabular

Stairway to SSAS Tabular Level 7: Time Intelligence

  • Stairway Step

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 […]


1,971 reads

Build an OLAP Cube in SSAS using an ADO.NET Data Provider

  • Article

SQL Server Analysis Services (SSAS) is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data models for business reports and client applications, such as Power BI, Excel, Reporting Services reports, and other data visualization tools. When paired with ADO.NET data providers, you can create cubes from external data […]

5 (1)


2,640 reads


T-SQL Tuesday #121: Gifts received for this year


At the end of 2019, Mala (b|t) invites us to write about the gifts we’ve...

T-SQL Tuesday Gifts (#121)


It’s that time of month. I missed last month while traveling, but I wanted...

Speakers wanted for the Richmond (VA) SQL Server Users Group – 2020


Are you a speaker in SQL Server topics? Come on out to Richmond, VA...

Read the latest Blogs


Star- and Snowflake Schema in MOLAP

By ktflash

Ahoi, the difference between Star- and Snowflake obviously makes a difference in performance for...

Is there a reason to change the service account name?

By shmulikc1204

Hi All I was asked to change the SQL service account name.  I asked...

Failed to initialize sqlcmd library with error num -2147467259. [SQLSTATE 420000

By prem.m38

Hi Guys, I am getting below error when i am trying to  send the...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers