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