I know you can have a dashboard that lets you click a cell in a cube view and refresh a chart in the other panel, can you do it with the studio report?

Have to use a Cube View component in a Dashboard, place the Report component on same Dashboard and set the Dbd to Refresh in the Cube View Component = Report component name. Then, design it to pass parameters from one to the other.
For an example, go in GolfStream and run the Dashboard called Operating Expense Analysis.