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.

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.

Introduction to Attribute Relationships in SSAS

In this article, you will learn how you can set the attribute relationships between dimensions in SSAS.

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: […]

SSAS Error: Duplicate attribute key found when processing

Learn how to resolve a duplicate value error when processing dimensions in SSAS.

Dynamically process SSAS Cube from SSIS package

Learn how you can modify an SSIS package to dynamically process SSAS cubes.

Browsing SSAS Instance over the internet

Problem Developing OLAP cubes have always been fascinating to me. Right after completing the development of a data warehouse, my next line of action often becomes setting up Analysis Services for the warehouse. Although, there are multiple client tools readily available in the market to perform some analysis on this SSAS Server, sometimes it is […]

Backing up SSAS Databases

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.

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.