nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Creating dashboard prompt with custom datamodel and report

Simon L

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?

Find more posts tagged with

Dashboard

Data Models

Accepted answers

Nathan CCC

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.

All comments

Nikki Reich

Hi @Simon L ,

For dashboards, you need to use a dashboard prompt

Like so:

Then add it to your dashboard, like so:

Nathan CCC

Hi Simon,

Simon L

Thank you both @Nikki K and @Nathan CCC !!!!