About kunal_311

kunal_311 · ‎06-29-2021

Hi,@jjconn13 @ChrisHeathcote, Can you please help me to clarify few doubts: 1) Significance of QUO05 Module, How to get Code and number line item. 2) QUO06 Module - Do we need to compare the QUO05 Number line item with QUO04 Low and High tenure? 3) SYS07 Module - I calculated the completed years as the difference between the current period and the start date. I think it needs to be calculated in days. How to calculate the same?

kunal_311 · ‎05-08-2021

Dear Team, I am Pursuing My Level 3 certification, I am not seeking help on Modelling But needed a small hint on the import view. I think I am missing something, I try to find the RCA but unable to solve it. Problem Statement- My import view of the G4T List is not coming as expected. Here for each Territory all account are showing up but expected was only those territories that are present for that account. But Expected was something like G3T list Is it because my DH model from where I imported in the G4T list has the below structure? How to resolve this?

kunal_311 · ‎05-06-2021

I was able to figure it out.

kunal_311 · ‎05-02-2021

Hi Team, I am facing 2 problems while importing into the numbered list from my Data hub model: 1) it's showing an Invalid Parent error. I have used Parent code while importing, Please suggest how to resolve this? 2) Even though import happens with error, the import list is adding below to the list where import should happen -please check Point D for more clarity. A) DH Model B) Numbered List where import needs to be done C) Importing Screen D) After Import - Import Happens with no parent but below the list where import should happened.

kunal_311 · ‎04-20-2021

Hi @ChrisHeathcote First of all, Appreciating your guidance on the said issue. The mapping was already there in the "SYS02 Account Details" module which we got by downloading the Level 3 Starter model at the start so No import as such is done by us in that case. To cross-check I again downloaded the starter model and rechecked my values in "SYS02 Account Details" and they are correctly mapped.

kunal_311 · ‎04-19-2021

Hi @ChrisHeathcote I used SUM as summary settings as it allows sum for all segments & for all regions. I tried other summary settings but they did not work. My solution Training Solution:

kunal_311 · ‎04-18-2021

Hi @Misbah @aahmad I am an enthusiast who enrolled in talent builder program to learn more about anaplan, I am stuck in User stories 1.7-1.10, Need Help regarding the same: My approach to calculate redistribution factor: 1) Aggregate Override & Hold values in "To Change" line item and subtract it from SUM of "Initial Accounts sales Target". 2) Then divide it from the ones where "initial account sales target" do not have Hold or Override Value. Got Stuck at: 1) To calculate sum of "Initial account sales target" i need to use lookup but when i use formula - Initial accounts sales target[lookup: A1 Account] but it is showing error. 2) To calculate the denominator do i need to use IF Else statement - IF NOT Overide And Hold then sum initial sales target. But how to put it in a formula? Any Hint/Clue is much Appreciated.

kunal_311 · ‎04-18-2021

Hi @BenHilgendorf @swapnil_J My approach to calculate factor: 1) Aggregate Override & Hold values in "To Change" line item and substract it from SUM of "Initial Accounts sales Target". 2) Then divide it from the ones where "initial account sales target" do not have Hold or Override Value. Got Stuck at: 1) To calculate sum of "Initial account sales target" i need to use lookup but when i use formula - Initial accounts sales target[lookup: A1 Account] but it is showing error. 2) To calculate the denominator do i need to use IF Else statement - IF NOT Overide And Hold then sum initial sales target. But how to put it in a formula? Any Hint/Clue is much Appreciated.

kunal_311 · ‎04-18-2021

Hi, I was validating my build of TAR04 module. While my All Segment data is matching, the individual segment data(small,medium,large) aren't. See attached image; first grid is my build and second the one from training. I checked my system module and all segments are mapped to each account. what is it that I am missing?

kunal_311 · ‎04-14-2021

Hi @ankit_cheeni Even i got the same response as shown by you in attached screen shot, I checked my system module and all segments are mapped to each account. Did you find solution?

kunal_311 · ‎04-14-2021

Thank you @jrimmer93 @ChrisHeathcote for your guidance. Got it correct by changing the year and mapping reference for the SUM function.

kunal_311 · ‎04-13-2021

I am struggling to understand what I need to do for this activity. I created a module with G2 Country and Segment dimension but I am not able to populate this module. Am I missing something? Attached screenshot Is this what the activity is asking for?

kunal_311 · ‎04-06-2021

Dear Team, I got stuck in one place while building SYS 14 module, i don't have my old Data Hub model - After 90 days WS models gets expired. Downloaded Data Hub from training - it was to u se a formula that references the entire timescale of the DAT05 Historic Revenue by Product module to filter for revenue greater than 0. Time scale of DAT05 - QTR? Dimensions of DAT05 - Products and Accounts Flat. Do I need to refer DAT05 Module with rev>0? i.e 'DAT05 Historic Revenue'.Revenue > 0 I tried but I am missing something here. Kindly guide what should be the approach to resolve this.

kunal_311 · ‎04-03-2021

Dear Team, I got stuck in one place while building SYS 14 module, i don't have my old Data Hub model bcz of which i downloaded from training. 1) If it was DH model - then Data? has a simple formula to see whether SKU Filter system module has data and if yes then check if any Product is their 2) If DH is downloaded from training - it was to u se a formula that references the entire timescale of the DAT05 Historic Revenue by Product module to filter for revenue greater than 0. The entire time scale of DAT05 - FY19 QTR? Do I need to refer DAT05 Module with rev>0? 'DAT05 Historic Revenue'.Revenue > 0 I tried but I am missing something here. Kindly guide. @Misbah

kunal_311 · ‎03-31-2021

Dear Team, In User Story 1.3 in Model Build Specification, it was asked to create a DAT05 model in the data hub. But DH Model does not have TR, Do we need to create a TR or I am missing something? @Misbah

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