Refresh multiple queries individually and give different variable inputs for queries separately

If user wants to refresh the queries individually  in a workbook with multiple queries and give different variable inputs for queries separately.

Steps for resolution:

1. Maintain ‘X’ for ANA_SINGLEDREFRESH in tcode RS_FRONTEND_INIT.

2. Check Allow Refresh Function For Individual Queries

3. Uncheck Display Duplicate Variables only Once.

    If the same query is used multiple times and user wants to give different inputs in workbooks, below option should be unchecked.

     save workbook.

Thanks for Reading,

Regards,

Emily.