How To Install SSAS 2019
In this article we walk through the steps to install SQL Server Analysis Services for SQL Server 2019.
2020-12-22
Analysis Services (SSAS)
2020-10-28 (first published: 2020-10-14)
1,039 reads
Stairway to SSAS Tabular Level 10: Multiple Dates in Fact Table
In this level of the stairway, learn about multiple dates in fact table
2020-06-10
1,808 reads
How to Resolve a Duplicate Key Error in SSAS
Learn how you can fix the duplicated key error in SSAS without editing the source data.
2020-05-05
3,702 reads
Stairway to SSAS Tabular Level 9: Security and Roles
In the ninth level of this stairway, learn how to add security to the tabular model.
2020-03-11
2,271 reads
Implementing Drill Through Actions in SSAS
Business users get great value from SSAS cubes. In this article, learn how to create a drill-through action in an SSAS multi-dimensional model cube.
2020-03-09
2,453 reads
Introduction to Attribute Relationships in SSAS
In this article, you will learn how you can set the attribute relationships between dimensions in SSAS.
2020-02-10
2,199 reads
Analysis Services : OLEDB Error while processing in SSAS
Problem This is one of the errors that I frequently encounter while deploying or processing SSAS OLAP cubes on the client's computers or on a remote server. Recently, one of my team members also faced the same issue and so I thought to write a resolution for the issue. The error is something like this: […]
2020-02-03
2,049 reads
SSAS Error: Duplicate attribute key found when processing
Learn how to resolve a duplicate value error when processing dimensions in SSAS.
2020-01-20
5,873 reads
Dynamically process SSAS Cube from SSIS package
Learn how you can modify an SSIS package to dynamically process SSAS cubes.
2020-01-13
4,391 reads
Blogs
Logical crossroads in Azure Data Factory (IF and Filter operations)
By Rayis Imayev
(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach...
Storage Tiers What SQL Server DBAs Need to Know
“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...
Synapse Analytics and .NET for Apache Spark Example 3 - CTE()
By Ed Elliott
The next example is how to do a CTE (Common Table Expression). When creating...
Forums
Group By and JOIN within SQL Server (when dealing with multiple columns)
I have 2 tables, df1, and df2. I would like to join the two...
Select "New Customer"
Hi , Has anyone tried to do this...I'm trying to select only "new customers"...
Get local server's alias in T-SQL
Hello, I'm trying to get the server name programmatically. Even after I do this:...
Ask SSC