If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Connect 2 Cognos cubes

Started by Ramanan, 21 Jun 2012 01:51:56 PM

Previous topic - Next topic

Ramanan

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

MFGF

#1
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.
Meep!

Grim

You could also create an FM package using 2 cubes as data sources.
"Honorary Master of IBM Links"- MFGF
Certified IBM C8 & C10 Admin, Gamer, Geek and all around nice guy.
<-Applaud if my rant helped! 8)

MFGF

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
Meep!

Grim

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. ;)
"Honorary Master of IBM Links"- MFGF
Certified IBM C8 & C10 Admin, Gamer, Geek and all around nice guy.
<-Applaud if my rant helped! 8)