Errors when add dim attribute

asked 2021-04-28T03:15:54+00:00
MushiMushi 81 Reputation points

I got situation here. So i got table PATIENTS as fact table and table RELIGION,RACES and MARITAL as dim table. The thing is on dim RELIGION design, when i add religion_desc from datasources view into attribute column i get the error like below 91943-capture.png

can someone help me what i did wrong and the solution. tq =)

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.
992 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2021-04-29T07:01:18.187+00:00
    Lukas Yu -MSFT 5,796 Reputation points

    Hi,

    This is a general error, we could not get much from this. Was there any other error information?
    Possiblly you need to exam the data integrity, see if the RELIGION table has abnormal data or other error.

    No comments