Merge measures belonging to two different intersection using multisource
In RPAS we want to merge measures belonging to two different intersections using multisource, but here the catch is that the base intersection is from two hierarchy spines of location hierarchy
For Example:-
Main hierarchy
loc -> store->channel->Market->Company
Alternate Hierarchy
loc-> store->channel->group->Market1->Company1
Now measure1(week_channel_sku), measure2(week_company_cku), measure3(week_company1_sku),measure4(week_channel_sku)
meas4 <- multisource(measure2,measure3,measure1,FALSE/TRUE)
we tried the above approach, but the meas4 is not getting populated for any level higher than the channel.
Is there any way we can achieve this by using multisource or any other approach. Any pointers would be great.