Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

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

Creating dashboard prompt with custom datamodel and report

Accepted answer
31
Views
3
Comments
Simon L
Simon L Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Forum

Hi,

I created a report with custom datamodel with 2 prompts.

This is how it looks like.

Datamodel

image.png

Datamodel prompts are LOV and SQL query.

image.png

Report

image.png

With this, I created a dashboard, but 2 prompts are not visible.

image.png

image.png

Is there a way to get the prompts to work?

Tagged:

Best Answer

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics & AI Coach
    Answer ✓

    Hi Simon,

    As Nikki said you can add a dashboard prompt. For that to work the column in the dashboard prompt must be set to a presentation variable with the same name in same case as the parameter in your data model. So SPECILIZATION_NAME. I am confused with you other parameter because you are using a list of values rather than a calendar so not sure it its a date or string.

    image.png

Answers