How to Connect to an Analysis Services Database in Power BI
Learn how to work with SSAS data in Power BI in this article.
2022-07-18
1,365 reads
Analysis Services (SSAS)
Are Cubes Dead?
Is the idea of an Analysis Services cube something that is no longer relevant for modern data analysis? Steve thinks it might be.
2022-06-06
422 reads
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
2020-10-28 (first published: 2020-10-14)
3,271 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
3,755 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
5,271 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.
2022-06-22 (first published: 2020-03-11)
6,013 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
3,637 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
4,591 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
4,463 reads
Blogs
Daily Coping 18 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
New parameter in sp_DBPermissions and sp_SrvPermissions: @CopyTo
I’ve added a new parameter to my permissions scripts (well, just the main two...
Creating TAIL on Windows for Text Files
By Steve Jones
UPDATE: Article changed based on the comment from Mr. Sewell. I wrote recently about...
Forums
How to use PowerShell to set secure SA passwords for bulk servers
Comments posted to this topic are about the item How to use PowerShell to...
INSERT EXEC statement cannot be nested, the Simple Solution
Comments posted to this topic are about the item INSERT EXEC statement cannot be...
Cleaning Tables
Comments posted to this topic are about the item Cleaning Tables
Ask SSC