A common requirement is to be able to have two dashboards interact with each other by passing variables from one dashboard to another. In our example, we have a parent dashboard that encapsulates several children dashboards. In this recipe, we will show you how to pass values from one dashboard to another using Flash Variables.
Open up a new Dashboard model and drag an Input Text component and a SWF Loader component into the canvas.
Go to the spreadsheet and enter
Company Ain cell A1. This is the default value that will be passed to the second dashboard.In cell A2 type
child.swf?Variable1=and in cell A3 type=CONCATENATE(A2,A1).Link the Input Text component to cell A1. Also make sure you select the Insert Data On Load option and bind its Destination field to cell A1.
Bind the Source URL field of the SWF Loader component to cell A3.
Save and export this dashboard to an SWF file. See the Exporting to SWF, PPT, PDF...