Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Broadcasting to multiple e-mail addresses

Hi All

We need to broadcast a KPI workbook to a large number of Suppliers/Vendors.

We know we need to set up pre-calculation to do this which we are working on.

We have an additional problem.

Our users want to group Vendor codes under a single Supplier code. The workbook is designed to run by the Supplier code via a variable. There are multiple e-mail addresses for contacts at the Supplier:

Vendor 1 - Supplier 1 - e-mail1, e-mail2, e-mail3

Vendor 2 - Suppier 1 - e-mail1, e-mail2, e-mail3

Vendor 3 - Supplier 2 - e-mail4, e-mail5

Vendor 4 - Supplier 3 - e-mail6

so the Supplier code has a 1- n relationship with Vendor and a 1-n relationship with e-mail.

I had set up the data so both Vendor and Supplier codes are available in the infoprovider, e-mail address is an attribute of Supplier but we have multiple rows against each supplier, 1 row per e-mail address. Our BI team believes this will not work in the broadcaster as you have not got a one to one relationship between Supplier and E-mail.

Is the teams belief correct and if so can you suggest a solution?

Thanks

Jer

Former Member
Not what you were looking for? View more on this topic or Ask a question