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