I am building a Cognos FM model against an Oracle 11g relational database. I am running Cognos 10.2.1 FP3 in a development environment. (using CQM)
I have a join between two tables that uses a user defined function from an Oracle db in the join expression. I bring the function into FM manager using the metadata wizard and am able to use it in my join expression. I am able to validate the relationship and test the relationship with expected results in FM.
However, when I test the relationship by creating a list report in Report Studio with query items from each side of the relationship..I get an expression parsing error from Cognos (QE-DEF-0030) and then an invalid function error (QE-DEF-0358).
I then tried another report in Report Studio to test the use of the same function in a report (without using the tables in the join relationship above)....and it runs perfectly.
Please let me know if you have any suggestions for me...and thank-you.
I updated my version of Java and report now working correctly across the join.