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
Filter column with prompt with another column

Hi
I have DIMENSION A with column ABC
I also have DIMENSION B with column ABC
SAME COLUMN.
I want to filter a report with Dimension A column ABC using the values of a prompt derived from Dimension B column ABC.
Reason of this is because Dim A has 3million records and all my prompt permutations result in 50k combinations (records). Obviously using Dim B, that holds only the combinations for that prompt is much faster. Can OBIEE handle prompt from different columns?
Answers
-
Use a presentation variable.
0 -
Will try that... Sorry I know that must be the answer, the thing is I'm good with the RPD but I almost never use OBIEE Answers itself heheh.
Thanks!
0