If you are unable to create a new account, please email support@bspsoftware.com

 

SOLVED User Defined Function Used in Join Tests Correctly in FM not in RS

Started by Penny, 17 Dec 2014 01:42:02 PM

Previous topic - Next topic

Penny

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.

Penny

I updated my version of Java and report now working correctly across the join.