cancel
Showing results for 
Search instead for 
Did you mean: 

Business Objects Explorer on bex query on HANA

Former Member
0 Kudos

Hi BI/BW/BO experts


if we implement BW on HANA, and run bex queries.

What are the pros and epecially the cons for running BO explorer.

Can Explorer connect to a bex query?
What about iput variables ?

Can the bex query connect to multiproviders?

Does it run on IOS ?
Does it run on Android ?

Hope for a clarifying answer.
(These things changes so fast)

very best regards


Ingrid

Accepted Solutions (0)

Answers (3)

Answers (3)

kohesco
Active Contributor
0 Kudos
Former Member
0 Kudos

you know if this is possible?

Former Member
0 Kudos

Hi Ingrid,

We can create information space over BWA and here is the steps;-

  1. Login to BW system from SAP GUI.
  2. Run T-code RSDDB.
  3. Click Query as InfoProvider button.
  4. Select one BEx query and click Release Query as InfoProvider menu.
  5. Click Create button.
  6. Click Activate and Fill BWA Index and select Immediate > Save.
  7. Run T-code /nRSDDTPS. Find the BEx query.
  8. Right click it and select Create... menu.
  9. Click Yes from prompted dialog.
  10. Enter User name and select "0BI_ALL" as BW Authoriz.
  11. Click Activate menu and select Immediate > Save.
  12. Run T-code /nTrexAdmin.
  13. Select Program > Get BIA Rfc Destination and click Execute button.
  14. =>You can find hostname of BWA system and trex instance number in Location field.
  15. =>It is generally formated as "<host>:3<instance number>##".
  16. Use the two information to enable Business Warehouse Accelerator to BusinessObjects Explorer by referring KBA 1618815.
  17. Login to Explorer 4.0 and click Manage Spaces menu.
  18. Find the BEx query and click New button.

You can connect bex query to multiprovider through JCO connection from IDT.

Hope this helps

Regards,

Pranay

Former Member
0 Kudos

Hi Pranay. 

Thank you for answering This is on BWA, what about HANA ?

Same procedure or not ?

Ingrid

Former Member
0 Kudos

Hi Ingrid,

For HANA you need to create a JDBC connection from IDT and use it for explorer.

Both BW and HANA are real time DB and they are very fast in performance.

Regards,

Pranay

Former Member
0 Kudos

Yes if you have BW on HANA you need to follow same process