About joseantonio.galindo

Dear Community,    I have a question related to import transactional data (Net Sales) into Data Hub, with the following requirements: The Net Sales and Qty Volumes are grouped by more than 10 attributes required for Sales Planning Purposes. Best practices in Anaplan is to concatenate those attributes that will be the key for the line items, but in this case are more than 10 attributes so I think is not a good choice.  For this transactional it will be stored 3 years of data and it will be uploaded incrementally, means each month will be uploaded a delta.    Main concerns are: What should be the key for the line items? Concatenation of more than 10 attributes or a sequential number (taking into account that import is done based on deltas)?  It should be the time a dimension or line item in the module? Thanks for your support.      ... View more

Dear Support,    I think my Quarterly % calculation is not correct because according with the example on the user story 1.11:  The Years total is correct in my case but not the Quarters:      Based on training explanation the % should be calculated considering previous year data, therefore I've created the following line items:  - Historical Account Sales Target, from DAT04 Historical Revenue by Product aggregated for all the Products on the same Account f, this is provided in a csv file  - Total Historical Account Sales Target, from DAT04 Historical Revenue by Product the whole year.   - % account Sales target then is Historical Account Sales Target / Total Hist Account Sales Target   But seems is not correct, because for example considering Account Candyate the percentage should be 24,46549% but in my calculation is 24,5192%   Is that historical data the proper one to be used to calculate this %?   Thanks in advance, Jose.  ... View more

Dear support,    why I don't have on my profile all the badges like Level 2, Anaplan Way if I am already certified on those training?    Thanks in advance  Jose.  ... View more

Hi community,    I need some hints to be able to move forward in the training because I don't know if I am proposing the solution in the correct way. The point is that on the following exercise:   4.6.5 Sale Planning Model: DAT02 module In the Sales Planning model, create a DAT02 PY Revenue to CY module to carry forward the FY19 quarterly actual sales revenue to FY20 quarters   what I am doing is trying to import data from the Data Hub from module DAT05 Historic Revenue by Product (with dimensions A1 Account, P2 Product) into DAT02 PY Revenue to CY (with dimension A2 Account>Product#) into FY19 and after that, I will apply formula to carry into FY20. But I am struggle into import the data from Data Hub as source module has dimension A1 Account, P2 Product and target module has dimension A2 Account>Product#. Any hint on this?    Thanks in advance   ... View more

Hi community,    I am struggle with the step on Model Builder Level 3 to Import data from the Data Hub model to populate the  A2 Account>Product#  list   I've create on Data Hub the module SYS14 Create Account>Product and looks like:     Then, on Sales Planning Model, I've tried to import data from previous model / module and here is where I became block that I am not able to import correctly:    Thanks in advance for any hint or help you can support me.          ... View more

Dear all,    on this section is required for those line items:   Confirmed PO Delivery line item Confirmed Purchase Order Receipt line item   to use the formula OFFSET, but I am not able to manage the proper result using that formula but I was using the formula POST and please refer to the print screen    The tips on the training is to use OFFSET but I am not able to manage it using that formula, it is this correct using POST?   Thanks in advance and regards Jose ... View more