Skip to Content
0
Former Member
Nov 28, 2009 at 10:14 AM

Display Trade Price for all Customers - Trade Price maintained at Material

43 Views

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