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

ovonemty 51 Reputation points
2023-01-16T16:36:30.8333333+00:00

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:

User's image

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

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,231 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. PercyTang-MSFT 12,426 Reputation points Microsoft Vendor
    2023-01-17T09:38:31.8366667+00:00

    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.

    User's image

    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.

    0 comments No comments