KB314191: Attribute Key form values from a SAP BW query are not displayed through Live Connection in MicroStrategy Web 10.0-10.6

SUMMARY:
This technical note documents an issue that occurs when using the Live Connection feature for a dashboard to import an SAP BW query, where the attribute Key form values are not displayed. A workaround has been provided.
 
SYMPTOM:
Attribute Key form values are displayed as blank when connecting to an SAP BW query that contains variables, using the Live Connect feature available for dashboards, in Strategy Web 10.0-10.5:

 
Key form values appear when importing the SAP BW query through the MDX Cube Catalog and creating an MDX report.
 
STEPS TO REPRODUCE:

• Log into the project in Strategy Web.
• Select Create Dashboard and the dashboard editor window will appear.
• On the left hand side panel, click Add External Data to connect to a datasource.
  

• Switch to the Connect Live tab and select OLAP.
  

• The list of MDX Connections will appear. Select the database instance that will connect to your SAP BW warehouse.
• Under Browse Catalog, choose a query that contains at least one variable (prompt) and add it to the dashboard.
• In the dashboard editor window, add any of the attributes into the visualization rows.
• Once the attribute displays in the grid, right mouse click on the attribute name and select Display Attribute Forms > Key. Choose ON in the Display attribute form names drop-down list.
  

•  
  The Key form column does not contain any values.
  

 
CAUSE:
This is a known issue in Strategy Web 10.0-10.6.
 
ACTION:
The issue has been addressed in Strategy 10.7. Upgrade to that version or newer to benefit from the fix.
 
WORKAROUND:
An MDX report or document can be created with the SAP BW query imported through the MDX Cube Catalog.