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:
- 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:
-----------------------------
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:
WARNING: When changing registry settings, make sure you have a backup of your machine/registry and that you know exactly what you are doing!
See Also
Chapter "DataSourceConfiguration" in Administrator Guide
3093608 - Problems related to buttons "Launch Query Designer" or "Create Web Application"
Keywords
bwmt, edit, query designer, modelling tool, hana studio , KBA , BI-RA-AO-XLA , Excel Addin , Problem