cancel
Showing results for 
Search instead for 
Did you mean: 

Bex Analyzer automation

Former Member
0 Kudos

Hi,

I would like to automate Bex analyzer 7.3. Is it possible to add corresponding add ins to certain workbook, automate logon, set filter parameters and refresh it to retrieve updated data? If yes, can anyone give me more details, information on how to actualy do that. Are there any tutorials, articles, etc.?

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186696
Active Contributor
0 Kudos

Hello Sandi,


What exactly do you want to do/expect for this workbook?

Everything that you mentioned exist if on BW.

For instance:
> Automate logon -  You can use transaction RRMXP. Put the workbook ID and it will logon automatically.

> Set filter and refresh -  Basically, when you refresh a workbook, all workbook filters are refreshed.
You can use a variable to setup a specific filter.
For this variable, you can create a customer exit and will populate automatically the variable value.

Another thing.
You can broadcast a workbook to an email.
You can create the broadcast setting, select the variables and schedule to send data to your email everyday.

Kind Regards,
Edward John

Former Member
0 Kudos

Hello,

Thanks Edward.

I'm talking about BI, I would like to retrieve sales forecast for a certain time span and then create a report.

So basically what I have in mind, let's say

I would like to write a script that will open a workbook (which is designed/templated to work with bex analyzer) and write vba code to do logon on server. After successful logon I would like to set up a filter with multiple criteria and refresh the workbook to get updated results. Close it. And then use retrieved data in some other workbook to generate the report. But that's not an issue anymore.