Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

Prompt Dashboard for cross subject areas

31
Views
2
Comments
Dario_DiFranceschi
Dario_DiFranceschi Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

Summary

Prompt Dashboard for cross subject areas

Content

Hello,

I have an analysis made by two subject areas (linked by an INNER JOIN) and the system puts "saw" alias in the resulted query.

If I wanted to insert the analysis in a dashboard, how do I create a dashboard prompt in order to filter appropriately the analysis fields?

 

Thanks

Dario

Tagged:

Comments

  • Jagadish Angadi-29558
    Jagadish Angadi-29558 Rank 3 - Community Apprentice

    Hey Dario,

    Did you try using presentation variable. That might work for you. One of the report I developed with logical SQL and I used presentation variable worked perfectly. Although, I am not sure if this works for you since you are joining two subject areas, you can just try, I don't see any reasons it fail but I am not sure. See if this helps and also please let me know if it really helped.

    Thanks

    Jagadish

     

     

    Capture1.PNG

  • Jagadish Angadi-29558
    Jagadish Angadi-29558 Rank 3 - Community Apprentice

    Prompt