General OBIEE

Get Involved. Join the Conversation.

Topic

    Lisa Eifler
    Native Reporting for Performance - using Extended function...
    Topic posted July 13, 2016 by Lisa EiflerSilver Medal: 2,000+ Points, tagged BI Publisher, BI Publisher Report Templates, Customizing Layout, Setup 
    36 Views
    Title:
    Native Reporting for Performance - using Extended function to filter results in rtf template
    Summary:
    Extended function to create filters in rtf template
    Content:

    Hello,

    We are using the Oracle BI Publisher plug-in for Word to create rtf templates. We need to create filters using extended functions. If you have experience using extended functions, please tell us the correct code to use for a filter that would be equivalent to a query "equal to" filter in Business Objects.

    For example, we have a review report where we only want to retrieve 'Draft' status reviews. We have the data model and the template. What is the code we use in the BI Publisher Properties to get results for only Draft reviews for the field:

    <?REVIEWSTATUSCODE?>

    Thanks in advance for your help.