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 defined in the upper case as DIM_PRODUCT_STOCKAGE. It is mandatory to specify the table names in upper case in ARC DB Model.
Related Articles
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 ...
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 ...
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?
Ensure that the table names, column names etc. that is defined in the data model matches case with the way it is created in the database. (E.g. If the table name for a given dimension is created in the UPPER CASE in the database then, the dimension ...
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 ...
Facing problems with KPIs where time is selected as dimension.
Try updating 'Day' measure definition data type as Date.