Members from another dimension

[Francis aka khayman]

Sounds sci-fi but based on values from one dimension, how can I search for members in another dimension ?

I am using a dimensional model, with cube as the source. The model has two time dimensions:

T1 has MUN that looks like:

Caption          MUN
Jan 2014       201401
Feb 2014      201402
Mar 2014     201403


T2 has MUN that looks like:
Jan 2014    20140101-20140131
Feb 2014    20140201-20140229
Mar 2014    20140301-20140331

To make things simple, I need a crosstab with T1 months as column, then below it is T2, two months earlier than T1:

                   Jan 2014        Feb 2014       Mar 2014              <---- T1 Months
                  Nov  2013        Dec 2013         Jan 2014             <---- T2 Months       

Process:   T1 = Jan 2014, find Jan 2014 from T2, subtract 2 months

[Francis aka khayman]

solved... http://www.cognoise.com/index.php/topic,25097.0.html

also in my blog:

http://cognosm.fm3online.com/dimensional/searching-a-dimension-using-value-from-another-dimension/