No data retrieved by Stored procedure when drilling up
I have 2 reports in a dashboard
1. PNL Selection
PNL Selection report has drill down set. PNL Selection report and PNL report is linked with link drill down functionality in the dashboard. PNL Selection report is created using freehand sql view and PNL report is created using stored procedure.
When I drill down on PNL Selection report, a value is passed to PNL report as a filter (has 1 filter) and data is refreshed. But, When I drill up by clicking "UP" button available in report title section on PNL Selection report, the PNL report displays error as incomplete filters (Snapshot attached).
I think, the default values are getting disappeared while drilling up.