Hi - I had this issue where same type of thing stopped working. Turns out in the first analysis which it was based off DFF value in there, there was a NULL value in a row of data for a dff. When passing to second query, the second query failed when there was a null DFF in first analysis. Had to filter out the null, then…

What I found is that if you run the analysis from the "Catalog" the prompts will appear. If just running from "Reports and Analytics", you need to create a dashboard and add the analysis to the dashboard in order for the prompts to show. (From report and analytics screen)

One option I've been using in is the bi report select the parameters you want to default, then click the gear icon -> share report link -> current page It will show a link that you can bookmark locally in your web browser and it will pre-populate parameters.

Thanks for your reply, is there anyway to do this in only cloud environment? Unfortunately I don't have access to any noncloud environment. I'm hoping for an easy way to just export the folder/subfolder names in Shared Folders along with what files/object exist in each folder/subfolder.

Hi Steph, Rutgers university created an enhancement request for this same issue. https://cloudcustomerconnect.oracle.com/posts/e5ab73293f Would really appreciate if you could give the thumbs up on this idea to get some traction from Oracle. Regards, -Rich