Connect 2 Cognos cubes

[Ramanan]

HI All,
Can we 2 Cognos cubes to produce a super cube and deliver reports.
RA

[MFGF]

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.

[Grim]

You could also create an FM package using 2 cubes as data sources.

[MFGF]

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

[Grim]

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.