Oracle Transactional Business Intelligence

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
21
Views
3
Comments

Hi,

I created a report with custom datamodel with 2 prompts.

This is how it looks like.

Datamodel

Datamodel prompts are LOV and SQL query.

Report

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

Is there a way to get the prompts to work?

Best Answer

  • Rank 7 - Analytics 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.

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.