How to get Bex Report into Query Browser

[Former Member]

Dear Experts,

I am planning to create the Dashboard using Add Query in the Query Browser.But i couldnt able to see any Bex Reports after login using ADD Query in the Dashboard Designer.

Can you please tell how to get the Bex Query into the Bex Query list after login using ADD Query option in Query Browser.
What are the steps i need to follow in Information Designer Tool.

Regards,
Venkat

[ravi_chandra3]

Hi venkat,

Please once check whether there exists any BEx query or not .

[Former Member]

Thanks for your reply,

The Bex Queries have exist.I could able to generate Web I reports also.I have created these connections using OLAP Connection and made shortcut connection for them in IDT also.

Did i miss some steps to achieve the above .

Regards,

Venkat

[Former Member]

HI Venkat,

When you click on "Add Query", it will prompt for BOBJ login and password. I hope you are able to login.

If you are 4.0 FP3 or later, it will show you Universe and BEx query option. You can choose what ever you required.

If you select BEx query, it will show you the connections.

Login into CMC.

Click on OLAP Connections.

New Connection

Provide the BW details. Select authentication as "SSO", if SSO is enabled.

This connection will show you when u click on BEx query.

Let me know if you have any questions.

Thanks,

Raj

[Former Member]

Thanks Raj,

Can you please send your mail id i ll send the screenshot error.I have created the OLAP Connection as you said above .But still the problem is same.In CMC---Application,We dont have Service called 'restful Web services' .Is this service causing the issue.I found the note SAP 1708100 .

We are using BI 4.0 SP4.

I am not

Please help me ragarding the above.

Regards,

Venkat