Symptom
After clicking on "Launch Query Designer" in Analysis Office, nothing happens and Query Designer is not launched.
All the prerequisites are in place, according to chapters below:
- Chapter "Launching the Query Designer for editing a data source" in User Guide
- Chapter "SAP BW" in Administrator Guide
The Analysis Office trace file (recorded by following the instructions of SAP note 2129389), contains the entries below:
-----------------------------
Launch Query Designer - Writing launcher file to C:\Temp\<FILENAME>.7xbex
Launch Query Designer - launcher file written successfully
Launch Query Designer - Starting the Process using file: C:\Temp\<FILENAME>.7xbex
-----------------------------
Environment
SAP BusinessObjects Analysis, edition for Microsoft Office
Reproducing the Issue
- Open a workbook in Analysis Office (or insert a query in a new workbook);
- Go to Analysis Design ribbon;
- Confirm that nothing happens after clicking on the button "Launch Query Designer". The BEx Query Designer is not opened.
Cause
File type ".7xbex" is not associated with BEx Query Designer but to another application in Windows.
Resolution
Refer to SAP KBA 3093608 for more information about the button "Launch Query Designer".
Change the file type association in Windows, to make sure that files with extension "7xbex" are opened in BEx Query Designer as shown below:
A simple test can be done by creating a file with extension ".7xbex" to confirm that this file launch BEx Query Designer after double-clicking on it. If this is not the case, AO will not be able to launch Query Designer too.
See Also
Chapter "DataSourceConfiguration" in Administrator Guide
3093608 - Problems related to buttons "Launch Query Designer" or "Create Web Application"
3134814 - Fails to Launch BEx Query Designer in Analysis Office for BIP OLAP Data Sources
Keywords
query designer, classic, launching, launch, start, starting, open, opening , KBA , BI-RA-AO-XLA , Excel Addin , Problem