Errors when add dim attribute

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

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.
1,243 questions
0 comments

1 answer

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

    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.

    0 comments