Filter column with prompt with another column — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Filter column with prompt with another column

Received Response
1
Views
2
Comments
Ed Chavez
Ed Chavez Rank 3 - Community Apprentice

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

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Use a presentation variable.

  • Ed Chavez
    Ed Chavez Rank 3 - Community Apprentice

    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!