Hi everyone i was doing a POC in dbt cloud for building metrics i was trying to declare a dimension using another declared dimension but when querying the semantic model i was getting error
“reason”: “invalidQuery” , “message”: “Unrecognized name: opening_mrr at [9:28]”, “status”: “INVALID_ARGUMENT” (InvalidArgument; Prepare)".
It is because the query generated in the sql it was unable to recognise the dimension declared(opening_mrr) in the dimension downgrade_mrr you can check the screenshot below for reference.
Can some guide me on how to use dimension to declare other dimension or is there any way to do it?
Thanks!.
