Filter column with prompt with another column

Question

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?

Ed Chavez · Answer

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!

Sherry George · Answer

Use a presentation variable.