Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Dashboard Prompt Using

Received Response
1
Views
2
Comments
dhopkins
dhopkins Rank 1 - Community Starter
edited Aug 13, 2024 5:38PM in Oracle Analytics Cloud and Server

Using the delivered OBIA Finance subject areas, I am trying to populate a prompt with only those  items in GL Segment 5 that have a record in a particular budget ledger in the Budget Ledger.  I can create a small analysis using the Finance - Budgetary Control - Detail Transactions subject area using the GL Segment 5 code, the transaction amount, and the Budget Ledger Short Name, filtering on the Budget Ledger Short Name for the correct one and get the list I want, but I don't know how to translate that to something that will work in the prompt.

A more general question would be how to create the sql for a prompt that involves more than one table?

Hoping someone can help!

- Darlene Hopkins

Answers

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    Hi Darlene,
    If you've written a simple query that returns the values you want to see in the prompt, you can copy that SQL from the Advanced tab, and put it into your prompt.

    I usually delete the "s_0"- type references(highlighted), and in the example below, I'd place my "Contracts"."Fund Source Code" into the ORDER BY statement.

    pastedImage_3.pngI'm not sure this answers the multiple tables aspect of your question, but it's a start.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    As a shortcut you might want to try using OBIEE to generate the sql.

    i.e. If you can create the analysis in answers that gives exactly what you want for the prompt then you can then set your diagnostics high, view the log file, get the physical sql and just copy that into the prompt area.