Oracle Fusion Data Intelligence

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

Where to access Logical SQL queries for parameter creation?

Accepted answer
91
Views
2
Comments
Caroline Blanchard
Caroline Blanchard Rank 6 - Analytics Lead

In many of the instructional videos about parameters, the Logical SQL query is simply pasted into the box without the video creator mentioning where to access it. Or if its something we write ourselves, what is the username we are supposed to put in place of 'dvauthoruser'?

Best Answer

  • Caroline Blanchard
    Caroline Blanchard Rank 6 - Analytics Lead
    Answer ✓

    Figured out how to enable Developer mode though clicking on my profile then advanced then enable developer options. From there I followed this link to get the Logical SQL to show up.

Answers

  • David Granholm-Oracle
    edited June 2023

    Good plan! Logical SQL can also be seen in the Answers XML, but it's a bit tricky to find.

    Dave Granholm

    Fusion Analytics Product Management