Providing different templates for input based on selection
Hi team,
I'm currently working on a supply chain project.
We have a use case where we need to provide the user a template to input the attributes. But, the tricky part is not all the attributes needs to be populated for all the products. For example,
Let's say for 'Product A' only Attr1 and Attr2 is required in the template. Where as, For product B only Attr4 needs to be shown.
| Attr1 | Attr2 | Attr3 | Attr4 | |
| Product A | abc | 123 | ||
| Product B | xyz |
Kindly let me know if there is an efficient way to implement this in Anaplan.
Thank you in advance,
Sooraj
Answers
-
You can either use Excel add in or create a Single template for all the attributes.
If you want to use Add in then make sure you create Read/Write connection and all these attributes are within SYS module and not in the list properties.
If you want to use Import then make sure Users input only those fields which need to be input and will keep rest of the attributes blank but the template should show all the columns for all the attributes.
Hope that helps
Misbah
1 -
You can filter the line items in the grid based on a systems module dimensioned by the product list and a line item subset of the module to be filtered.
Assign the correct line items to each product and use a filter line item to drive the update of the grid on the dashboard.
Be mindful that you will need to create a saved view as it is not possible to apply a filter against line items in the ux.
1 -
Thank you for your response @ChrisAHeathcote
Creating a line item subset will not be possible here as the line items to be filtered are not number formatted.
Best regards,
Sooraj
0 -
Yes, my solution then will not work.
Unfortunately, I am not aware of an alternative.
1 -
You would have created an import mapping based on the template - once the import is set up you wouldn't want to change the template. I believe you can hide the column in the template but you can't delete it because deletion will throw the import off. And also since you would be working with .csv files hidden columns will be auto shown when you close and open it.
Misbah
0 -
If the formats of the attributes are the same, then you can use a line item subset, you just will not be able to use the collect function. In a "dummy" module, create those attributes as line items with a number format, create LISS Attributes. In the above module, you can can now apply the LISS Attributes with the line item being of the correct format, but remember, since this line item spans all "attribute" members, they will have to have the same format.
Suggestion, in the "dummy" module, create an extra line item named Total Attributes with the formula being the sum of Attributes 1 through 4 as this will act as a "Top Level" or. summary which can potentially help down the road. If you do do this, make sure, in the blueprint, that the IsSummary check mark is not checked.
Rob
0 -
0
