We are facing an issue while using a Virtual BADI i.e. RSR_OLAP_BADI for calculating one of the key figure at run time in a query when using in a Analysis for office workbook.
Here what we are seeing is that the when we are running the query standalone which is having the virtual key figure is working really fine and it calculates exactly what is required for.
The issue is coming up when we are using the same query embedded in the Analysis for office work wherein multiple queries are involved the values are getting calculated the number of queries available in the workbook.
I want to understand if anyone has faced this issue before while using analysis for office so that we can take the necessary steps as required.