Skip to Content
0
Former Member
Jul 26, 2016 at 12:01 PM

How can I maintain the relationship between MATERIAL and SALES REPRESENTATIVE as it is having N:N relationship

112 Views

Hi,

Currently we are working on NW BPC 10.1 Classic model.

we have three dimensions SALES REPRESENTATIVE,CUSTOMER and MATERIAL.

Now we have to create an input template as below

Page axis: SALES REPRESENTATIVE

Rows: CUSTOMER , MATERIAL, ACCOUNT

Column: TIME

Here there is a link between CUSTOMER and SALES REPRESENTATIVE as 1:N relationship. So, we can filter CUSTOMERS based on SALES REPRESENTATIVES with dimension override function.

But there is no link between MATERIAL and SALES REPRESENTATIVE to pull related materials as we have N:N relationship between these dimensions.

How can I maintain the relationship between MATERIAL and SALES REPRESENTATIVE as we have 400 materials in my dimension, we are unable to create the input form.

Regards,

Anitha