Skip to Content
author's profile photo Former Member
Former Member

Connect to an SAP BW BEx query using the Query Browser: Dashboards 4.0 FP3

Hello Experts,

I want to create a dashboard on top of a Bex Query. In the dashboad e-learning link i saw a video which talks about "Connect to an SAP BW BEx query using the Query Browser: Dashboards 4.0 FP3".

My question here: Is it possible to connect a BW Bex query from query browser of Dashboards designer only on FP3?

We are currently into BO 4.0 Patch 2.9. When i tried opening the query browser i don't see the "Bex" option there. Is it only available in FP3 or anything wrong i am doing here? It shows me only the universes present in the repository.

In otherway, i went to the Data Manager --> Add --> SAP Netweaver BW Connection --> here i can see the Bex queries through the SAP GUI but when i do a data preview am not getting the correct output. So, my doubt here is: why we have such two options? and what's going wrong in the 2nd approach because of which my query preview is not working?

Please help.

regards,

Tilak

dashboard.png (41.2 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on May 20, 2012 at 01:22 PM

    Hi Tilak,

    Yes it is possible to connect bex query using query browser in dashboards 4.x FP3

    for your reference check this video--->http://www.youtube.com/watch?v=Vu7B79O-flU

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 20, 2012 at 07:34 PM

    Hi Tilak,

    Yes you are right. The feature to use BEx query from query browser will be available only from FP3 only. In the current version you are using, you can only select universe through query browser. So nothing wrong there.

    In your last doubt, you are using BICS(BI Consumer Services) connectivity to get data from back end SAP BW. This is a different method of connectivity. Dashboards created using this method cannot be published in BI launchpad. After designing dashboard you have to launch it in SAP BW. So it will be like any other BW object. these dashboards don't have offline capability. ie they cannot be exported to any other formats like pdf,ppt etc. Only method through which you can view these dashboards is to launch them in back end BW and publish them in Portal. Also you cannot preview dashboard in design time. Only way is to launch it in BW and view. This is why you cannot view query preview.

    From FP3 onwards these difficulties wont be there. Like any other dashboard we can publish them in BI launchpad and export to any format.

    The answer for"why we have 2 methods?" : depends on requirement and environment available, users can choose different options. If one user has only SAP BW environment, he can use BICS connectivity to create dashboards and can view them in portal. So no need of BO environment there, For a user having non SAP back end, he can create universes and directly access them in query browser. You can also have a universe with same BW data and use that universe through query browser so that those dashboards can be published in BI launchpad. So which method to choose is purely requirement and environment availability dependent.

    Hope it is clear.

    Regards,

    Nikhil Joy

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.