We have a composite provider with the standard plan cube union with the actuals custom open ODS view for the plan/actuals reporting. Now we wanted to enable the material master display/Nav attributes in this infoprovider. so we created a material master CDS view based on MARA,MAKT etc and created a Open ODS view on top of this CDS view and trying to create a join in composite provider. but the join is not supported for this open ods view.
please advise how else we can achieve this real time master data additon in the composite provider