How to Resolve Dimension Not Found Error in Bold BI Expressions.
When creating or modifying expressions in Bold BI, you may encounter an error message related to a dimension not found in the cube. This issue can occur when an existing expression in the same data source is using a field that has been modified at the cube level. To resolve this issue, follow the steps below:
Steps to Resolve the Error
- Identify the expression causing the error. In this case, the expression named “Avg of increased equity” is causing the issue with the following expression text:
SUM([ Value of increased equity_9676])/COUNT([ Value of increased equity_9676])
-
In this scenario, the field named
[ Value of increased equity_9676]has been modified to[ Value of realized equity gains_9676]at the cube level, causing the exception. -
Modify the expression in your data source to use the correct field name. In this case, update the “Avg of increased equity” expression to:
SUM([ Value of realized equity gains_9676])/COUNT([ Value of realized equity gains_9676])
- After modifying the expression, you should be able to create or modify other expressions without encountering the error.
If you do not want to modify the existing expression, you can create a new expression for your requirement instead of editing the existing one.
By following these steps, you should be able to resolve the error and successfully create or modify expressions in Bold BI.
Additional References
