We want to render the HTML reports using the SAP BO Webi universe

[Former Member]

We currently have integrated SAP BO Webi Reports on our application for customised reports. The application also has some standard HTML reports which are based on the database which is connected to BO universe. We want to know if we can use the BO universe to render the data in HTML reports instead of directly pulling data from database.

Key point:

SAP BO Webi report are based on BO universe which is connected to our application database

There are some other HTML reports which are based on same universe, we want to know if we can use SAP BO universe for these reports

[daniel_paulsen]

Hi Rohan,

you won't be able to connect your HTML report page directly to the universe. For that you need a client tool like Crystal or Webi to consume the data. You can however create runtime queries directly off of the universe using the Semantic layer RESTful SDK and the odata service. You can extract the raw data from the query and consume that with your html report (format is similar to comma separated values). The query is "in-memory" and is only good as long as the logon session is active. Otherwise you would need to save the data locally and report off of the local file or your own in-memory dataset.

For details around creating a queries and using odata.svc see the following guide: Query APIs

Dan

[denis_konovalov]

I'm not sure I understand the question.

If your HTML reports are based on universe, then they are already using BO universe. As there are no other universes.

[BasicTek]

this is posted in the wrong tag can you modify it and put it in Business Intelligence Webi or Semantic

-Tim