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?
Staff Name Service Name
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.
> 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.