Skip to Content
author's profile photo Inde Singh
Inde Singh

BW 2.1C: Bex Analyzer query

Posted on Mar 27, 2004 at 11:21 AM 18 Views

Hi, I'm a beginner starting out developing in a BW 2.1C. I have good ABAP skills but limited experience in developing within BW.

I have a requirement to execute a BEx Analzyer Query in an ABAP program. I need to write the query results data to a flat file for transmission to a Cognos system.

Thanks, Inde

BW Business Explorer (SAP BEx) SAP Business Process Management
Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo Gianfranco Vallese
    Gianfranco Vallese
    Posted on Mar 31, 2004 at 06:26 AM

    You can try different solutions. First of all develop your Query.

    Then try to set up a Reporting Agent (from RSA1) or a RSCRM_BAPI: in bot cases you can schedule the execution and then start such a job from you ABAP program ...

    Hope it helps

    GFV

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 31, 2004 at 04:13 PM

    Are not useing OLE for ODB and you may need to create a query_cube for cognos ..

    Add comment
    10|10000 characters needed characters exceeded

    • Inde Singh Gianfranco Vallese
      Apr 20, 2004 at 10:10 AM

      Hi, thanks for all your help to date. I will be using transaction RSCRM_BAPI to schedule background jobs to create query extract files.

      I have one question about setting the query variables automatically. When I schedule the background job periodically can I use variable values for the query parameters. E.g. one of the parameters is period and I would like this to default to the current period. I want to setup the background job once to run periodically at the end of the month. Each month would use the current period value as a parameter.

      Thanks, Inde.

      Message was edited by: Inde Uppal