OBIEE promt with 'ALL colunmn values' based on a condition is not applying to report — Oracle Analytics

Oracle Analytics Cloud and Server

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

OBIEE promt with 'ALL colunmn values' based on a condition is not applying to report

Received Response
1
Views
1
Comments
Vanathi-Oracle
Vanathi-Oracle Rank 1 - Community Starter

Hi,

My Prompt value which has 'ALL column values' is not applying ot the report.

I have three prompt in report. First prompt is text box and other two prompt is depends up on the first one. second prompt value will change based on the first prompt and it contains 'All column values';

And first and second prompt are from different dimensions.

One my report will run based on second prompt and not on the first. 

so when based on first prompt , second prompt has three values and it comes under all column values. but those three values in second prompt are not passing to my report.Since all column values got selected , it applies all the values comes form the second view, irrespective of the items retried though the first prompt.

How to pass the values tot he report when it comes all column values selected.

Answers

  • 1008490
    1008490 Rank 3 - Community Apprentice

    create a second prompt using the sql statement

    select Column value from table where column name = @{Fistpromptval} (Presentation variable)

    hope this will help you