Skip to Content
avatar image
Former Member

Bex Analyzer automation

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.?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Oct 26, 2015 at 07:40 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.