Skip to Content

How to merge datasets in Design Studio?


We would be interested in migrating some of our existing WebI documents into Design Studio applications. We are checking/assesing the potential issues involved in this process and the most relevant question that constantly appears to us is the concept of "merged dimension". (=merging datasets from different datasources in DS terminology)

As far as we know it does not exist in SAP Design Studio. My question is: it is possible to handle it in some way? How should I manage the need of merging dimensions into my DS app? To Implement the merge in the UNX seems to be obvious solution but in our case this would require having to implement a lot of outer joins in ours universes. This might be useful in this case that may cause several other problems to already existing reports.

I would be interested in to know previous experiences of rebuilding into Design Studio previous existing WEBi documents that contained merged dimensions.

Does anyone knows if next release (DS 1.4) will alllow to merge datasets from different queries (=merged dimension)? It is a planned enhancement?


Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Sep 17, 2014 at 08:26 PM

    Hi Alfons,

    currently there is no plan to make the merge functionality in 1.4 release.


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 17, 2014 at 03:52 PM

    I don't see that functionality specifically mentioned in the webcast we had earlier this week (see Figure 1 at Design Studio on HANA - ASUG Webcast )

    I recommend submitting this as an idea on Idea Place at

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 09, 2015 at 10:50 AM

    Hello Alfons,

    did you found a way to merge dimensions within Design Studio. We have the same problems. Within Webi no problem but I do not see any solution apart from Universe via IDT.

    Could you give us a hint to your solution?

    Thabk you very much.

    Best regards

    Michael Wecker

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.