Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Data Cube generation
Syed Faraz
1)I have created a data cube combing data sets of two different data sources.
Find more posts tagged with
Comments
mwilliams
If you're just wanting to create a standard table using two dataSets, you could just join your dataSets by creating a joint dataSet and then use this dataSet for your table. You can do grouping and totals within a table. Let me know if this doesn't work as a solution for your issue.
Syed Faraz
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="92799" data-time="1324964130" data-date="26 December 2011 - 10:35 PM"><p>
If you're just wanting to create a standard table using two dataSets, you could just join your dataSets by creating a joint dataSet and then use this dataSet for your table. You can do grouping and totals within a table. Let me know if this doesn't work as a solution for your issue.<br /></p></blockquote>
Syed Faraz
I tried joining two data sets(one data set is from oracle source and other is from XML source) using joint data set, but it did not give output as needed(as per requirement).
Requirement in simple words:
Join two data sets and get a (third)joint data set.
Then do calculations on this (third)joint data set. (I tried and found that calculations can't be done...for example:dividing two columns and multiplying with a number in the joint data set)
mwilliams
Responded to same in this thread:
http://www.birt-exchange.org/org/forum/index.php/topic/24297-cross-tab-display/