Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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
11
Views
2
Comments
Ed Chavez
Ed Chavez Rank 3 - Community Apprentice
edited Aug 13, 2024 5:59PM in Oracle Analytics Forum

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 & AI 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!