Oracle Analytics Publisher Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Publisher Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to avoid ask reference when I validate a request

Accepted answer
21
Views
2
Comments
Xavier H.
Xavier H. Rank 1 - Community Starter
in Oracle Analytics Publisher Forum

Hello,

I have a problem with editing reports.

I duplicated a data model and want to add fields in the query but parts of the query are dynamic and when validating the changes, it asks me to value these parts.

How can I validate without doing this valuation?

Thank you

Capture.PNG

Best Answer

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics & AI Strategist
    edited Nov 16, 2024 2:59PM Answer ✓

    Hi @Xavier H. ,

    The solution to this is to edit the data model using text editor instead of BIP. Follow the steps mentioned in below MOS note:

    Fusion BI Publisher - How to Get Around Lexical References When Customizing a Seeded Data Model (Doc ID 2318462.1)

    Thanks.

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics & AI Strategist

    Hi @Xavier H.

    Its an standard Functionality of SQL, as you are passing an '&' parameter so you need to enter some value to execute the query.

    you can try procedures/functions to minimize the runtime inputs.

    Regards,

    Arjun