If both reports are tied to the same data source then you can apply the one filter (prompt as I believe you are calling it) to both sheets in the dashboard. If they are not tied to the same data source then you can use a parameter to tie to both reports.
State and Sum(Sales)
State and Count(Product)
Both reports i created multi select filter for State column.
Both reports i fulled into single dashboard.I can able to see both filters separate.Each filter working fine corresponding report.But my requirement is both report but single filter (State column).If i choose any values in state filter it should reflect both reports.How can i achieve this.
As far as I understood we can apply a parameter (for different datasources on one dashboard) but only if a database is relational. But can we apply a parameter to multidimensional datasource like SAP bex query ?