cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BO4.1 Report with native SQL without Universe

Former Member
0 Kudos

Hi,

Can we create SAP BO4.1 Webi Report using java REST SDK/ API with native SQL which will not use the universe.

Can i get sample example or flow for same.

Thanks,

Amol

Accepted Solutions (1)

Accepted Solutions (1)

former_member197386
Active Contributor
0 Kudos

Hello Amol,

You can use the Webi RESTful API (nicknamed Raylight) to create a Webi document having a FreeHandSQL dataprovider.

Your application can be implemend in Java or any other technologies/languages able to perform HTTP requests.

Regards,

Anthony

Former Member
0 Kudos

Hi Anthony,

Thank you for replay.

So, it is possible without universe we can create report with SQL.

Could you please provide path and name of sample code helpful for my requirement.

Thanks,

Amol.

former_member197386
Active Contributor
0 Kudos

Hi Amol,

Have you access to the official RESTful API documentation?

Regards,

Anthony

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Anthony,

Yes, i have used REST AIP before this and created reports as well.

Can i get any flow or code sample to create report with SQL and not by data provider created by universe.

Thanks

Amol

former_member197386
Active Contributor
0 Kudos

Hi Amol,

You can launch a search on this forum but I'm not sure to see a snippet about this topic here.

What you have to do is:

- create a fresh document

- add a FHSQL dataprovider (you will have to provide the connection to use)

- send the custom SQL

- refresh data

- save document into CMS

Each one of these calls are documented in the official RESTful guide.

Hope this will help you!

Anthony

Former Member
0 Kudos

Hi Anthony,

Thanks For Reply.

I have searched in forum and in RESTful guide as well but not get any info regarding FHSQL with rest API.

As i am having BO4.1 SP2 server installed, i do not have Raylight samples. So It will be relay appreciate if get java RESTcode from Raylight sample for FHSQL.

Thanks,

Amol.

eric_festinger
Contributor
0 Kudos

hi Amol,

FreeHand SQL data providers are supported in Web Intelligence RESTful web service since 4.1 SP5. You won't be able to create such a data provider on your version.

Regards,

eric

Former Member
0 Kudos

Hi Eric,

Thank you for Reply.

We are planing to install SAP BO4.2, is it support FreeHandSQL and RESTAPI to create report with Native SQL?

Thanks,

Amol

former_member197386
Active Contributor
0 Kudos

Sure, 4.2 is the best choice!

Anthony