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

MDX (MultiDimensional Expressions) in 148 minutes

If you want to understand the fundamentals of MDX in less than 3 hours - this article can be helpful.

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

Creating Calculated Columns Using DAX

In this article, Andy Brown shares his knowledge of how to create calculated columns in tables, using Power BI as the host software (all of the formulae shown would work equally well in PowerPivot or SSAS Tabular). This article is designed to be the first in a series of articles which will show you how to master programming in DAX.

DAX Functions Nested levels

Stairway to SSAS Tabular Level 2: Installing the Components

In this level of the Stairway to SSAS Tabular you will learn how to install the platform and tools.

Stairway to SSAS Tabular Level 1: Why use Analysis Services

In this first level of the SSAS Tabular stairway, learn the benefits of implementing an SSAS solution.

Staying Current on Power BI Dashboards

Power BI Dashboards can be kept current using simple DAX formulas in your data models. Save yourself time and energy by understanding how dashboard tiles work on PowerBI.com and what can be done to set your dashboards to a current period.