Skip to Content
0
Former Member
Dec 01, 2006 at 09:20 AM

Query on transactional ODS

30 Views

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?