I want to creat a metric or a property dimension where I get the last non blank dimension from a transaction list that also has some constraints like certain dimensions from that transaction list be equal to something.
I have the following formula:
'01_MRR-T Requests MRR BE'.'Billing Unit'[BY LASTNONBLANK: '01_MRR-T Requests MRR BE'.'Company or Partner Id'][REMOVE:'01_MRR-T Requests MRR BE'.'Product Final'='MRR-D Product final'."Licences"]
Is says that I need to add as a dimension MRR-D Product final, so even if I just want to use it as a constraint do I need to add to the dimensions in the metric structure?
Thank you very much in advance,