Can you join queries of different types?

[godonkeys]

Hi,

Very new to Cognos so please bear with me.

We have a query against a relational source and a query against a cube (Essbase).  We want to outer join those together by Account into a variance report. However it's throwing a weird error when we run it.

We are basically trying to reconcile two source systems to ensure they tie, something like....

Total Expenses(Essbase) - 1,000,450     Total Expenses(Warehouse) - 1,000,000     Variance - 450

But we think we are not allowed to join the Account field as the sources of the data isn't compatible to do in a single report.

Any ideas?

[godonkeys]

Error Is:

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'.

[tjohnson3050]

I would try converting the essbase data item into one of the same datatype as your relational query.  Try the caption() function to return the text name of that data item.