About kunal_311

kunal_311 · ‎08-20-2020

Hi @einas.ibrahim , I imported with the said structure I have for DEM04 to DAT02, But there is something not correct: 1) Instruction is none of the values should be ignored and the error should be 0, but I am getting ignored value & error 0. Refer - After Import SS 2) Since Values got ignored, I suppose after importing the values are not reflecting in DAT02 when compared to DEM04. Refer - Import Screen SS & DAT02 After import SS What is it I am missing?

kunal_311 · ‎08-19-2020

Hi @einas.ibrahim 1) When I select NY as my page selector My demand data is static for all SKU i.e Nutzo bar_EN (8192) when I change it to Mumbai it still shows me the same results. I first got confused with the page selector, but now while thinking about it, the demand I suppose remains to be the same as it is not dependent on the Location. Is my understanding correct? 2) Rest is my View correct, showing monthly demand for each SKU?

kunal_311 · ‎08-18-2020

Hi @einas.ibrahim Ohh yes, I forgot to choose the lowest level for each dimension, I performed the below-mentioned logic on my dimensions & obtained the "DEM03 data file" as my view. Now while importing I am getting the SKU & LOCATION codes along with demand. But With the change in my location Demand data is not changing, Is it because we only considered P3 SKU as my dimension while referencing in DEM04? Now I got confused with the same type of issue smithevan18 is also explained in the below link but in his view, he is only getting all SKUs_EN(Nutzo bar_EN) line item for import is that correct or mine with the all SKU of Particular line item(Nutzo Bar). Eg - If selected Nutzo bar_EN Demand in my case is (8192) but in Evan case, it is (2048). Which one is correct? https://community.anaplan.com/t5/Academy-Training/Level-2-Conclusion-INV05-and-DEM04-Import-with-Subsidiary-View/m-p/71868/highlight/true#M1910

kunal_311 · ‎08-18-2020

Hi @einas.ibrahim Done.

kunal_311 · ‎08-18-2020

Hi Team, @einas.ibrahim I am facing difficulty while importing DEM04 saved view demand data in SC into DAT02 volumes data in FPA. I am not getting data in SKU, LOCATION CODE as can be seen in the IMPORT01 file. Also, my Demand numbers are coming up as weird numbers. Is that because I choose SUM as a summary method in "Demand"? DEM04 - Directly reference the final forecast line item in DEM03.

kunal_311 · ‎08-18-2020

Hi @einas.ibrahim I Use direct reference for my DEM04 demand formula referencing to DEM03 and did not use any of SUM OR LOOKUP function as suggested by you. But this is regarding the importing of file while doing to DAT02 in the FPA model, I am unable to get my SKU & LOCATION code as can be seen in detail in the below link, where I seek guidance but did not receive any reply, so seeking out to you. https://community.anaplan.com/t5/Academy-Training/Level-2-Conclusion-INV05-and-DEM04-Import-with-Subsidiary-View/m-p/78133/highlight/false#M2164 Can you help me why my solution didn't match with smithevan18 as he was suggesting that we are missing on SUM formula for our location line item?

kunal_311 · ‎08-17-2020

hi @sdavidko Did you get the solution of the location disabling problem as i am facing the same issue?

kunal_311 · ‎08-17-2020

Hi @smithevan18 I have selected the lowest level for SKU & Location as my first step but I am not getting results as per your Screenshot. i.e All EN SKU & I am getting demand value as sum of all weeks as we need to select Months time scale and also the summary in DEM03 Final forecast line item is "SUM". Am I doing something wrong?

kunal_311 · ‎08-16-2020

Hi @smithevan18 Didn't understand the meaning of below sentence I hide all levels in the SKU and Location lists except the lowest level. You can do this by pivoting your dimensions to the rows and manually reselecting only the lowest level of each dimension. Then I pivoted the locations back up to page selectors. Do we need to manually select EN(Lowest level) for all SKU & Location combination manually? Please Guide me on this.

kunal_311 · ‎08-14-2020

@Misbah I was able to figure it out. Thank You for your guidance.

kunal_311 · ‎08-14-2020

Hi @einas.ibrahim I think there is some printing mistake in Course, Even my INV Review screen shows the value as 2099, but when we review the Product Build DB they are the same number for FEB month changes to 2146. which leads to confusion. I was stuck in this for 4 days, as I used all drill-down method but didn't find anything wrong. Review Screen of "Review the INV01 Line Item Formulas and Summary Method settings" Review Screen for Product Replenishment DB

kunal_311 · ‎08-14-2020

I got it. Thank you for the help @Misbah

kunal_311 · ‎08-14-2020

Hi @Misbah Thank you for your guidance. When i applied the filter and sync it with Time then I am not able to extend the view of the Module in the DB. Can you help me how to do that? or it will remain as it is.

kunal_311 · ‎08-13-2020

Hi @einas.ibrahim I have seen the Screenshots provided by @Lkishko & @gauravj6 both used correct formula and which is same as mine as well but both have a different value for total inventory line item and mine values for total inventory is also different from them, so how can we validate our values, since the review file do not hold correct values.

kunal_311 · ‎08-13-2020

Hi @einas.ibrahim 2ND METHOD USING DRILL DOWN I use the drill-down feature and I drilled it down till DAT03 Historic volumes & SYS01 Module but not able to find the root cause as to why only FEB month has discrepancies & not other months. As you said the values are matching in DEM03 with that of the Product replenishment DB i.e 2099 but in Desired DB the value is 2146(Can be seen in trail messages Pictures attached). My values are matching with your Drill down option till whatever it can be seen. Trying to explain the Formula activity by not giving much information on the formula: 1ST METHOD CHECKING FORMULA 1) Baseline Forecast - If sys01 has 1st forecast year(i.e 2020) then offset DAT03 volumes for 1 st forecast year else offset default forecast by a year(-52), In our case FEB 2020 week 5 comes under 1st forecast year so DAT03 volumes offset takes place. i.e 2019(as can be seen in DEM03) 2) Growth Rate% - Referring DEM02 module for Growth% line item(attached file) looking in the sys08 product family. The growth % is imported by an excel provided in Course which have correct values

kunal_311 · ‎08-13-2020

Hi Team, @Misbah @einas.ibrahim I am Struggling with the data not auto refreshed in Safety stock exception DB. eg. If I select FY21 page selector then it is not auto-refreshing the data and even when I refreshed it manually then also I am seeing FY20 data. I have made show selection in my INV02 module for months as in Exercise the required DB was like that, Due to which the TIME Sync option is disabled for auto-refresh functionality to work & if I do show all then data will show having weeks as a column which is not needed. SER 00 - Desired View SER 01 - My DB settings

kunal_311 · ‎08-13-2020

Hi Team, @einas.ibrahim I was verifying my SYS01 module line item with what was given in training exercise I found discrepancies over theirs. IN my module line items like 1st Week of timescale? & Weeks only? line item are not present. For the 1st week timescale? line item I directly use OFFSET formula in Not 1st-week timescale? line item but I don't come across any instruction where we need to add Weeks only? line item. Am I missing something?

kunal_311 · ‎08-12-2020

Hi @Misbah Pivot part understood, Coming on formula, still not able to encode it The Excercise statement said - Filter to only show which product SKUs are stored at each Distribution Center which means filter needs to set on the mapping of product SKU & DC. which I tried implementing filtering on SYS08 module as it has both DC as well as product details , but not getting the result, can you please help me with the understanding.

kunal_311 · ‎08-12-2020

Yupp got this one

kunal_311 · ‎08-12-2020

In the activity following instructions were given, where I am confused with the highlighted one 1) Applying a filter to DAT01 Beginning Inv - I am confused as in how to show which Product SKU is stored at which distribution center, what i thought was in the line item Nutzo bar EN SKU & New york as distribution center should be equal. is that not correct? 2) SYS 07 & 08 want to show label of selected DC & Product. but I am confused about how to acheive that. As i am not seeing any option in DB to enable that

kunal_311 · ‎08-09-2020

Hi @einas.ibrahim Thank you so much, Was stuck in this for quite some time now, I know this concept but was not looking in the right direction. I can now link it very clearly. I have one simple confusion if you can help me with that. Review File - This was given in course to review my JAN & MAR month & week data are perfect but problem is with FEB month an week data. Desired highlighted in Red MY DB File - The green highlighted part is matching & Red part is not matching. Checked the DEM03 forecast value as we are referencing that module line item final forecast in INV01Forecast demand line item.'DEM03 Demand Forecast'.Final Forecast Updating Media Have i missed som I missed something

kunal_311 · ‎08-08-2020

Hi @Nivetha Attaching the examples of mine DB through which I can achieve the desired result but then not getting results in my monthly column. 1) My example - This shows the desired result I get by having the settings shown in "My example access driver setting" which is not aligned to your file. But the highlight section shows that I am not getting the result if I apply setting as in "My eg access driver setting". How to go about it? 2) My example summary setting: This shows the applied summary settings for the said line items. I am confused now as if I go by your instruction I am not getting the desired result, If I go by my logic I get the desired result but then missing on my monthly values as they are linked to my access driver settings. Please help me where I am doing a mistake. @Misbah @einas.ibrahim

kunal_311 · ‎08-08-2020

Hi @Nivetha If I go with the approach you are suggesting in the attachment, like only to give access driver write access for 1) submit PO req 2) Override Amount 3) override method then I am not getting the desired result as it was demanded in DB i.e only if my: Submit PO Req" gets selected then only rest of the below line items to be visible. But going by the settings suggested by you makes them visible as shown in attachment " Access driver 01" But the desired View needed is "Access Driver 02".

kunal_311 · ‎08-08-2020

Hi Team, I am facing a problem with the summary settings and their display on my DB. Problem Statement: Values not Displaying in my Month Column for line items like "Final Shipment amount" /"Shipping Cost"/"Final Shipment cost" 1) Course Example summary file - This is an example given in the course, the values need to be shown as given in the file. I plotted the summary method chosen by me as per my understanding of the said values. 2) Summary 02 - This file shows read & write access driver setting for the said line item so they can be seen as desired in DB. 3) My DB Summary - This is my DB file view where I cannot see the values of line-item like "Final shipment amount", "final shipment cost" is my JAN column, maybe because of my access driver settings, but if don't set them as they are then I am not getting my desired view i.e only when "Submit PO Req" Flag get selected then only show values of rest of the line item otherwise they should be hidden. Also, is my summary method for the rest of the line item is correct? (shown in "Course Example summary file")

kunal_311 · ‎08-04-2020

Hi @JussiLi The DB setting is adjusted as shown in the image. But my question was my chart view and the view in the course which we are referencing as "chart 02" is different. So wanted to know is I am doing something wrong?

kunal_311 · ‎08-04-2020

Hi @JussiLi I opted for show selection option and publish it as shown in "Chart 01". Which is different from what was given in course content "Chart 02". @einas.ibrahim @Misbah

kunal_311 · ‎08-03-2020

Hi Team, Before you publish the SYS01 Time Settings by Month module, showing the Planning Period Filter line item, filter it to show months only and save the view as Filter for Product Replenishment Dashboard. This is the requirement of the course. I applied the filter on months only & saved it as "Product replenishment DB" but when I published my line item of "Planning Period Filter" from system time settings month module to my DB then I am not getting the result as attached image(FILTER 2) Instead my result is showing as attached image(FILTER 1) These are the following steps I performed to complete the instructions, Is there something I am doing wrong/misinterpreting?

kunal_311 · ‎08-02-2020

Hi Team, I created the line item in SYS00 & 01 as mentioned in the requirement below. I am confused with the requirement mentioning not showing HY value until all weeks are checked. Please help.

kunal_311 · ‎08-02-2020

Hi @einas.ibrahim I guess the same issue was faced by another anaplanners as well https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-3-Shipping-costs-for-INVO5/m-p/71541#M1884 Thank you for the help.

kunal_311 · ‎07-30-2020

Hi @einas.ibrahim Now since I am done with my formulas and reviewing the same. INV01 Review File - This file is from the course and the highlighted value is 56 here(ALL PRODUCTS). INV01 My File - My module value which is 57( ALL PRODUCTS) INV01 My file(Nutzo Bar_EN) - The value for this particular line item is matching with the course review file(INV01 Review File). Only that one value is not matching for week 3 & now am not able to think reversely as in where I am wrong which lands up my "safety stock exception" line item increased by 1. I didn't tick the PO order checkbox.