Creating a dashboard using BEx query requires SAP BO server for OLAP connection?
Here we dont have "BO server" so I am unable to access BEx queries through "Query Browser" option in dashboards.
Another option to get connect with SAP is "SAP NET WEAVER Connection" we are able to get connect with query but while running dash board, it is throwing error "#1009 Allow external data access and consult query designer or CMC administrator". For my BEx Query i have checked "Allow access to external data".
Now my doubt is to "create a dashboard by using BEx queries, do we need BO Server?". Here in google I read like, for dashboard creation by using BEx Queries we need OLAP Connexctions.
Is this the only way or can we access BEx queries directly from SAP NET WEAVER.
please clarify my confusions and doubts..
thanks and regards..
Amit Anant Kulkarni replied
You do not need BO server when using the SAP netweaver BW connection in the data manager however for the query browser you need to have BO server.
This is prerequisites for SAO Netweaver BW connection.
By this you can view the dashboard in the BI portal i.e IRJ portal not the BI launchpad