Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » 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 19:20 Go to next message
Esteban Lus Bietti is currently offline Esteban Lus Bietti
Messages: 21
Registered: October 2011
Junior Member
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 08:03 Go to previous messageGo to next message
daniel.coder.smith is currently offline daniel.coder.smith
Messages: 18
Registered: September 2011
Junior Member
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 21:42]

Report message to a moderator

Re: Using the result of a dataset in another dataset [message #743510 is a reply to message #743197] Fri, 21 October 2011 14:41 Go to previous messageGo to next message
Esteban Lus Bietti is currently offline Esteban Lus Bietti
Messages: 21
Registered: October 2011
Junior Member
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 15:53 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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:
  


Current Time: Fri Oct 24 16:17:38 GMT 2014

Powered by FUDForum. Page generated in 0.07982 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software