Query Browser after Login Effect

[Former Member]

Hi,

Would be thankful if anyone can help resolve my issue. The details please find the attached image file.

Not able to get the BEx and Universe Detailed value after login into Query Browser

Regards

Ranendra

[former_member182541]

Try this:

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

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.

[Former Member]

Hi,

I am not having access to Service market place to access

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

[former_member182541]

I have included the solution also, check that.

[Former Member]

Not able to get tomcat6

[Former Member]

[Former Member]

Hi Ranendra,

First of all you need to have UNX universes and OLAP connections created for BEx query.
If you have the above follow steps mentioned by Suman.

Please check if you have a split deployment.