1 Reply Latest reply on Dec 21, 2016 11:44 AM by Sudhakara Allam

    Cascading prompts in 10.1 version using custom SQL

    Sudhakara Allam

      I have many reporting requirements using cascading prompts. I could have used filters but I would have to create dash boards as I have to

      add multiple views and need to pass through values between work sheets. I was researching on cascade parameters and did not find definitive answer.

      I, however, tried to utilize Custom SQL functionality and embedding my parent filter to get selective results. I then created dependent parameter from

      the results of the custom SQL. The filter is getting passed and the results are getting refreshed in the custom SQL but they are not reflecting in the dependent

      prompt values which has reference to the column from this custom sql. I would think dependent prompt should refresh based on the values returned dynamically

      from custom sql but it is not happening. Could somebody throw some light on this?