This blog describes a functional and practical use of

for one use case – merge data from 2 result sets (fill a structure or append a column).

For today, only a primitive options are possible, but anyway it is a good start…

Use Case 1. Fill an Empty Structure.

The master Result Set looks like:

ds_start.PNG

The slave Result Set looks like:

ds_merge.PNG

Selection Options:

selec.PNG

Explanation:

  • Column Index in Slave is “2”, means that the “Region” will be read out.
  • Multiple Matches is set to “Collect”, means that the entry is inserted separated by ,

You have to use the component “UI5Table” for visualization, with following settings:

tabnl.PNG

It means, in this setup, the table is not requesting data source directly, but is taking the shared result set after data mash-up.

Use Case 2. Append a Column from 2nd Result Set.

The master Result Set looks like:

r1.PNG

The slave Result Set looks like:

r2.PNG

And the result (carefully! the selection is today only on column 0 – so it works only for such simple resultsets)

rr.PNG

and, as a result there is a combined result set from 2 data sources.

Examples of used BIAPPs:

org-scn-design-studio-community/applications · GitHub

  • SDK_DATAMIXER_P1 (the first case)
  • SDK_DATAMIXER_P2 (the second case)

This is a start only, next is:

  • extend the selection capabilities to more than one column for APPEND
  • think about right / left joins and unions
  • finalize and describe the rules for conditions

I hope someone of you will be inspired on this direction.

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Tuan Nguyen Dinh

    Hello Karol Kalisz,

    I was following your steps to get my datasources (SQL – BW) working together but I’m facing an issue to display the result of the resultmixer component.

    The UI5Table just make my application goes blank.

    I’ve also tried the new UI5 Table 2.0 but the result seems to display default value in the table.

    Is there another way to going through the resultmixer data?

    I’ve seen a method called SetFeedingComponent for the charts but don’t find any documentation about it. Could this help my problem?

    Thank you in advance for your help.

    Kr,

    Tuan Nguyen Dinh

    (0) 

Leave a Reply