Multiple Queries in Workbook - Refresh Screen Shows Up for Every Query

[Former Member]

We have multiple queries in a workbook. All of these queries have the exact same selections for the variable selection screen. When all the queries are refreshed once, the selection screen used to show up once and all the queries are refreshed with the same selections.

We were on BI 7.0 and SP10. We recently moved to SP12. Since the SP12 installation, the multiple query refresh pops-up the selection screen for every query. It is nothing like "multiple query refresh" at once since the user has to click "execute" button for every single query. It is interesting to note that the selection screen only contains hierarchy variables and hierarchy node variables. The other variables of selection screen do not show up. I couldn't find any OSS note on this topic. Please let me know if anyone has any comments on this issue. I will assign points to useful posts.

[edwin_harpino · Accepted solution]

hi Sameer,

try to update front end patch to latest version ?

hope this helps.

[Former Member · Accepted solution]

Hi Sameer

You can try enabling the option "Display same variable only once" on the genaral tab of the Workbook settings

Thanks

Vivek