Hi All,
I want to write a query on a multiprovider built on two transactional oDS.
The first transactional ODS will have :
1. Material
2. Avg rating
The secong transactional ODS will have:
1. Material
2. Vendor
3. Avg rating
Now, I want to build a MP on these two ODS' where the report should have:
1. Material
2. Vendor
3. Rating
4. Rating as a % of Avg rating
How can I do it?