Prompt Dashboard for cross subject areas

Dario_DiFranceschi

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

Jagadish Angadi-29558

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

 

 

Jagadish Angadi-29558

Prompt