Dear All,
I have a specific requirements, for which there is a data model as:
1] Primary Sales: stored in an InfoCube (Level at which data is stored- Material/Customer)
2] Secondary Sales: stored in an ODS (loaded through Flat File) (Level at which data is stored- Material/Customer)
3] Trade Price: stored in an ODS (Custom data source) (Level at which data is stored- Material)
4] Query to report Primary/Secondary Sales on a MULTIPROVIDER based on the above 3 InfoProviders.
Requirement:
To display Trade Price at Material/Customer level in the query.
Since the Trade Price from the source (Custom DataSource) is available only at the Material Level. I get the query result as:
Current Result
Material | Customer | Trade Price
100100 | ABC | <blank>
100100 | PQR | <blank>
100100 | XYZ | <blank>
100100 | # | INR 5.6
Expected Result
Material | Customer | Trade Price
100100 | ABC | INR 5.6
100100 | PQR | INR 5.6
100100 | XYZ | INR 5.6
Request help from everyone on the same.
Thank you.
Regards,
KunalG