Stairway to SSAS Tabular Level 8: Multiple Fact Tables and Perspectives
In this eighth step of the SSAS Tabular Stairway start to expand the model beyond one fact table.
2019-10-09
1,413 reads
Analysis Services (SSAS)
Adding a dynamic ColumnId to a DAX Calculated Table
Learn how a calculated value can be added to a table with the missing key values filled in.
2019-10-01
1,165 reads
Stairway to SSAS Tabular Level 7: Time Intelligence
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,696 reads
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
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,564 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
7,371 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
Blogs
SQLCover 0.5 - Fixes, smaller features and an exciting surprise
By Ed Elliott
It has been a little while but I have updated SQLCover to include a...
Switch activity in Azure Data Factory: Container with many IFs
By Rayis Imayev
(2019-October-16) Developing conditional logic of your Azure Data Factory control flow has been simplified with...
Setting Permissions for a SQL Server backup folder–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
More Network Restrictions
Comments posted to this topic are about the item More Network Restrictions, which is...
Extended Events- how to log to an SQL table?
I want to enable an Extended events session. However, I don't want it to...
Failed Executions
Curious what everyone else is doing... I've always had a daily report showing me...
Ask SSC