question

VishwanathamGautam-0805 avatar image
0 Votes"
VishwanathamGautam-0805 asked AlexeiStoyanovsky commented

Relationship cardinality issue

I am trying to add a relationship between two tables (dimension and fact), in my tabular model, and its one to many

I know for a fact that the "one" side of one to many relationship , the column is unique, then why is it I am getting below error ?

![111046-image.png][1]


sql-server-analysis-services
image.png (56.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AlexeiStoyanovsky avatar image
0 Votes"
AlexeiStoyanovsky answered AlexeiStoyanovsky commented

Either you've encountered a software bug (less likely), or the values are not actually unique as calculated considering the settings for the model (e.g. case sensitivity).

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks, what do you mean by "settings for the model case sensitivity) ? Yes the column in question is actually a text. Is there a setting in the visual studio that i have to change ?

0 Votes 0 ·

Case sensitivity is determined by model's collation, and Tabular models are by default case insensitive.
I'm not actually sure what the exact reason for the error is. What I'm trying to say is that it is pretty unlikely that the column in question is actually unique to the Tabular engine.

0 Votes 0 ·
LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered VishwanathamGautam-0805 commented

What have you for the data source ? You could try check unique at server side. For example in SQL , set the coloumn with unique key word.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks, source is oracle view, concatenating two text columns (tried in both oracle and dax) have checked the values are unique in the database ,

0 Votes 0 ·