Skip to Content
avatar image
Former Member

Can we add two different measures from two different data source in single crosstab?

I have 2 different queries. I want to merge measures from this 2 queries in single crosstab. Is it possible in design studio?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 13, 2017 at 07:25 AM

    Hi Shreeyash,

    Merging data sources is not supported in standard Design Studio. What type of data source are you using: BW BEx, HANA or Universes? The recommended approach is to always merge the data in the backend. If this is not possible,you can try the approach described in the following blog post which takes advantage of Community SDK components:

    https://blogs.sap.com/2016/03/10/design-studio-16-data-blending-and-what-if-analysis-with-data-iterator-bring-your-own-data-source/

    Regards,

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 14, 2017 at 08:07 AM

    Hi Mustafa,

    Firstly thank you very much for prompt answer. I am using BW Bex as my data source and we are not allowed to use non-standard SAP components in our application.

    Regards,

    Shreeyash

    Add comment
    10|10000 characters needed characters exceeded