Question:
Hi every one ^^
My problem is that I must make several queries on BW using RRI. Receiver queries have to embed on templates. Problem is that template are differents and BW allows only 1 Template permanent by user. So, we cannot automatically associate different templates wbook in function of Query of beginning.
Someone could suggest me any solution, plz ?
thanks in advance ...
Answer:
Hello all ^^
I must give some explanations.
First, What I am doing:
As I already said, I have to create some queries, which use RRIs (Report to Report Interface). RRI are based on an EXCEL Template Workbook in order to format data result.
Problem: only one Template by user is available in BW as we can see on SAP table 'RSRWBTEMPLATE'. But these RRIs are based on different templates.
Of course, we can impose at key users to select correct template from a workbook list, but this solution is not convivial.
So I thought to use some SAPBEX functions, which permit to change current Template when it would be necessary. But, in despite of I've evaluated about 32 Bex Functions available in VB, I do not find what I search.
However, I've found an SAP function called 'RRMX_TEMPLATE_SET' which permit to change current template giving Workbook Id in argument. This function appears thanks the BW 'Trace' functionality. I don't know how execute it :
So, my questions are:
- Can you explain me if there is any solution easier to put in place?
- Else, is-it possible to execute 'RRMX_TEMPLATE_SET' from VB code?
- In general, is-it possible to execute any program, function or transaction from VB Code?
A last Remark: I do not understand how BW can execute RFC functions from Bex Analyser. And, I've seen only one object which uses function RRMX_TEMPLATE_SET' in Administrator Workbench, the include 'LRRX2F40'
Your Help will be greatly appreciate ^^
Best Regards...