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?