COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sravantig on 02 Mar 2012 02:19:35 PM

Title: Cube Member from Two Different Cubes
Post by: sravantig on 02 Mar 2012 02:19:35 PM
I need to display a line chart from years 96, 97, 98, 99...
The cube I'm using has only year 97 and necessary measure and data item..

Can I use the other years from different cube?
Title: Re: Cube Member from Two Different Cubes
Post by: Grim on 06 Mar 2012 01:00:45 PM
Short Answer: No

Long answer: You'd have to create a new FM model with 2 cube data sources in it to create a single package with 2 cube data sources.
http://publib.boulder.ibm.com/infocenter/cbi/v10r1m1/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.ug_fm.10.1.1.doc%2Fc_workingwithdatasourceconnections.html
Title: Re: Cube Member from Two Different Cubes
Post by: pingrkiran on 06 Mar 2012 03:16:36 PM
check this
http://www.ibm.com/developerworks/data/library/cognos/reporting/dimensional_queries/page495.html