cancel
Showing results for 
Search instead for 
Did you mean: 

Assign two Datasources to one chart

Private_Member_24235
Participant
0 Kudos

Dear all,

I am using DesignStudio 1.5 in BIP scenario and want to create a chart (column or waterfall chart) which gets data for its row of two datasources (BEx queries). My goal is to combine on the same level of characteristics two key figure rows of both queries, in other words, I want to add columns

In SCN I have found the description to use the following components: "Result Set Information Component" & "Result Set Mixer Component"

So far I have create two "Result Set Information Components" RESULTSETINFO_1 and RESULTSETINFO_2 as well as one "Result Set Mixer Component" in which I defined RESULTSETINFO_1 as Master and RESULTSETINFO_2 as slave.

According to , I see, that some coding has to be added.

Where do I have to add this coding?

According to I see, how to combine the result sets. But where can I assign this element to my chart. I was assuming to drag&drop it to my chart, but this is not possible.

Any ideas would be great. Thank you in advance.

Best regards,

Stefanos from Munich/Germany

Accepted Solutions (1)

Accepted Solutions (1)

d_chang
Participant
0 Kudos

Hi,

why not combine the 2 sources in BW?

regards,

Dwain

Answers (1)

Answers (1)

Private_Member_24235
Participant
0 Kudos

Hi Dwain, thank you, in the end I did it within BW by creating a new Multiprovider on the resp. cubes. thank you and best regards, Stefanos