Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Have to one dashboard prompt data with another dashboard prompt

HI
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
Answers
-
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).
0 -
Thank You it worked
0 -
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.
0 -
sure
But how to close, i dont see any close link here
0 -
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.
0 -
hi
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
0 -
i report i use columns from dimensions and 2 fact tables too
0 -
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.
0