Extract data from univers using JAVA SDK

[Former Member]

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,

[DellSC · Accepted solution]

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

[Former Member · Accepted solution]

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,

[DellSC · Accepted solution]

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

[Former Member · Accepted solution]

Hi Dell,

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

Thank's a lot.

Abdess,