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 […]
2019-07-10
1,410 reads
KPIs are a handy option in the data warehouse because they can be used across various dimensions and hierarchies.
2019-05-31
Kasper de Jonge shows how you can see who connected to a AS Azure database and what queries were sent.
2019-05-31
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 […]
2019-04-30
2,435 reads
Koen Verbeeck looks at how to hide tables or columns in Analysis Services Tabular 2017 for certain users so they are not able to use them in reports or query them.
2018-03-01
2,612 reads
In this post I will show a procedure to change Analysis Services instance to tabular mode in SQL Server 2016 if you accidentally setup SQL Server Analysis Services to multi-dimensional mode instead of Tabular mode
2016-11-28
5,280 reads
I have a fact table in my data warehouse that tracks durations of certain events as the total number of seconds that have passed. When users browse the cube, I’d like to show these durations formatted as time using the hh:mm:ss format. How can I do this in Analysis Services (SSAS)? - Koen Verbeeck responds.
2014-11-03
7,093 reads
What is the difference between the KeyColumn, the NameColumn, and the ValueColumn for a dimension attribute in SQL Server Analysis Services? When should you use each one for a dimension attribute? Check out this tip to learn more.
2014-07-14
10,530 reads
In data mining and machine learning circles, the neural network is one of the most difficult algorithms to explain. Fortunately, SQL Server Analysis Services allows for a simple implementation of the algorithm for data analytics. Dallas Snider explains
2014-05-19
3,590 reads
In this document I will demonstrate how using the TOPN function in a DAX query doesn’t necessarily do what you may expect.
2014-05-01
3,198 reads
By damianwidera
I have delivered a preconf on the biggest conference in Asia. The preconf was...
By Steve Jones
The summary from my fourth T-SQL Tuesday hosting for #117. This time I was...
By Ed Elliott
When you run an application using spark-dotnet, to launch the application you need to...
Has anyone seen Sp3 creating extra unexpected stats on tables after or during application...
Ask SSC