I select cardinality * : * but VS just adds it as * : 1 ? Why?

Question

Why is it that if I select * : * then the Manage Relationships UI just adds it as "Many to One (*:1)" I have tested many many times and it will change my : cardinality to *:1 Why? See below:

Is this a bug?? its a very old product, how come this was never fixed?

Answer 1

Hi @ovonemty

I went looking for previous additions in SQL Server Analysis Services, of which SQL Server 2019 Analysis Services officially includes the following two updates.

I think the issue you're having might be related to compatibility.

For more information on version updates, you can refer to this link.

https://learn.microsoft.com/en-us/analysis-services/what-s-new-in-sql-server-analysis-services?view=asallproducts-allversions

Best regards,

Percy Tang

---

If the answer is the right solution, please click "Accept Answer". If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.