Dashboards with BEx query and no JAVA stack on BW?

[kelly_stone1]

How can I use Dashboards with a BEx query to connect to a BW multiprovider?  I can use the same query and connection with Crystal Reports for Enterprise, Analysis for Excel and Webi...just not in Dashboards.

My setup:

Dashboards SP4 Patch2

BOE 4.0 SP4 Patch2

BW NetWeaver 7.3  SP6 (ABAP stack only No Java stack)

No portal used...will be using BI Launch Pad

I hear Java stack is a requirement for earlier versions of BOE.  Is it still for 4.0?  Can QAAWS or RESTful web service be used?

Here is what I currently try to do - Dashboards launched from my desktop.

Click on new.

Click on Query Browser and then Add Query.

Log On to BusinessObjects Enterprise.  After password and clicking OK above...I get the following error:

Clicking on OK gets me past it and the Add Query window pops up.  I choose BEx and next .

 

I choose my connection:

I choose my query:

I select my result objects, click refresh and get data from our BW system:

Clicking next gives me preview query result, also:

Clicking next gives you more options:

Clicking OK gives the following error...again:

Clicking OK on the above error takes me back to the Dashboards work canvas...empty....with no more error...?

--------------------------------------------

Another way I have tried:

[Former Member]

Kelly

check this OSS note

1733865 - How to enable RESTful Web Services, Insight to Action Service & Multitenancy Manager with SAP BusinessObjects Business Intelligence (BI) platform 4.0 Support Package 4.

[kelly_stone1]

Hello Pramod - If I have a two node BOE setup with one CMS database cluster....I presume I need to install on both BOE nodes?  Should the I shut down node 2 when installing on node 1 and vise versa?

Kind regards,

Kelly

[Former Member]

   yes .