Skip to Content

join 2 Data Sources in 2 Crosstab

Hi, i Need to join 2 Queries in one Crosstab. I use Design Studio 1.6 and Import the Data Sources from BW. I have tried it with BYO DS. Nothing works. Can somebody help me?

I Need something like this:

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 15, 2017 at 02:53 PM

    Hi Piotr,

    For best performance and as a best practice, ideally you should link the two InfoCubes with a MultiProvider in BW and create a single BEx Query over the MultiProvider, rather than attempting to merge the data sources client side. If you must however, you can apply the approach described in the post Data Blending with Data Iterator and BYOD.



    Add comment
    10|10000 characters needed characters exceeded

  • Jun 16, 2017 at 06:54 AM

    The Approach described in the post does not work. There is a warning on start "The application has been saved in an older Version of the design tool. Saving any changes in the newer Version will make the application incompatible with older design tool installation". I can see only blank Screen.

    I Need to merge data sources also for another Projects, anyway I want to know how to do it.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Piotr,

      This is because 'SCN_OWN_DATASOURCE_BUILDER-20160310173344' Design Studio Application file was built on a Design Studio version that is prior to the one you are using. As the blog title mention DS1.6 if you are using the same then just find the right Service Pack. It should work then.