Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Kamran Butt
    Receiving Error When Prompting Values from Field Created...
    Topic posted October 1, 2019 by Kamran ButtRed Ribbon: 250+ Points, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Public Sector 
    13 Views
    Title:
    Receiving Error When Prompting Values from Field Created from a Case Statement
    Summary:
    Cannot function ship the following expression: EVALUATE. (HY000)
    Content:

    I have created a Dashboard Analysis and Prompt from the following subject area: Subledger Accounting - Journals Real Time. 

    The requirement is to have the ability to filter the Analysis by the individual COA segments like users can do currently in several ERP modules (i.e.Fund, Department, Account, Function Project). The following columns are available: Fund, Department, and Account. The following columns are not: Function, Project.

    I created the columns by using a CASE statement and the Concatenated Segments column: 

    • Function: (CASE WHEN LENGTH ("GL Account"."Concatenated Segments") = '38'  THEN SUBSTRING ("GL Account"."Concatenated Segments" FROM 12 FOR 5) ELSE NULL END) 
    • Project: (CASE WHEN LENGTH ("GL Account"."Concatenated Segments") = '38'  THEN SUBSTRING ("GL Account"."Concatenated Segments" FROM 25 FOR 6) ELSE NULL END) 

    I added these same columns to a Dashboard Prompt and the prompts correctly display the distinct values as expected. However, when we run the report and filter for a particular Function or Project, I receive the following error: Cannot function ship the following expression: EVALUATE. (HY000).

    I have the EVALUATE_PREDICATE permissions for BI Consumer role granted. I also added it to my own user just to confirm, but I still receive this error. I am including the XML for the report for your reference if needed.

    Any thoughts on how to work around this? Thanks!

    -Kamran

     

    Version:
    Oracle Cloud 19C (11.13.19.07.0)
    Image:
    Code Snippet: