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.

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

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.

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.

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

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.