About jagalindo

Thanks @Anilkumarch    the point of use stagging list is that the combination of properties will be more than 10 properties, this transactional data has many granularity required by the business to be imported in Anaplan.    Best regards ... View more

Hello @BahalR   Please have a look to the system module SYS00 Time Settings and there you will find the line item PY Qtr that you can use to LOOKUP and those time period.   I hope it helps,  Jose ... View more

Hello @Kudiarasu    please take care of the ratio calculate on column 9 in which one you need to calculate PY Product Revenue (column 3) per PY Account Revenue (column 7), the result should be different than the one you have on that column 9. have a look to my PrintScreen   Best Regards Jose.  ... View more

HI @Kudiarasu    the calculation applied is not the correct one if you had the same values than me before.    Then, in order to calculate the Initial Account Sales Target you need to:   - Distribute the Initial Country Sales Target  (this you already got it when you applied the Stretch Goal % per product family and country) based on  - 1. Ratio PY Account Revenue per Total Revenue Country and Product Family Revenue PY  - 2, Ratio PY Product Revenue per PY Account Revenue   And then when you distribute the initial country sales target with those 2 ratios, you should have the proper values.  Let me know if this helps to understood better the ratios you need to calculate that it is where you are facing the error most probably.    Regards Jose.  ... View more

Hello @helennie    there is not specific explanation on the training to build those dashboards, but it is true that in some sections it will be explained some topics that will be required for the dasboards like:  - User Filters  - Assign Process  - etc   Good luck with the training 😉 Jose.  ... View more

Dear all,    after many reviews of my Sales Planning Model Level 3 I think that maybe I found where it could be the issue and I would like to cross-check with any of you:    In the user story 1.1 is required to build the baseline forecast, for which one it is provided a .csv file to be uploaded on the training and the result is the following:   In the other hand, it is also provided the Historical Actual Sales from 2019 to be uploaded in other module (DAT05 Historic Revenue by Product):     If we checked the total for all the products, exists a minimum difference between both modules (product family module vs account>product module)   Please could you confirm that this could be the issue of the small differences I have on my calculations?  Thanks in advance,  Jose.  ... View more

Hello please,    could someone help me with this issue, I've already finish the Level 3 but this module, the figures are a bit different and it is minimum and the reason could be the different percentages used to calculate the initial sales targets .    As you can see in the following print screen of my module, for example Nutzo Bar differs a bit from the example on the training:    Total all accounts is matching but by products and product families exists minimum differences.   I will explain my sequence to obtain those data that could be the reason on that logic:    1. There is a module in which one I've calculated Initial Country Sales Target for each Product Family based on Actual and % increased 2. There is a module in which one is calculated the Revenue for each account > product from which one I would be able to calculate the revenue for each account 3. There is a module in which one is calculated the Revenue per country and product  3. Initial Sales Target line item for each product to calculate Initial Sales Target per product.    With previous modules I am able to calculate following ratios: 1. Ratio PY Account Revenue / PY Country and Product Family Sales Target 2. Ratio PY Revenue each Product / PY Account Revenue 3. Ration PY Account Revenue / PY Country Revenue   With all that calculation the Initial Sales Target for each product is: Initial Sales Target by product * Ratio PY Each Product by Account * Ratio Country By product Family.    I need any hint here to know why my figures are not the same and differs a bit from the example to be able to start the technical exam   Thanks and regards Jose.      ... View more

Thanks @JaredDolich I will do that.  ... View more

Thanks @Misbah for your hint.    I just applied dimension A2 Account>Product# because the print screen on the next section of the training material to compare the DAT02 Model seems to be that dimension, as you can see according to the print-screen on the training material:   But agree with you that with dimensions A1 Account, P2 Product is better to import and then I can create other module with combined lists.  Thanks for your support.  Jose.  ... View more

Thanks for your hint and support.    I was able to import now and my list looks like this, for each product name, the account is the parent, the combined code Account_Product and the product name:    ... View more