Available OLAP connection list not showing in Query browser

[nikhil_joy2]

Hi all,

Hope everyone is doing great. I tried using query browser to consume BEx queries in dashboard. But I am not able to see the available connection list after choosing BEx query as my source in query browser. Attaching a screenshot of the same.

Request your assistance in solving the issue. Am i missing any settings ? Please help

Many thanks in advane,

Nikhil Joy

[Former Member · Accepted solution]

Hi Nikhil,

Are you able to see the list of universes (Unx)?

Also you could check the following

1. Logon to Central Management Console (CMC).

2. Go to Applications.

3. Now double click on Web Service and go to Properties.

4. Update the Access URL as mentioned below and click on Save & Close:

http://<WebServer>:8080/dswsbobje

Confirm if this URL is accessible in the browser.

5. Launch Dashboard Design, open Query Browser, click on Add Query and enter BusinessObjects Enterprise logon credentials.

Regards,

Noopur

[nikhil_joy2 · Accepted solution]

Hi Noopur and Sara,

I got similar suggestions from both of you. But unfortunately its not rectifying the issue. thanks for the quick response. More suggestions please.

Best Regards,

Nikhil Joy

[former_member202257]

Hi,

Can you check if the user which is browsing the list of OLAP connection in dashboard designer has the required roles and access provided? Use an admin account to browse the queries and see if you are able to see the connections.

Regards,

Shwetha

[nikhil_joy2]

HI Shwetha,

I am already using admin account. so there is no access issues.

Best Regards,

Nikhil Joy

[former_member184839]

Hi Nikhil ,

Check this link, It should work.

Thanks,

Sara

[nikhil_joy2]

Dear All,

Any other suggestion on this?

Please assist

Best Regards,

Nikhil Joy

[Former Member]

Hi Nikil

Are you able to see connections while creating webi reports? Does you id have sufficient rights? Please check with your admin team if they have given view access to OLAP connections present in your system.

Regards

Shabnam

[nikhil_joy2]

Hi Shabnam,

thanks for the quick response. Yes i am able to create webi reports from bex query by accessing connections.  I have admin account. so authorization issue is not there.

Best Regards,

Nikhil Joy