How to map/split data from different sources with Webi

Hi experts,

we have two Universes that extract data from two BEx queries (unverses made with UDT, not BICS). This is the result set of each of the universe:

• Universe1 (transactional): PromoID, Calendar Month, Calendar Week, Value (key figure). For each row, if the Calendar Month is valued then the Calendar Week is blank and viceversa
• Universe2 (time masterdata): Calendar Month, Calendar Week. The result set contains, for each month, the weeks included.

Following an example of both the result sets:

Universe1 (transactional)

Promo ID Calendar Month Calendar Week Value P01 09.2014 # 1 P02 10.2014 # 0 P03 # 38.2014 1 P04 10.2014 # 1 P05 # 44.2014 0

Universe2 (time masterdata)

Calendar Month Calendar Week 09.2014 36.2014 09.2014 37.2014 09.2014 38.2014 09.2014 39.2014 09.2014 40.2014 10.2014 41.2014 10.2014 42.2014 10.2014 43.2014 10.2014 44.2014

This is the desired result set (PromoID along the rows, Week along the columns, Values in the cells):

Promo ID / Week 36.2014 37.2014 38.2014 39.2014 40.2014 41.2014 42.2014 43.2014 44.2014 P01 1 1 1 1 1 P02 1 1 1 1 P03 1 P04 1 1 1 1 P05 1

Can anyboy please tell me how this result can be achieved with Webi? Please note that underneath BW datamodel cannot be changed, i.e. we can't value Calendar Week for all the records that have this characteristic blank.

Many thanks for your help,

Andrea