Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » multiple data sets in data cube
multiple data sets in data cube [message #1278411] Thu, 27 March 2014 09:50 Go to next message
simon lu is currently offline simon luFriend
Messages: 1
Registered: March 2014
Junior Member
Hi

I'm looking for a way to have multiple data sets in a data cube.

I've linked groups which are from two data sets in one data cube. Then I want to add two summary fields from the two data sets, so that I can have two measure fields on the cross tab. However, it seems that I can only drag and drop the fields of primary data set into summary fields.

In the "Groups and Summaries" tab of "Data Cube Builder" dialog.
Is there a way to drag and drop the fields from the data sets in "Other" section into "Summary Fields (Measures)".

Any feedback will be appreciated. many thanks.

Report message to a moderator

Re: multiple data sets in data cube [message #1787341 is a reply to message #1278411] Wed, 23 May 2018 20:42 Go to previous messageGo to next message
Todd Gilson is currently offline Todd GilsonFriend
Messages: 1
Registered: May 2018
Junior Member
Old post, but I have the same requirement... is there any way to add a summary field from another linked data cube?

Report message to a moderator

Re: multiple data sets in data cube [message #1824544 is a reply to message #1787341] Fri, 17 April 2020 09:10 Go to previous message
Bryan Leow is currently offline Bryan LeowFriend
Messages: 8
Registered: April 2020
Junior Member
Apologies for bump, but is there a workaround for this in 2020 on BIRT 4.6.0?

I need to aggregate data within 5 different datasets, and then aggregate those 5 aggregations into a grand total.

As a simplified example,
dataset1
9am 10
10am 30
11am 40

dataset2
12noon 80
1pm 80
2pm 20
9pm 40

1) aggregate dataset1
2) aggregate dataset2
3) combine those aggregations for grand total over 12 hrs


I can brute force by creating a new data set via union, but they literally make my report take twice as long to run because im running the queries again...

Report message to a moderator

Previous Topic:Which is faster: having one dataset for all charts or one dataset per chart?
Next Topic:Browser Issues using Birt Reports
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 21:27:56 GMT 2024

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly