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

Package with 2TM1 cube throwing up an error

Started by barrysaab, 13 Oct 2017 06:20:45 AM

Previous topic - Next topic

barrysaab

I have created a package with two TM1 cubes , when I am dragging feilds from second cube it is throwing up an error , could be due to joining or something else.

How to overcome this issue? thanks in advance for your help.
Boy! Cognos getting on to me!!!

MFGF

Quote from: barrysaab on 13 Oct 2017 06:20:45 AM
I have created a package with two TM1 cubes , when I am dragging feilds from second cube it is throwing up an error , could be due to joining or something else.

How to overcome this issue? thanks in advance for your help.

Hi,

You can't mix data from both cubes in a single reporting container (list/crosstab/chart/map etc). The best you can do is to use a master/detail relationship - eg embed a crosstab from one cube inside a list from the other and master/detail the crosstab and list queries based on captions from your cubes.

Cubes can't be joined - joining is a relational concept :)

Cheers!

MF.
Meep!

barrysaab

Apologies for late response , Thanks a lot ,MF.
Boy! Cognos getting on to me!!!