About Brunra

Brunra

Hello @dshafton , As mentioned above we have no access to the Apps during the training. You could do as mentioned above or create it within the model dashboard, which would be the easier way to replicate the requirements of such a task.

Brunra

Hey! There is an exam after each sprint (3) and an additional with the conclusion, making a total of 4. As for the attemps, at least there is an additional opportinity, although you could likely reach Anaplan for additional opportunities.

Brunra

Hey! There are two little nuances in this import. In the first window, where you import a file, you can define the row and column to start. Please check below. Then, you need to make a couple amendments to the way you were importing, please check below: Time: Column headers, you can see that it is on top. Note that you need to code it as YYYYMM in the time tab. Location: Fine Product: Fine Volume: Fixed line item Remember to check each of the tabs to make sure the mapping is taking place correctly! Hope that helped!

Brunra

Hello @krishnadbr , You have provided the detailed information about the lists, but not about the modules we are going to be correlating, and need to have a common dimensionality. As you well know, you have been required to provide the bonus for each employee depending upon the Employee's role and department. EMP03 provides you the information by role and department, but is not connected with each employee. SYS08 has teach employee´s department and role, but does not have the salary. If you think about the LOOKUP function (X[LOOKUP:Y1, LOOKUP:Y2]), the X represents the source module - what you are looking for (Bonus in this case)- while the Y corresponds with the correlations you want to establish (Role and department). I would encourage you to read the following, written by @AlejandroGomez : https://community.anaplan.com/t5/Anaplan-Platform/Lookup-Sum-and-Textlist-Cheat-Sheet/td-p/53085 Have a go at it and come back if you still do not manage to resolve it to compare answers!

Brunra

Hello @Winter01 , With regards to the formula provided, you are quite close. If fact the formula is about the same: In essence, when Shipping Method is not overridden and Override Method is blank - meaning the shipping method remains the same as defined- and this nature will be the most frequent, the value provided should be the original Shipping Method. If it is overridden, provided Override Method. IF NOT Override Shipping Method? OR ISBLANK(Override Method) THEN Shipping Method ELSE Override Method As for Country Made -within SYS08- you have the location and you are looking for the country right?, which in essence is the parent of the location. If you were to create an line item and use a formula to identify the parent from "Supplied by", what would happen? Hope everything above was clear!

Brunra

Hello @Winter01 , Without having the purpose in front of me, I understand that this value: Will only change in the case the Shipping method is changed. Hence you need to think that, as a boolean, there are two states for "Override Shipping Method?" either true or false When it is not overridden, the value will have to be 0, as there will not be no variance. This seems to be the most frequent situation. When overridden, it will be the difference between the original Shipping Costs and the newly calculated Final Shipping Costs. I hope the lines above were clear enough. If you still have doubts do not hesitate to keep asking!

Brunra

Hello @Anitha0209 , On a quick check, the baseline forecast matches. It looks like you are rounding your initial demand forecast down, try : ROUND(Default Forecast, 0, UP)

Brunra

Hello! It is actually working. As you can see Beginning inventory is "Ending Inventory" -in this case 0, when is not the 1st week of timescale. If you were to add the equation for this line item " Beginning Inventory - Forecast Demand + Confirm Purchase Order Receipt ", this should automatically fill up once all the information is in there. Apologies it took me a while to realise about this too!

Brunra

Hey! Beginning inventory: IF NOT 'SYS01 Time Settings By Week'.'1st Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory 1st week of Timescale?: INPERIOD(CURRENTPERIODSTART()) Please remember that your line items had a slight different name, such as "First Week of Timescale?". Once you amend this - better to enter the formulas manually rather than copy and pasting- it should work. Hope that clarifies it!

Brunra

Hello @dhinayadav, Unfortunately, we cannot provide answers about the exam. Having said that, congratulations, you are really close. Your clause for the target module ('SYS08'), [Lookup: 'SYS08 Employee Details'. Region, Lookup:'SYS08 Employee Details'. Role], is correct. The error comes down to the source module " 'EMP02 Employee Expenses'. Salary". Once you compare the dimensions you are trying to match from you target module with those that you are currently trying to use in your source module, you will realise that those are not really matching. This means that you will have to find for your source module that complements that from your target module. If you start looking in your target module you will find the solution soon. I will also leave you this thread to have a read, as it may be helpful in the long run. https://community.anaplan.com/t5/Anaplan-Platform/Lookup-Sum-and-Textlist-Cheat-Sheet/td-p/53085 Hope that helped!

Brunra

Hello @Winter01 , You are actually quite close to the correct solution. Regarding the 1st week period, I recommend you to read the link below: https://help.anaplan.com/3b64fe69-0d31-49b8-ab40-e7c1a3d01137-INPERIOD In essence, " INPERIOD(Date to test, Time period) ". Note that the Time period is optional. By using the INPERIOD you obtain directly a boolean response (e.g., TRUE or FALSE). When using this, alongside the CURRENTPERIODSTART(), (e.g., INPERIOD(CURRENTPERIODSTART()) ), you would be defining when the 1st week of the period took place. If you combine this, with a similar formula to the one you provided," IF NOT 'SYS01 Time Settings By Week'.'1st Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory ". It should work, while it would allow you to reduce one of your line items. Hope it helps, please let us know if that is not the case. Kind regards, Bruno Rodriguez

Brunra · Re: 2.4.11 Create roles and Test as End users

Hello @Winter01 , The idea is to test the access that each of the users under such roles would obtain. As such you should: Modify the different access in "Role -> List" Add any selective access requirements Change your role within "Users" tab and DO NOT remove your workspace administrator. You will note that many of the contents previously available will not longer show and you could see whether all the modules remain accessible in an usable way or the access you provided made some modules malfunction. Hope that helped! Cheers! Bruno Rodriguez

Brunra

Good Morning @dhinayadav , Have you tried to check the error given during the import? It usually provides some information about the reasoning. As you have well pointed out, it seems like the time has not been correctly imported. If you were to define it in periods as YYYYMM, where each character of the year and are identified, it should work. Please let us know if this resolves your issue, Cheers, Bruno Rodriguez

Brunra

Hello @Chau , I cannot answer with regards to the model downloaded, but you should be able to make the exam with the model you have created through module 1. Cheers! Bruno Rodriguez

Brunra

Hello! Just click twice over the name and you will be able to edit it 🙂 Cheers!

Brunra

Hello @Nehal1511 , Thanks for posting. The "Organization" general list comes by default with Anaplan, as it is built-in to ensure that at least 1 list remains within the "General List" tab. As such, you could rename or give a different application, but it cannot be deleted. Hope that helped! Bruno Rodriguez

Brunra · Re: Sprint 1 Importing Data 1.3.10.2

@Jacob3 Thanks for posting. If you are correctly identifying during the importing process the code, country name and parent. The list should get automatically updated. Having said that, could you please check that the elements in G1 Region have been imported and the code for each is included? At the end, that spreadsheet will be connecting those codes with G1 Region. Hope that helps! Bruno Rodriguez

Brunra · ‎09-22-2021

Hello @amruthasai7979 , You have two main paths towards your Anaplan journey: Elevate: Online course to walk you through the Model Builder certification - link above. 90 days trial: Make your own journey through a free 90 day experience learning at your own pace. https://community.anaplan.com/t5/Anaplan-Access-Beta/ct-p/ATBReg The access usually takes about 5 days for the free 90 days, while the Elevate program may vary depending availability and you will have to follow certain timeframes. If it takes more than 5 days, feel free to reach Anaplan and make them aware. I know that some people experience a longer waiting time, but the email should sort it out. Hope this helped!

Brunra · ‎09-21-2021

Hello @Anitha0209, After passing the test there is a survey, have you also finished that one? As soon as you complete the survey you will be provided your certification, which may trigger the "record of learning" to show it as complete. Hope that helps! Cheers!

Brunra · ‎09-21-2021

Hey, thanks for sharing your question. With the information provided we are a bit limited, but could it be that you are looking at "Candyate", while the example looks at "Candy Storevu"? Let us know if that does not make the trick!