Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Merge on dimensions[not measures]

I am getting data from two different universes. I am trying to merge these two results based on a common dimension. Universe is not letting me do this. it's disabling one universe data elements when I select another universe elements in the report. Is it possible to Merge dimensions or BObj allows merging only measures?

query1:

Staff Name Service Name

query2:

Staff Name Activities Name

query 1 brings different rows from quey2 for same staff, but staff name is same. can these two be merged?

Thanks for any info on this.

Former Member
Former Member replied

>

> For a minute, I had my hopes up with your solution but when I tried, it was giving all "#Multivalue " in both the variables

>

> Looks like it's not working. But it's working fine in DESKi..

Is your data 1 to many? If so, try turning off row aggregation (though if it is you probably aren't going to get the results you want.) You can also try turning on Extend merged dimension values.

Working with merged dimensions can be VERY, VERY, VERY flaky and the behavior changes from SP to SP and at times even from FP to FP. I have to use them all the time and they drive me nuts by the lack of consistency.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question