Relationships in SSAS Tabular Models

preview_player
Показать описание
Get my Modern Data Essentials training (for free) & start building more reliable data architectures

-----

Learn how to add relationships to your tabular model.

Title & Tags:
Adding Relationships to a Tabular Model | SQL Server Analysis Services (SSAS) Tutorial
#kahandatasolutions #sqlserveranalysisservices#dataengineering
  1. Kahan Data Solutions
  2. SQL Server
  3. SQLServer
  4. SQL
  5. MSSQL
  6. SQL Tutorial
Рекомендации по теме
Relationships in SSAS 0:01:45

Relationships in SSAS Tabular Models

4 Relationships in 0:05:03

4 Relationships in ssas tabular model

Analysis Services Part 0:02:28

Analysis Services Part 7 - Understanding Relationships in Tabular Models

Data modeling best 0:10:05

Data modeling best practices - Part 1 - in Power BI and Analysis Services

Header-detail vs star 0:27:26

Header-detail vs star schema models in Tabular and Power BI

SSAS Tutorial (7/15) 0:04:50

SSAS Tutorial (7/15) - How to Import New tables in SSAS tabular Model | Manage Relationship

SQL Server Tutorial 0:09:51

SQL Server Tutorial - One-to-many and many-to-many table relationships

Microsoft Analysis Services: 0:32:47

Microsoft Analysis Services: The Tabular Model and Why You Need It!

Create and deploy 0:03:09

Create and deploy a Tabular Cube w/ SSAS!

6 Create Measures 0:06:10

6 Create Measures ,Hide and Rename in ssas tabular model

Comparing SSAS Tabular 0:00:56

Comparing SSAS Tabular and Multidimensional model

Solve Many to 0:03:30

Solve Many to Many Joins Using Bridge Tables - Monkey Shorts Episode 038

SSAS Processing Options 0:03:58

SSAS Processing Options - Building SSAS Tabular Models [2020]

Add a Hierarchy 0:01:28

Add a Hierarchy to a SSAS Tabular Model

MSBI - SSAS 0:07:08

MSBI - SSAS - Dimension Usage - Many to Many Relationship

Getting Started with 1:02:03

Getting Started with Tabular Models

SSAS Tabular Model 0:19:25

SSAS Tabular Model end to end

Choosing to Model 0:05:02

Choosing to Model in PowerBI vs SSAS Tabular

SSAS Multidimensional vs. 1:03:07

SSAS Multidimensional vs. SSAS Tabular - Which one do I use?

SSAS Multidimensional vs. 1:03:07

SSAS Multidimensional vs. SSAS Tabular - Which one do I use?

How to create 0:09:19

How to create KPIs in SSAS Tabular Model using time intelligence function - 11

24 Hours of 0:49:42

24 Hours of PASS: Summit Preview - Create your first SSAS Tabular Model

Role playing dimensions 0:08:42

Role playing dimensions in SSAS Tabular model - 05 (SQL server analysis services)

MSBI - SSAS 0:08:10

MSBI - SSAS - Dimension Usage - Referenced Relationship

Комментарии
Автор

Get my Modern Data Essentials training (for free) & start building more reliable data architectures

KahanDataSolutions
Автор

There are tons of guides showing the world the basics of all software, this knowledge can be achieved in a few hours by self experimenting.

What we / I want to know is the hard part, which is HOW to build the model, not implement some overly used school example of a model, that has no resembling to the real world. Linking up relations from Adventure Works, with already established keys, is not the requirements from the real world, with a crazy number of joins and complications.

Where are all the advanced explanations? I've been searching the internet for days now :)

I think what the community wants are good practice examples from the real world. Take an example from my workplace:
I probably have hundreds of tables that require seven maybe eight joins to create a unique row (AX Dynamics 2012). How am I suppose to build the data model and setting up relations, with one and only one key between dimensions?