Eclipse Community Forums: BIRT » Using the result of a dataset in another dataset

Home » Archived » BIRT » Using the result of a dataset in another dataset(joined datasets)

Using the result of a dataset in another dataset [message #742724]

Thu, 20 October 2011 15:20

Eclipse User

Hi I have a datase that retrieves a list of Servers and metrics, for example:

agent oid id
server1 CPUUsage 14
server1 MemoryUsage 15
server2 CPUUsage 16

and then I have the information of the avg, max and min measure for each metric in another table, for example

id date avg max min
14 2011-10-19 15:00:00 5 10 2
15 2011-10-20 15:00:00 6 20 4
14 2011-10-20 15:00:00 25 50 15

and both tables are related by the id field.

I want to create one graphic por each metric, that means one graphic for server1 CPUUsage (id = 14), server1 MemoryUsage (id=15) and server2 CPUUsage (id = 16).

So on the secon dataset used for retriving the values I need in the where clause something like id = (select id from table where agent = 'server1' and oid ' 'CPUUsage')

but this two values should be replaced dinamically for each graphs with the values from the first dataset (which has all the values of the server-metric possible relations).

IS there a way to do this? I wasn´t able to find how to acomplish this, any help will be useful

Re: Using the result of a dataset in another dataset [message #743197 is a reply to message #742724]

Fri, 21 October 2011 04:03

Eclipse User

Are you using BI Publisher? If so, forget about doing this inside of it. To accomplish this, the easiest way I know would be to create a web-service that will do the job, and load your that in the publisher from that WebService. You can also struggle with DataTemplate, but I don't think it can be done.

spring frame work

[Updated on: Tue, 13 December 2011 16:42] by Moderator

Re: Using the result of a dataset in another dataset [message #743510 is a reply to message #743197]

Fri, 21 October 2011 10:41

Eclipse User

Hi Daniel, BI publisher is a BIRT module?

Re: Using the result of a dataset in another dataset [message #748280 is a reply to message #743510]

Mon, 24 October 2011 11:53

Eclipse User

Why not use a joint dataset and join the two tables or use nested
tables. Look at this example for nested tables:

http://www.eclipse.org/birt/phoenix/examples/reports/birt2.1/subreport/index.php

Jason

On 10/21/2011 10:41 AM, Esteban Lus Bietti wrote:
> Hi Daniel, BI publisher is a BIRT module?

Previous Topic:	java.lang.ClassCastException: java.lang.OutOfMemoryError cannot be cast to java.lang.Exception
Next Topic:	horizontal printing in BIRT

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 25 17:53:37 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter