Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Direct SQL Request from Dashboard Prompt (Cant pass parameters to dashboard)

1053827Nov 11 2013 — edited Nov 11 2013

Hi i am trying to pass parameters to dashboard. But i cant make direct sql request from dashboard prompt

Here is my scenario:

I have 8 reports which i built with R integration in Data Model section. I created parameters in data model. So after i created all reports, when i add this reports to dashboard, i cant see parameters. And also i cant create dashboard prompts. If i did this scenario with Analysis, it was easy to add dashboard prompt but with report scenarion i cant show these parameters. Help me please.

i already try dashboard prompt like this

New Dashboard prompt -> Variable Prompt

I choose Presentation Variable with my parameter next to it PARAM_1

Under these i choose Choise List and Choise List Value ( SQL Result )

I wrote my SQL result which call my table's columns

like this :

SELECT column_name

FROM all_tab_columns

WHERE table_name = 'my_table_name'

but when i save this prompt, nothing..

What can i do ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 9 2013

Added on Nov 11 2013

#11g, #answers, #bi, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #dashboard, #data, #oracle, #prompt, #report, #reports

1 comment

373 views