If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

join using between

Started by Francis aka khayman, 29 Apr 2014 05:02:37 AM

Previous topic - Next topic

Francis aka khayman

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?