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