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