How to map a line item into a dimension
Hello, below my issue. I have a Module Product_FollowUp with product list and Time as dimension of this module. Inside the module, i have a line item "Assigned Resources" based on a list of Resources and others line item with number (ie : "Validation Done"). The Ressources is not a dimension of this module. I need a Module Product_Weekly&Resources_Recap to recap by Time & Resources the product Validation Done. What will be the best approach in order to avoir to have the Resources as a dimension in first Product_FollowUp module ? Best Christophe Ballihaut
Tagged:
0
Best Answer
-
Hi Christophe,
If 'Validation done' is a number, then the formula in your target module should be
Products_FollowUp.Validation done[SUM: Products_FollowUp.Resource]
If it's a boolean, then the formula is
Products_FollowUp.Validation done[ALL: Products_FollowUp.Resource]
Corresponding help page on Anapedia: https://community.anaplan.com/anapedia/calculation-functions/aggregation-functions0
