CODEWITHSUNDEEP
sql-serverpowerbissasdata-analysisssas-tabular
SpanTag
SpanTag

Reputation: 1

SSAS Tabular Model - Multiple Fact tables

I have a model with three fact tables and three dimensions. Each fact table can individually relate to each dimension, this works fine. But the three dimensions are in this schema not related and therefore cannot be used with each other by the client.

I have tried many solutions, one of them was merging the DimPerson, DimDepartment and DimDistrict by Crossjoin to get "all possible combinations". But given the number of rows in each of these dimensions, the task takes too long.

Any ideas? Or am I going about this the wrong way?

Here is the schema:

Diagram

Upvotes: 0

Views: 1387

Answers (1)

MRizza
MRizza

Reputation: 71

We have lots of models like this. The most common shared dimension is Date. We filter Date on every dashboard using the dimension and all the Fact tables return the filtered values. Be sure to use the Dimension columns for filtering, not the Fact table columns. Best practice is to hide the Fact columns (PersonID, DeptID, DistrictID) so these columns are only available via the Dimensions.

Upvotes: 1

Related Questions