Hi
I have two BAQs in a dashboard. They are not linked in a parent child sense, but the input parameters for both should be the same. The first BAQ in the Dashboard shows a Delivery listing by territory or customer and date range and then below that the other BAQ shows a set of totals and percentages for the same set of data. There may be a way to do that in one BAQ but I couldn’t figure out how to do it… Anyways, the Dashboard gives the users the info they need.
Currently, users need to enter the same 4 parameters twice - a bit of a pain for them. Is there a way that the users can enter the parameters only once?
Also, regarding parameters. Unless you are using aggregate functions that are affected by the criteria, It’s easier for the end user if you add a tracker instead of parameters.
edit never mind, I see you are using percentage for the date ranges. Parameters is the way to go.
Unfortunately, the publish/subscribe will not work when the parameter is needed. Although, if only one of your queries is using the aggregate functions, if you set the parameters on that one, then put the parameters in calculated fields so that they show up in every row, you can filter your second query by your parameters.