About anand.shekhawat

anand.shekhawat

@MarkWarren Thank You Mark for being so humble. Really appreciate Regards, Anand

anand.shekhawat

@nicoledawis If you don't want to use it as a dimension, create a date formatted line item and you can get the dates inputted as required. Refer below snip I hope it helps ~Anand

anand.shekhawat

@DarrenS You cannot make the line item to be driven by a formula and simultaneously be a input field. To achieve this functionality you can create two more line items and use the override method. So it will go something like shown below. I hope it helps ~Anand

anand.shekhawat

Hi @fimam3 , You can rename the Organization List by following the below steps. Step 1) Go to the general lists Step 2) Now double click on the above highlighted area to rename the list. I hope it helps ~Anand

anand.shekhawat

@jrimmer93 Follow the link and you'll find few more best practices. It might help you ~Anand

anand.shekhawat

@Dominika_Dudzinska Is it possible to please share some snips of your build ~Anand

anand.shekhawat

@tompatrickting22 , The import action will let you to import the data in all the cells if you have an administrator access of that particular model/workspace irrespective of the periods set in 'Edit From' and 'Edit to'. Once your admin access is disabled (like the end users) you can only import the data in the selected period only as set in 'Edit From' and 'Edit to' fields. The same goes with the Dynamic Cell access as well. I hope it helps ~Anand

anand.shekhawat

@ValentineLS The output is correct . In the REV04 module you have entered the value 5% for all the chocolates in the the Country US. But in the REV05 module the output is 420% because it is summing up the percentages of all the Locations under US and all the chocolates under each location. So to verify, select any location(lowest level) under US and any particular chocolate(lowest level) in the REV05 module, you will see 5 % only. I hope it helps ~Anand

anand.shekhawat

@cbowie Referring to your screenshot 1, the error is occurring because Anaplan is unable to find the 'Size' line item in the SYS06 module. Kindly navigate to SYS06 Product Details module and check if the line item 'Size' is created or not? For this formula to work, the 'Size' line item must be List(Size) formatted. Referring to your screenshot 2, you are trying a different logic for the same line item. Which seems incorrect I hope it helps. ~Anand

anand.shekhawat

@stukcup I think it got loaded, just click on the '+' to expand the hierarchy (follow the below snip) I hope it helps ~Anand

anand.shekhawat

@Sampriti.Anand I don't think so its possible in Anaplan. If this would have been a case then it would be very difficult for the End user to actually differentiate between 50 and 50 Million. We would lose the credibility of the data in all the other dashboards. What you can do is make the user to input 50 and edit the format of the data (refer below snip) And whenever you are using this data, just multiply by 1000000 in your calculations. I hope it helps ~Anand

anand.shekhawat

@ValentineLS Yes, you have to re-upload the file to get the numbers correct. ~Anand

anand.shekhawat

@ValentineLS Yes you can do that, just go to the blueprint view and change the format. It will be number only, but the radio button for percentage needs to be selected. Refer the snip below. I hope it helps ~Anand

anand.shekhawat

@tompatrickting22 'Edit to' and 'Edit from' is the best option to restrict the data feed into the specific versions. It should work. But if it not working out, your can use the dynamic cell access as well. Create a module with a 2 boolean line items with the versions and use it as a Read/Write access driver. Whenever required you can lock the specific time periods for any version you want. I hope it helps ~Anand

anand.shekhawat

@Vatsal30 If you have created a display name property, then that property should appear at the bottom in the below snip (taken from your uploaded files) under Property in List section But in one of your snips(shown below) you have shown the Display Name Property assigned in the list. One of the above snips that you have shared is incorrect for sure. If I assume that your second snip is correct then kindly upload the file again by mapping the 'Column 1: Employee' to Display Name while keeping the rest of the mapping same as 1st snip above. I am 100% sure, you will see the names in place of the #numbers. ~Anand

anand.shekhawat

@drathod Read/Write Access drivers are basically boolean formatted line items which enables you to access cell level data in that specific line item in which it is set. I would suggest you to go through the topic on Anapedia. I hope it helps ~Anand

anand.shekhawat

@NancyKhurana If you want to use a list in the target module then I would suggest use the Time dimension only. Follow the below snips for the result Below is the Target Module You can use your 'Time range' as well in the target module in place of Model Calendar. It will give you the desired output I hope it helps ~Anand

anand.shekhawat

@drathod You have got a subsidiary view created, seems like you need to correct the same before uploading the data. Looking at the mapping it seems you are uploading a half-yearly data. So make sure the time scale that you have selected is same for the line item and module i.e. Half Year. Now try to upload the data. I hope it helps ~Anand

anand.shekhawat

@drathod You are unable to see the data because, selective access is enabled for that P3 SKU list and it seems you have not provided read/write access to yourself from the grid view of the list. I hope it helps ~Anand

anand.shekhawat · Re: 2.4.11.3 Creating Roles

@drathod Here the training module is asking you to create a role. Follow the below snip to create the Roles After creating the roles, navigate to the adjacent tabs as well to assign access to the modules, lists etc For eg : I have assigned access of FTE list to 'Product family manager' Now the user role Product Family Manager has access to the FTE List. This role can be assigned to anybody who is present in the workspace, and it would be specific to this model only. That means if any user with the above user role logs into your model , he/she will only be able to see only those specific items that his/her user role is assigned to. It's just a user role setup, now if you want to give this particular access to any user present in your workspace just navigate to the users tab and select the model role against that particular user I hope it helps ~Anand

anand.shekhawat · Re: 2.4.11.3 Creating Roles

@drathod This is because you have Selective access enabled on the P3 SKU List and you have not assigned the correct access to yourself. So to enable and disable selective to a list kindly see the below snip I have used a FTE list. Now to enable and disable the selective access to a individual list member navigate to the grid view and set your email id in the Read or Write column against the respective list member This way you give the Read/Write access to the selective list member. I hope it helps ~Anand

anand.shekhawat

@zolzaya Both the screenshots are pretty much matching correctly. I don't find any reason as in why you are unable to select the top level. Please try once again and still you face any issue, kindly paste the dropdown snip of the page selector. I hope it helps ~Anand

anand.shekhawat · Re: 2.3.11.2 Create Saved View

@drathod Yep it looks fine, need not worry. Just make sure you don't miss any dimension. ~Anand

anand.shekhawat

@drathod The below formula is very precise and written keeping best practices in mind. There are multiple other ways to achieve the same functionality in Anaplan. Glad you found another way of doing this. ~Anand

anand.shekhawat

@drathod The formula used in the module is absolutely correct. You are converting a monthly % value into a weekly % value that you would be using in the further weekly dimensioned modules. So you can understand this in the below way The below is the Weekly Planned Data The below is the same data but planned monthly So the incentive percentage in the First table is the MONTHVALUE of the incentive Percentage of the second table I hope you understand the logic ~Anand

anand.shekhawat

@shivsamleti Yes you can enter the data. Kindly select the lowest level from the page selectors. For Eg: Select US in the first drop down and Chocolates in the second drop down, you will surely be able to input the data I hope it helps ~Anand

anand.shekhawat

@TamparaDora According to the error message, Anaplan is unable to locate your " DAT03 Historic Volumes'.Export " So to resolve this issue first of all have a clarity which data-hub you are actually using. Because from your screenshots it seems that you are unsure of the data hub that you have created the 'Export' saved view in. Write your name in square brackets in the suffix of your data-hub name. Then map the data hub, it would be easy for you. After mapping go to the DAT03 Historic Volumes module in the data hub and check if the historic volumes data and a saved view by the name 'Export' is present or not . If not then import the historic volumes data and rebuild the save view . Now try to run the action to import the data in the Supply Chain Model. I hope it helps ~Anand

anand.shekhawat

Hi @RamaC Kindly drop an email on support@anaplan.com stating your concern. They will be able to help you regarding the CS toolkit. ~Anand

anand.shekhawat

@TamparaDora The mapping seems correct. The only concern is the subsidiary view that you have created (ref below snip) My intuition says that your time 'Time Scale' settings for the module and Growth% line item are different. As I can see that the data needs to be loaded monthly, so 'Time Scale' settings needs to be set 'Monthly' for DEM01 Module as well the Growth % line item. Kindly correct it and reupload the data. ~Anand

anand.shekhawat

@PranayG You have just started building the module. You are on a correct track. Don't hesitate and just go ahead with your training modules, you will automatically figure out that how the ending inventory is getting calculated. Also make sure that you follow the training modules precisely. Hint: you will find all the values in this module itself to calculate the ending inventory. If you still struggle than we are here to help you out. ~Anand