Linked dimension is not working and the error is displayed as "suitable dimension is not available for the selected measure" when we try to add a measure into the KPI. What is the resolution for this?

• Related Articles

• 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 ...

• Error - "dimension is not available for selected measure"

  This error is usually encountered when either the table name or column name defined in the dbmodel differs with the way it is defined in the database. For e.g. table name in the dbmodel is defined as dim_product_stockage, whereas in the table it was ...

• Why do I get the error message 'Dimension is not available for selected measure'?

  If the table name or the column name defined in the data model differs with the way it is defined in the database, then the error occurs. For Example, If the table name in data model is dim_product_stockage and the name given in the table is ...

• I get a pop-up exception "dimension is not available for selected measure". What is the reason and how to resolve?

  This message is is usually displayed when either the table name or column name defined in the data model differs with the way it is defined in the database. For e.g. table name in the datamodel must be defined as 'dim_product_stockage', whereas in ...

• Filters are not displayed, when I add dimension attribute to the Filter section of an existing KPI. Why?

  One of the reasons could be You have to remove the spaces from Attribute parameter name for the filter section to work properly.