Data push fails from BSO to ASO when diff Sub Var used.
Summary:
I am trying to push data from a BSO cube to an ASO cube using a Data Map. My requirement is to move data from the Working version to the Final version. To achieve this, I am using substitution variables for the Version dimension. However, the source uses a substitution variable that resolves to Working, while the target uses a different substitution variable that resolves to Final. As a result, the data push is failing. however in jobs it shows that data map runs successfully but while validating through adhoc analyses then found that data not pushed. Has anyone encountered this scenario? Is it expected that a Data Map cannot use different substitution variables for the source and target Version members when they resolve to different member names?