Rudy on 30 Jun 2018 08:28:37
The matrix worked fine with the "Expand all down one level in a hierarchy" button when it was newly setup. When there is changes in the SQL code, the "Expand all down one level in a hierarchy" no longer working OK and error message popped-up such as follows:
Couldn't load the data for this visual
Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them. The exception was raised by the IDbCommand interface.
It is very frustrated to keep reworking on the matrix visual as new.