Welcome Guest! To enable all features please Login or Register.
Go to last post Go to first unread
#1 Posted : Tuesday, April 4, 2017 7:04:54 AM(UTC)
Rank: Advanced Member

Groups: extranet\Forum
Joined: 8/19/2014(UTC)
Posts: 109

Is it possible to combine data from different sources with different criteria in one combined bar chart?

For example one part of the data (from orders) needs criteria "invoice date = blank and shipment date = this year" and the other data (from invoices) needs criteria "invoice date <= year to date".

The data is now presented in different crosstabs with local criteria.
#2 Posted : Tuesday, April 11, 2017 7:17:03 AM(UTC)
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 514

Any chart is in fact just a graphical representation of an underlying crosstab. So whether you are looking at a chart or at a crosstab, you are in fact looking at 'one object'. It is a general rule that any single object can show data from one single cube only.

So the answer is 'No', you cannot do what you want - unless you somehow manage to combine the required data into one single cube. I cannot tell if it will make sense to try to combine these data. To do it, will require manipulation in your Data Warehouse - or you may try using TARGIT Data Discovery...

With TARGIT Data Discovery you can create an analysis with the two required crosstabs; then add these two crosstabs as two separate 'TARGIT Analysis' data sources to Data Discovery, and finally create a new Data Discovery cube on those two data sources.

BR / Ole
Ole Dyring
Users browsing this topic
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.



We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.