SAP Knowledge Base Article - Public

2487328 - No Universes appear under Query Browser in Dashboard Design 4.0

Symptom

  • Universes under Query Browser within Dashboard Design 4.0 SP2 appears blank

 



Environment

  • BI 4.0 SP2
  • Dashboard Design 4.0 Sp2

Reproducing the Issue

  1. Convert the universes to a .unx extension.
  2. Go and add a new query from the query browser within Dashboard Design 4.0 and all that is displayed is a blank screen.

Resolution

Steps for resolution:

1. Dashboard Designer connects to the universes through web services under the hood.
Check the path registered in the CMS with the following through the query builder: (http://localhost:8080/AdminTools/querybuilder/query.jsp )

2. Select SI_ACCESS_URL from CI_APPOBJECTS
This gave the correct path.
e.g.
http://Win2003EEx64:8080/dswsbobje

3. Copy and paste this path into Internet Explorer and see if it resolves.
If localhost is resolving but machine name isn't open the apache server.xml file and drop in an alias with your machine name under the hosts section.

The server.xml file is located at [path_to_]\Tomcat\conf\server.xml
e.g.
<Host name="localhost" appBase="C:\Program Files (x86)\SAP BusinessObjects\Tomcat6\webapps" unpackWARs="true" autoDeploy="true" xmlV
alidation="false" xmlNamespaceAware="false">
<Alias>Win2003EEx64</Alias>

4. Restart tomcat and test the SI_ACCESS_URL in IE.  Adding the Alias should not make the URL accessible as Tomcat will
respond to machine name as well as localhost. Open Dashboard Designer click on new query and you should now be able to
retrieve a list of universes.

Keywords

Universe appears blank, query browser, BI 4.0 , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Dashboards 4.1 ; SAP BusinessObjects Dashboards 4.2