Question Re: Extract data from univers using JAVA SDK in Technology Q&A

Extract data from univers using JAVA SDK

Former Member — Tue, 07 Jan 2014 17:35:04 GMT

Hi experts,

I have a Univers that provide the list of Open sales orders from SAP BW. Our client need is to be alerted by mail whenever a sales orders is beeing open for more than 30 days ...

First question : Is there any standard solution in BO to meet our need.

Second question:

If there is no standard solution, How can I read the result of this univers, so I can create a code using java SDK to get the list of those Sales orders...

Thank's a lot.

Abdess,

Re: Extract data from univers using JAVA SDK

DellSC — Tue, 07 Jan 2014 17:41:16 GMT

I would create a Webi report based on the universe and use that to determine whether there are orders that have been open more than 30 days. A universe does not contain data. It is a set of metadata that the BO reporting and analysis tools, such as Webi or Crystal Reports, can use to build a query that is used to pull data for a report.

-Dell

Re: Extract data from univers using JAVA SDK

Former Member — Tue, 07 Jan 2014 17:44:26 GMT

Thnk you a lot Dell,

Is there any standard solution In BO to send Email when a Value in web intelligence meet a condition?

If no, can we read a web intelligence data using BO JAVA SDK?

Thank's again.

Abdess,

Re: Extract data from univers using JAVA SDK

DellSC — Tue, 07 Jan 2014 17:56:11 GMT

Some of this depends on which version of BO you're running. In 3.1 and below, you might be able to do something using a Publication. With 4.0 and above, there is some new alerting functionality that you might be able to use for this - I really haven't played with it, though, so I'm not certain how you would go about using it.

-Dell

Re: Extract data from univers using JAVA SDK

Former Member — Tue, 07 Jan 2014 17:59:42 GMT

Hi Dell,

Actually I am on BO 4.1 SP01... I will lean about Web Intelligence alert functionnality ...

Thank's a lot.

Abdess,