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>>>
- Open Dashboard Design
- Click on 'Query Browser'
- Select Bex as data source
- 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 :
- Logon to the Central Management Console (CMC) with an administrative account
- Select the entry Servers
- Select the entry Dashboard Services in the Service Categories
- Now you need to select the DashboardsProcessingServer
- Right-click
- Use the menu item Properties
- Navigate to the Dashboards Processing Service area
- 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>>> - Click Save and Close
- Restart the server
Workaround 2 :
- Open IDT
- Select the BICS connection and Edit it
- Modify the language to EN
Workaround 3 :
- Change the language from the BICS connection to English Language
- Using /nSU01 transaction change the SAP Logon language preferences to english
Keywords
KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem
Product
SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Dashboards 4.0, feature pack 3 ; SAP BusinessObjects Dashboards 4.1