Skip to Content
Former Member
Feb 17, 2009 at 05:49 PM

Unable to Launch query throgh Bex API


Iu2019m trying to automate a Bex application form an out of process application for automated testing. I want to accomplish following four things:

1. Launch Excell.

2. Launch Bex add ins.

3. Connect to Bex server.

4. Open a query and display it results in the excel worksheet.

I was able to accomplish first 4 tasks from an application written in visual basic. However, Iu2019m not able to open any query. Iu2019m using following Bex api to open a query:

Call app.Run(BexPath & "! runQuery", "First Query")

No matter what query name I provide Iu2019m getting following errors and excel worksheet does not display any resutls:

u201CThe requested query /First QUERY does not exist on the current server.

u201CThe query FIRST QUERY on infoprovider canu2019t be assigned to the dataprovider DATA_PROVIDER_1

Iu2019m really stuck at this point and any help shall be appreciated. Iu2019m new to this ear of programming so please tell me if there is some alternate way to accomplish these tasks. When providing name of the query in above API Iu2019m not sure if technical name of the query need to be provided and if query or info cube resides in some nested structure, should I provide a full path or just query name. For example if full path of query u201CSAP Demou201D is u201CInfoAreas\SAP Demo\SAP Demo Sales and Distribution:Overview\SAP Demou201D then what kind of string format is should provide to access u201CSAP Demou201D query.