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

Have to one dashboard prompt data with another dashboard prompt

Jack

I am using OBIEE 11.1.1.9.0

I have a dashboard prompt with two columns(year and name). For this prompt i have also used section condition.

BUt now i have reuirement as when i select year, i should be getting names under Name Prompt which are only related to that particular year. But as of now by defualt i am getting all names under name format.

How can i restrict values at prompt.

Example

Year NAme

2016 JAck

Jill

2017 Humpty

Dumpty

JAck

BY default we will be getting all data under year and name when we use as prompts, what ever we have to filter we can apply them and view report at dashboard

But i need is when i select 2016 in prompt and check Name prompt i should see onlr Jack and Jill from these two names only i have to apply filter.

Can anyone please suggest

Thanks in advance

Find more posts tagged with

Accepted answers

All comments

Gianni Ceresa

Hi,

You just need to check the checkbox "Limit values by" in the options of your prompt for name.

To make it work fine if the 2 columns aren't coming from the same logical table you must define the "Implicit Fact Column" in the RPD for that subject area. When querying dimensional attributes only the filter will be done based on that fact (because a fact it's the only way to "link" 2 different dimensions together).

Jack

Thank You it worked

Gianni Ceresa

Good to hear

So can you maybe close the thread and mark answers as required? It will help others looking for the same and for now it's still This question is Not Answered.

Jack

sure

But how to close, i dont see any close link here

Gianni Ceresa

Based on https://community.oracle.com/docs/DOC-891037#jive_content_id_1322_Helpful_and_Correct_ you must have a button to mark an answer as correct and this will also flag the thread as solved/answered.

Jack

I Have year from one dimension and name column from another dimension. When i am trying to use limit values, name column is giving odbc error as table does not exist.

Can i get values in prompt, since this two columns are from two dimensions.

How can i create implict column , i have 4 fact tables in this subject area

can you please help

Jack

i report i use columns from dimensions and 2 fact tables too

Gianni Ceresa

The "Implicit Fact Column" is defined by opening the properties of the subject area in the RPD.

As said only one column can be defined as implicit per subject area. So you must manage to identify a measure being the most generic as possible.

Upcoming Event

Oracle Webinar OCI AI Foundations Certification
Prepare-se para sua certificação em OCI AI Foundations Inteligência Artificial está transformando a forma como empresas desenvolvem aplicações, automatizam processos e utilizam seus dados. Para aproveitar esse potencial, é essencial compreender os principais conceitos de IA e como essas tecnologias se conectam aos serviços…