In FM I am importing a function called FN_REPORTS_TO which takes two parameters as inputs and returns either a 1 or 0 for success or failure. I am then setting up a Filter with the following definition:
FN_REPORTS_TO ( #sq($account.personalInfo.userName)# , [Commissions].[Transaction].[Employee ID] ) = 1
So this function is grabbing the userid and passing it to the database to check to see if the currently logged in person manages the person with the user id being passed in. This function definitely works in the DB.
Next, I am entering a security filter on a query subject. The group is Everyone and it uses the filter defined above.
When I try to reevaluate the query subject, I get the following error:
BMT-MD-0003 UDA-SQL-0219 The function "ODS.FN_REPORTS_TO" is not available as an external, database, or built-in function.
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-126'.
UDA-SQL-0219 The function "ODS.FN_REPORTS_TO" is not available as an external, database, or built-in function.
The function is in ODS and seems like it should work. In Oracle I have granted all access to public on the function.
Can anyone help?
Did you try changing rollup processing from "unspecified" to 'Database" in Framework Manager?
Just gave it a try, no luck. Thanks for the response, any more ideas?