How to avoid ask reference when I validate a request

Xavier H.

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

MandeepGupta

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.

Mallikarjuna Kuppauru-Oracle

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