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

Can i join on two cube sources in a report

Started by cognos05, 29 May 2020 02:51:27 PM

Previous topic - Next topic

cognos05

Hi ,

I have two transformer cubes in a package through FM .

Now i create a report from 1 st package

ProductType Sales Qty

Now i create a report from 2nd package
ProductType InvQty

Now I have to combine both these measure in 1 cross tab . The producttype dimension in both cubes haev same structure .

so I did a join on Query 1 and Query 2 on product type and borught both sales qty and invqty

But this throwed an error

GEN-ERR-0015 Initially, in data source type(s) '', the function 'realDataMode' is not supported in 'NoDataModeProvider'. After decomposition, in data source type(s) '', the function 'subQuery' is not supported in 'TabularFuncProvider'.

so cannot i not join data from 2 cubes , how can i then achieving showing different measures from both cubes in 1 crosstab.

Thanks