HI All,
Can we 2 Cognos cubes to produce a super cube and deliver reports.
RA
Analysis Studio can only address a single dimensional package using a single query. While you can include multiple cubes in a package, each would need to be referenced in a different query (since they have different MUNs) so the short answer is "no" in Analysis Studio.
You can reference multiple cubes in a Report Studio report though. Report Studio supports multiple queries, and you can even link them via master/detail relationships.
Regards,
MF.
You could also create an FM package using 2 cubes as data sources.
Quote from: Grim on 22 Jun 2012 12:24:31 PM
You could also create an FM package using 2 cubes as data sources.
Yep. That's what I alluded to in my post. You can only refer to one cube in any one query, though, and Analysis Studio doesn't support multiple queries, so you need to use Report Studio to address both cubes in one report.
Cheers!
MF.
Snet form my fumblefingers
iPhon 5 usig Tapatalk
Quote from: MFGF on 23 Jun 2012 09:55:35 AM
Yep. That's what I alluded to in my post. You can only refer to one cube in any one query, though, and Analysis Studio doesn't support multiple queries, so you need to use Report Studio to address both cubes in one report.
Cheers!
MF.
Snet form my fumblefingers
iPhon 5 usig Tapatalk
Figured. ust wanted to clarify since FM wasn't mentioned. ;)