Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

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
114
Views
2
Comments
Caroline Blanchard
Caroline Blanchard Rank 6 - Analytics Lead
edited Aug 13, 2024 7:45PM in Oracle Fusion Data Intelligence
image.png

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'?

Tagged:

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
    David Granholm-Oracle Mod
    edited Jun 9, 2023 2:51PM

    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