Key figure not populating in new multiprovider

Hi Experts,

Need your inputs for the below issue I am facing.

Requirement : to include Net_Price based on Material - Batch combination (calculated in a custom table in ECC) in the existing stock reports

Steps Taken :

1.Defined a custom data source.

2. Defined a DSO to store Net_Price with Material and Batch as key.

3. Defined a multiprovider based on existing material cube and newly created DSO.

4. Copied the existing stock query to the new MP with Net_Price.

Issue :

Net Price is not populating for the matching Material -Batch combination in the existing report. (neither at MP level)

Please let me know if I am missing anything here.

Thanks

Shikha