9 Replies Latest reply on Dec 3, 2019 11:58 AM by Jerry Casey

    Refreshing one prompt based on other prompts selected

    Deepak_R-Oracle

      Hi Guys,

       

      I have a report which has variable prompts and i need to have one more prompt which is also a variable prompt but this should be filtered based on what user selects for prompt1, I have used sql query something like this SELECT BLA_BLA s_2 FROM subject_area WHERE ("Time Dimension"."Month Name" IN ('@{P_Q1}'))

      P_Q1 is the presentation variable which will get set from the first prompt, even after user selects the first prompt second prompts isn't populating any data, Any help would be greatly appreciated.