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 AI and Analytics

Child Item

Using Dashboard Prompts with Custom Analysis

Julia Looi

Hello,

I have a custom OTBI analysis which I created using SQL. Has anyone used Dashboard prompts with a custom analysis? Any advice would be much appreciated!

Thank you,

Julia

Find more posts tagged with

Accepted answers

Gianni Ceresa

If your analysis is built with LSQL directly, you can reference dashboard prompts only through variables. Make your prompt assigning the value to a session variable, and reference the variable with the @{variable} syntax (and the various options there around).

All comments

Gianni Ceresa

Julia Looi

Hello @Gianni Ceresa

Thank you for your advice. If you don't mind, may I run the set up by you? Enclosed below is what I have set up for the prompt variable and then the filter on the desired column for the analysis.

Is this what you mean? Thank you.

Julia Looi

@Gianni Ceresa The variable prompt worked! Thank you so much!

Sa_De_Or

Hi @Julia Looi,

For me it looks like this:

I did exactly the same as you did, only for the prompts I had to choose the option "SQL results" instead of "all column values". The selection list for each prompt is working fin based on the SQL query. Only when I run the Dashboard, I get this. Appreciate every help.

Gianni Ceresa

Hi @Sa_De_Or , would you mind posting a new question with all the context information related to your issue?

This thread was answered and your question isn't really the same thing (your is an analysis based on a subject area of some kind, while the original question here was about a DDR analysis).

When you ask the new question, describe how that dashboard page is built, what result you get, what you expect to get instead (and a product name and version generally help too).

Sa_De_Or

Hi @Gianni Ceresa,

sorry if I misunderstood you but I don't know at which point my analysis differs from the one above. I am afraid, that I will be forwarded to this post if I would post it as a new question.

I have following analysis based on LSQL(SQL attached):

SkillsCustomLogicalSQL.sql

My results are working fine, but in the moment of implementing the dashboard prompt as described above it doesn't work.

I tried two ways: I edited the prompts based on a column and based on SQL results.

I appreciate every help.

(HCM, Version 24C (11.13.24.07.0))

Gianni Ceresa

The main difference is that you have an analysis built on subject areas with LSQL, while OP had a DDR with SQL.

And also, this thread has been marked as answered, it will not get much attention because it is considered as closed.

Because your case is different, starting with a very different analysis in the first place, just post a new question: it will let you set the context of your question correctly, provide the elements you have (most of them are posted above, copy them to your new question), and post your question.

Upcoming Event

AI Data Platform - Creating High Code Agents and Using Developer Tools in AI Data Platform
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…

Top Leaders

Mallikarjuna Kuppauru-Oracle 80