Tuesday, July 18, 2023

SSAS - Performance issue with Date Dimension

When we dont have a proper date dimenison then SSAS wil give performance issue(s). Performance issue mostly come when we directly use date or datetime column for relationship between dimension & Fact table.

The best solution for overcome this performance issue is:

1) We must have a dateId column in our date dimension in our cube.
2) Our fact table should contain all key columns including DateId & respective fact values.
3) DateId will be key column for date dimension.
4) In this way, when we put filter on date range or any other date related filter, data retrieval will be fast.
5) We can indexing in dateId column if required for faster retrieval of data.

No comments:

Post a Comment