SAP Knowledge Base Article - Public

3084748 - Nothing happens when clicking on "Launch Query Designer"

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:

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

  1. Open a workbook in Analysis Office (or insert a query in a new workbook);
  2. Go to Analysis Design ribbon;
  3. 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:

File association.png

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

Product

SAP Analysis for Microsoft Office all versions