Skip to Content
0

Merging 2 queries into single crosstab

Nov 30, 2016 at 03:12 PM

217

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Tammy Powlas
Nov 30, 2016 at 05:01 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded