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?
I could work out for my problem one solution by using both quick filters and cascading filters across multiple sheets. The latest enhancement of cascading filters across multiple work sheets came to my rescue.