1809653 - Dashboard Design 4.0 SP5 - Cannot Select Bex queries when creating new Dashboard if BICS connection language is different than english

SAP Knowledge Base Article - Public

1809653 - Dashboard Design 4.0 SP5 - Cannot Select Bex queries when creating new Dashboard if BICS connection language is different than english

Symptom

  • When trying to access BW cubes from Dashboard designer via 'Query Browser', the cubes are visible but grayed out and cannot be selected.

Environment

  • Dashboard Design 4.0 SP5
  • BICS connection

Reproducing the Issue

<<<Make sure your SAP Logon user has got other language than English selected>>>

  1. Open Dashboard Design
  2. Click on 'Query Browser'
  3. Select Bex as data source
  4. Search for the Query name and expand the query name by click on the + sign

-> Bex queries appears as grayed out and cannot be selected

NB : This is a regression since installing service pack 05

Cause

This behavior is By Design, below are 3 possible workaround solutions.

Resolution

Workaround 1 :

  1. Logon to the Central Management Console (CMC) with an administrative account
  2. Select the entry Servers
  3. Select the entry Dashboard Services in the Service Categories
  4. Now you need to select the DashboardsProcessingServer
  5. Right-click
  6. Use the menu item Properties
  7. Navigate to the Dashboards Processing Service area
  8. Now add the additional command line in the Jva Child VM Arguments:
    -Dsap.sl.bics.detectMdxCompliance=infoArea
    e.g:
    My initial one : Xmx858M,Dswfinjection.lang.directory=%CommonJavaLibDir%,Dbusinessobjects.connectivity.directory=%CONNECTIONSERVER_DIR%
    The new one : Xmx858M,Dswfinjection.lang.directory=%CommonJavaLibDir%,Dbusinessobjects.connectivity.directory=%CONNECTIONSERVER_DIR%,Dsap.sl.bics.detectMdxCompliance=infoArea

    <<<make sure that there is no - no space either before nor after the comma>>>
  9. Click Save and Close
  10. Restart the server

Workaround 2 :

  1. Open IDT
  2. Select the BICS connection and Edit it
  3. Modify the language to EN

Workaround 3 :

  1. Change the language from the BICS connection to English Language
  2. Using /nSU01 transaction change the SAP Logon language preferences to english

 

Keywords

KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Dashboards 4.0, feature pack 3 ; SAP BusinessObjects Dashboards 4.1