Skip to Content
Aug 27, 2019 at 03:47 PM

How to initially display 'query prompt' instead of 'workbook prompt' when AO workbook is opened?


I have only one BW query in my Analysis for Office workbook. When I open the workbook, the 'workbook prompt' instead of the 'query prompt' is displayed initially. Actually, I need the 'query prompt' opened initially so that I can select one of my BW query variants. How to set the 'query prompt' as the initial prompt in the workbook? (I do not have merged my variables in the workbook. I also do not want to use the workaround 'click on crosstab in workbook' > 'Analysis' ribbon > open 'prompt for datasource')