Prompt based report column — Oracle Analytics

Oracle Analytics Cloud and Server

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

Prompt based report column

Received Response
11
Views
2
Comments
mmajdana1
mmajdana1 Rank 6 - Analytics Lead

Hi , I am using OBIEE 12.2.1.2.0

I would like to know if there is a way where I can show a  different column in a pivot table based on my prompt selection.

Kr, Matija

Answers

  • Sure, CASE WHEN <condition> THEN your-column-A WHEN <condition> THEN your-column-B END.

    Just use a presentation variable you set in your dashboard prompt for the condition.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    What Gianni said or have you already looked at the out-of-the-box column selector?