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
9,604 reads
Learn how to resolve a duplicate value error when processing dimensions in SSAS.
2020-01-20
23,128 reads
Learn how you can modify an SSIS package to dynamically process SSAS cubes.
2020-01-13
10,852 reads
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 […]
2019-12-31
8,881 reads
2019-10-21
687 reads
In this eighth step of the SSAS Tabular Stairway start to expand the model beyond one fact table.
2019-10-09
15,935 reads
Learn how a calculated value can be added to a table with the missing key values filled in.
2019-10-01
1,873 reads
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 […]
2022-10-24 (first published: 2019-07-10)
5,924 reads
KPIs are a handy option in the data warehouse because they can be used across various dimensions and hierarchies.
2019-05-31
Kasper de Jonge shows how you can see who connected to a AS Azure database and what queries were sent.
2019-05-31
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
By Kevin3NF
Parts 1, 2 and 3 got you to the (SQL) engine room. Now we...
hi, just to get this part out of the way, if my intended target...
Hey All, I'm looking for a free ERD tool. Does anyone have any recommendations?...
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
The new vector datatype in SQL Server 2025 requires a number dimension parameter. What is the maximum number of dimensions supported?
See possible answers