Linked dimension is not working, while adding a measure to the KPI. It shows the error 'Suitable dimension is not available for the selected measure." Why?

Linked dimension is not working, while adding a measure to the KPI. It shows the error 'Suitable dimension is not available for the selected measure." Why?

Ensure that the details (example, table names, column names etc) defined in the 'dbmodel.xml' file matches with those in the database. For example, if a table name for a dimension in the database is in UPPERCASE, the dimension name defined in 'dbmodel.xml' file also should be in UPPERCASE.)