hi i'm new to transformer. i am converting a DMR into cube. i have this relationship in DMR:
fact.account_id < dim.account_id_max and fact.account_id > dim.account_id_min
i understand that in cubes, if fact have a column named account_id and dimension have column named account_id, both will be matched i.e. fact.account_id = dim.account_id
so question is, how can i implement this relationship in my cube?