Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Francis aka khayman on 09 Jun 2014 03:29:45 AM

Title: Members from another dimension
Post by: Francis aka khayman on 09 Jun 2014 03:29:45 AM
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
Title: Re: Members from another dimension
Post by: Francis aka khayman on 18 Jun 2014 02:36:13 AM
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/
Text only | Text with Images