Skip to Content

Assign two Datasources to one chart

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 Design Studio SDK: Result Set Information Component, I see, that some coding has to be added.

Where do I have to add this coding?

According to Design Studio SDK: Result Set Mixer ComponentI 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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 21, 2015 at 02:09 PM

    Hi,

    why not combine the 2 sources in BW?

    regards,

    Dwain

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 05, 2015 at 10:32 AM

    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

    Add comment
    10|10000 characters needed characters exceeded