3073648 - "Launch Query Designer" is disabled - Unable to open Modelling Tools from AO

Symptom

You want to access BW Modelling Tools for a query via "Launch Query Designer" button in Analysis Office, but the button is disabled/greyed out.

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:
-----------------------------
Checking if bwmt link can be handled
Registy Key bwmt\shell\open\command does not exist
Bwmt link can be handled: False
-----------------------------

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 the button "Launch Query Designer" is disabled/greyed out. It is not possible to open BW Modelling Tools.

Cause

Analysis Office uses the registry key below in order to launch BW Modelling Tools:
Computer\HKEY_CLASSES_ROOT\bwmt\shell\open\command

If this registry does not exist in the machine, AO is not able to launch BWMT.

This registry is not set by Analysis Office, but by the BWMT during installation. AO only makes use of it because it determines which program will handle URLs that start with bwmt://.

Resolution

Refer to SAP KBA 3093608 for more information about the button "Launch Query Designer".

Check the installation of BWMT in the machine and try to reinstall it, so the registry is created.

As a workaround, the registry can be manually created, pointing to hdbstudio.exe in the machine, as shown below:

Registry setting.png

WARNING: When changing registry settings, make sure you have a backup of your machine/registry and that you know exactly what you are doing!

Keywords

bwmt, edit, query designer, modelling tool, hana studio , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions