Composite keys in SSAS Tabular - by RichardLees

Status : 

 


4
0
Sign in
to vote
ID 3144082 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 11/13/2017 2:19:30 PM
Access Restriction Public

Description

I would like to see SSAS Tabular support tabular primary keys. Currently, any primary key must be a single column. This is very limiting and means that either Tabular can't be used, or data warehouse schemas must be rewritten with surrogate keys. Rewriting data is not optimal, and leads to performance and lag issues. See http://richardlees.blogspot.com.au/2017/11/multidimensional-and-tabular-compared.html for more information.
Sign in to post a comment.
Posted by yger on 11/16/2017 at 11:22 PM
This feature would be a big benefit, make the life of BI developers a lot easier, would save a lot of money.