Defining Key Performance Indicators in a SQL Server Analysis Service Cube
KPIs are a handy option in the data warehouse because they can be used across various dimensions and hierarchies.
2019-05-31
Analysis Services (SSAS)
Monitoring and Auditing your Azure Analysis Services
Kasper de Jonge shows how you can see who connected to a AS Azure database and what queries were sent.
2019-05-31
Build an OLAP Cube in SSAS using an ADO.NET Data Provider
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,305 reads
Object Security in Analysis Services Tabular 2017
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
How to Change an Analysis Services Instance to Tabular Mode
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
3,418 reads
Format Durations in SQL Server Analysis Services
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
SQL Server Analysis Server (SSAS) KeyColumn vs NameColumn vs ValueColumn
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
Introduction to the SQL Server Analysis Services Neural Network Data Mining Algorithm
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
DAX: Topn is not a Filter
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,124 reads
Explaining the Calculations of Probability and Importance for Complex Association Rules in SSAS
The output from the Association Rules data mining model in SSAS 2012 can be difficult to understand, especially when the generated rules become more complex. In this tip we go through an example to provide a better understanding.
2014-04-17
3,252 reads
Blogs
The Azure-SSIS IR Startup Time
If you want to run SSIS packages in Azure Data Factory, you need the...
What is a container anyway?
Recently there was a thread on Twitter which established that a lot of IT...
Comparing Execution Plans
When you run a query twice, and get dramatically different run times, your first...
Forums
Statistics Profile Results
Comments posted to this topic are about the item Statistics Profile Results
Sandbox Server - Setting up AGs with 3rd party TDE/KMS
Mandate coming down from corporate is that we need to start encrypting our databases....
Row and Column wise Total in pivot table
I want row wise and column wise Total Create table #Sections (SecID int,...
Ask SSC