About anand.shekhawat

anand.shekhawat

@ManjunathKN123 I don't think you could do that. ~Anand

anand.shekhawat

@UshaPriya Could you please post the snip of SYS00 Module showing the line items in the bluprint view please. ~Anand

anand.shekhawat

@UshaPriya You are getting this error because Anaplan is unable to locate 'Forecast Period?' line item in 'SYS00 Time Settings' Module. Make sure you have created it before using the same here in the formula. ~Anand

anand.shekhawat

Really appreciate @Misbah for the mention. It's a pleasure to be a part of such a great community. Shout out to all our mentors for all the support and guidance. ~Anand

anand.shekhawat

@diecht I don't think so we could implement something like that in Anaplan. ~Anand

anand.shekhawat

@diecht You can give a Formula driven Text formatted line item as the Warning display box. It will display whatever Warning message you want to get flashed when the Driver Boolean is checked or unchecked. You can also apply a conditional formatting on the Text Cell as well if required. Other then this if you want a Pop-up type warning message, I don't think so it can be done in Anaplan. ~Anand

anand.shekhawat

@rob_marshall After posting the comment, I also felt the same Rob. Thank you for the advice. Lot to learn Regards, Anand

anand.shekhawat

@paulnjr When we see the results here both POST and OFFSET look similar and are giving similar results. But when dig deep into the formula both POST and OFFSET works differently and would give you very different results depending upon the situation. Offset will fetch the value from 'x' number of periods in the future or in the past of your selected line item . Where as POST will push the value 'x' number of periods in the future or in the past from your selected line item, Also the interesting part lies here, it also sums up the values if any of the other Data items point to the same period. I hope it helps ~Anand

anand.shekhawat

@z77v303 Here you can write the conditions in both Read/Write access driver booleans. It would look something like below IF 'INP00 - Checklist'.Type = A THEN TRUE ELSE IF 'INP00 - Checklist'.Type = B Then False ELSE IF 'INP00 - Checklist'.Type = C THEN FALSE ELSE FALSE The above read/write access drivers will then drive your module/line item accordingly. ~Anand

anand.shekhawat

@z77v303 You can only set a boolean formatted line item as a Read/Write access driver for a line item (or for the module). Here what you could do is make the Read/Write access driver line items dynamic. To do this apply a suitable conditional formula on the access driver booleans to make it dynamic as per your selections in the drop down. ~Anand

anand.shekhawat · Re: Level 2 - Sprint 1 - 1.3.10.4 Check Your Work...

Hi @sp40684 It seems like you have not set the Parent of 'G2 Country' List. Kindly set the Parent of 'G2 Country' List to 'G1 Region' . So to do that kindly navigate to 'General List' Section and set the parent of 'G2 Country' as 'G1 Region'. You'll get the desired output as SIR @JaredDolich has shared. ~Anand

anand.shekhawat

@tejaswini You cannot do that in this module. You would require a different approach for that. Create one more module dimensioned by Employee List. Now import the Data (Text and number) with respect to the Employees. Now reference that data here in this particular module using a LOOKUP on Employee ID. ~Anand

anand.shekhawat

@tejaswini Yes you can do that, just filter on the basis of the Update(boolean) line item and create a saved view. Now use this saved view for the import. You will get only the checked items updated in the system. ~Anand

anand.shekhawat

@Efuacudjoe Yes so the logic here is, By using the formula - 'SYS00 Time Settings'.Forecast Period? you are pulling the Yearly data of 'Forecast Period?' line item. Why Yearly ? It's because the SYS01 Module is Time dimensioned and the Time Scale is set to Year. That is why if the summary was set to None in the earlier case, your booleans for the summary items(FY) were all blank. After setting it to 'Any' the booleans of FY in your SYS00 Module got checked in case any of the months of that particular year is 'True'. I hope it helps. ~Anand

anand.shekhawat

@Efuacudjoe Yes the formula is correct. Just set the summary to 'Any'. You will get your output correct ~Anand

anand.shekhawat

@Efuacudjoe Both the screenshots look good. Yes, you need to check one more bit. Kindly navigate to SYS00 Time settings Module and check if you have written a correct formula for 'Forecast Period?' line item. ~Anand

anand.shekhawat

@Efuacudjoe Please check the formula of Forecast Period? line item in the SYS00 Time settings Module. The formula should be written in such a way that the boolean is checked for all the forecast months Also make sure you have set the Current Period correctly in the time settings. You can find the Time settings on the top left in Model Settings panel. I hope it helps ~Anand

anand.shekhawat

@Efuacudjoe You can post the question here as well if you want. ~Anand

anand.shekhawat

@mahendra7 Kindly change the 'Zoom' settings from the three dots at the top right corner of your chrome browser. Zoom out to 80% or less if required. You should definitely be able to see the buttons. ~Anand

anand.shekhawat

@mahendra7 Yeah you are trying to apply a months only filter. Looks good to me ~Anand

anand.shekhawat

Yeah You Correct @SathyaM 🙂 Silly me, I changed the mapping to Prod model for some reason and forgot. Thank You ~Anand

anand.shekhawat

Hello Anaplanners, I am getting an error: 'Failed to retrieve field list from the selected data source. Please check your import settings and try again' while setting up a Model to Model Import. The dimensions are exactly the same in both the modules. Though few List Items in the Location list are missing, I feel its fine as they will be ignored during the import. But my point is Anaplan is not even letting me to do the mapping part of the import. Can anybody help me on this. I am attaching the snip below FYI : I am having full access and admin access to both the models.

anand.shekhawat

@JerinJose Check the booleans opposite to Start Date and Leave Date. Post that select the appropriate date format, you'll see the dates matching on the left hand side of the dialog box. Click Ok and run the import again. ~Anand

anand.shekhawat

@Hali Sounds strange Could you please post the snips of both the modules. Please paste the blue print views as well. ~Anand

anand.shekhawat

@maheshpati Kindly drop a note with the screenshot to support@anaplan.com ~Anand

anand.shekhawat

@debayan1109 It is asking you to write a formula in REV05 Module using LOOKUPS. The data that you are asked to pull is from the module REV04 (which is an input module). The data that you will be fetching is supposed to be on the basis of Country and Product Family. I hope it helps ~Anand

anand.shekhawat

@abhi12K , It's absolutely fine, need not worry. ~Anand

anand.shekhawat

Hi @ShreyaR , You need not to select multiple ID's while doing the restore. You need to select only one ID, which you are confident about having all the Line Items present. Referring to the screenshot, the ID that needs to be selected is the one from where you started deleting the Line Items. You can term these ID's as a state of model at that particular point of time. Restoring the model to the selected ID means you are restoring the model at that particular point of time. I hope it helps ~Anand

anand.shekhawat · ‎10-28-2021

@SravanKumar Don't convert the given files to any other format, unless and until you are told to do so. Upload the downloaded file in the existing format only. Referring to your screenshot kindly map the E2 Employees to Code. Map the Leave Date and start Start date by clicking on the boolean as shown below. and then try to import the file. You will get it imported ~Anand

anand.shekhawat · ‎10-26-2021

@mohitlamba0101 When you import the 'Lock' line item into the 'Write' line item, an import action will be created for sure. You can publish that particular action on the dashboard. To elaborate Step 1) Create a saved view keeping only the 'Lock' line item field. Step 2) Now import it into the main view of the module by mapping the Write line item to the Lock line item. An import action gets created in the Imports section of the Actions. Let me know if things are still not clear. ~Anand