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.
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.