Merging 2 queries into single crosstab

[Former Member]

Hi All,

I am having a scenario, where i need to display data based on two Bex Queries into single crosstab.

Ex: I am having 2 queries, one for Asia and one for North America, both the queries having same identical columns. except currency.

In my Dashboard Crosstab i need to display sales persons from both the continents based on listbox selection.

Is there a way to display results from multiple data sources to single cross tab?

Is the there any SCN SDK component available?

Note: I found this post in SCN but not able to find the component described in this post.

https://blogs.sap.com/2015/03/26/mixing-data-from-2-result-sets-together-join-select/

Environment: BI 4.1

Design studio 1.6 SP2

Thanks,

Kumar.

[TammyPowlas · Accepted solution]

Kumar - out of the box, merging/blending is more of a use case for Lumira Desktop, not Design Studio

One suggestion: use the new features of Linking cross tabs (or Grouping) with Analysis Office 2.4 (see https://blogs.sap.com/2016/11/28/reviewing-what-is-new-in-businessobjectanalysis-office-2.4/ ) and then going to Design Studio with it.