The query cannot be released for OLE DB for OLAP

What causes this issue?

The query contains variable &V1&, which is replaced with the result of
query &V2&. Query &V2& contains variables ready for input. These
variables cannot be entered using MDX. For this reason, the query cannot
be released for OLE DB for OLAP.

How to fix this error?

Do not release the query for OLE DB for OLAP, or avoid using variables
replaced with the result of a query with variables ready for input.
Instead of using variables replaced with a query result, you can use
variables having the type pre-calculated value list.

Error message extract from SAP system. Copyright SAP SE.