About andre.lie

andre.lie

I understand that weekly reporting app and metrics i.e. Hypercare Reporting app is provided as part of Hypercare Enterprise (and Professional). It will be good if this data is made available as basic feature to all customers regardless of license as it provides valuable insights for customers on their models.

andre.lie · ‎04-01-2021

@SaraBTIT , not what I am aware of. I took @alexpavel advice on using Ctrl+F and it has been quite useful for my case.

andre.lie · ‎03-30-2021

I vote for this idea. We recently had a need to bring up an archived of production copy online to investigate moving numbers in the live production model. However, the production workspace is not big enough to hold both models. With this ability, we can import the model to another workspace.

andre.lie · ‎03-30-2021

Hi @SaraBTIT, I think it still works. For long list of actions, I need to scroll down the list to find the highlighted action.

andre.lie · ‎03-22-2021

Hi @ankitaga2000 , You can use History to see what have been changed within a period range. If you remember the last time they were all correct, you can start searching from that date. Here is the link to what you can view with this History https://help.anaplan.com/en/a49cfdfc-e921-44d6-8c73-026c1be4097b-History Regards, Andre

andre.lie · ‎03-16-2021

@abhinandan , we don't need to map them manually. You can use employee code instead of name.

andre.lie · ‎03-16-2021

I would love to see this ability. It will be useful when I need to debug the process by being able to create a duplicate process, edit it to contain actions that can be run in one go, and then debug the remaining actions one by one.

andre.lie · ‎03-05-2021

@ankitaga2000 , the Region Name is the name of the list item so it should be mapped to the Region Flat instead of Parent

andre.lie · ‎03-03-2021

Hi @SaraBTIT , My understanding is that you are trying to get unique user names for a specific department to build a list. I think you can build a filter module to input which department you want to export the unique names from. Use the input to filter the module where you have the user name. You might need to create a Boolean line item to check whether the department in this module is the same as the one in the filter module. Doing this, you might not be able to automate the build of the list as it depends on the selection in the filter module.

andre.lie · ‎02-19-2021

Hi @gowrid , you can use Pivot button to select which lists to be rows or columns and then save the module view either as default or a different one.

andre.lie · ‎02-17-2021

Hi @Shailendr , In the link provided by @JaredDolich https://community.anaplan.com/t5/Common-Support-Questions/Interactive-CA-Certificate-Guide/ta-p/58492 , there is a section 'Convert Your CA Certificate for API Use'. It lists what need to be done depending on whether the CER / CRT certificate you received is in binary format or not (I am not sure the difference between those two but I think you can try the CER file first). If it is in binary then additional step is required to convert it to .PEM by using openssl (needs to be downloaded separately). Once done, you need to split the certificate string in that PEM file if there are multiple certificate strings which are indicated by BEGIN CERTIFICATE, otherwise just use the file from the conversion. This edited file is the final PEM file that is required to be uploaded to Anaplan. I have not used CER / CRT but managed to extract public and private key from PFX / P12 certificate by following the instructions for these certificate type in the same link. Hope this helps. Regards, Andre

andre.lie · ‎02-15-2021

Hi @ankitaga2000 , it looks like either the P2 Products does not have P1 Product Family as Parent Hierarchy, or the P1 Product Family does not have the Top Level. You can check this by selecting General Lists within Model Settings Regards, Andre

andre.lie · ‎02-12-2021

Hi @margauxplet , this video link might be useful in estimating a model size. I am not sure if there is an app for this. https://community.anaplan.com/t5/On-Demand-Courses/Model-Size-and-Dimensionality/ta-p/63606

andre.lie · ‎01-26-2021

Thanks for the hint @rob_marshall !

andre.lie · ‎01-25-2021

Hi @CommunityMember123764 , I think you need to assign the % Profile in the historical module to four different line items, one for each generic quarter, by checking whether the Quarters line item is equal to Q1, Q2, Q3, or Q4. You also need to create four separate count line items with value of 1 if the Quarters matches with the line item. In the Weekly Profiles module, you can divide the sum of % profile with the count by either selecting Time.All Periods if Total of All Periods is enabled in the Time Settings or using TIMESUM if it is not. Regards, Andre

andre.lie · ‎01-20-2021

@Sitaraman , I hope you have been able to solve the issue. If you have not, it looks like that you need to load the Size line item in the Product Details module from a file.

andre.lie · ‎01-19-2021

@Bhavesh , what are the lists used in both modules?

andre.lie · ‎10-07-2020

@augustus.perera Since the difference between your source and target modules is the distribution center list, you can use SUM function based on the system module that has the same list as the source module and provides look up for the distribution center

andre.lie · ‎10-07-2020

@neg177 The system module that is used in the SUM should have share same list (level) as the source module of the data so that Anaplan can lookup the property of the list item. The SYS04 module that is used might not be at the same level as the INV01 module.

andre.lie · ‎09-29-2020

Thanks @alexpavel. I have tried the workaround, it is really helpful.

andre.lie · ‎09-07-2020

@wgallip The error message indicates something related to date or timescale. As the file to be loaded has Time in Y-M format, you need to choose mapping in Time tab that matches with this pattern.

andre.lie · ‎09-07-2020

@ThiruT, Why do you need Time list in the product and employee details modules? Regards, Andre

andre.lie · ‎09-02-2020

It will be great if there is a search functionality for a specific action within the Edit Process (or Create Action -> Process), especially useful for a model with long list of actions. At the moment, I need to search the action from Actions pane, note where its position is i.e. top, middle, or bottom of the list, and use that as reference when back to Edit Process.

andre.lie · ‎09-02-2020

This is a very helpful functionality. When I realize that I have difficulty in finding the module or view that I need, I have to go to the Modules pane and search for the module so that I can guess where it is when I am back to Select Source section.

andre.lie · ‎08-31-2020

Hi @SilviaDF , Based on your module's screenshot, I think you have done most of the things right. Here are answers to your questions. - You do not see commission % for each employee but there is total for All Departments because you need to format the commission as number with percentage units. It currently shows zero because the number is too small (smaller than 1). - You have already used Code column in the source file in the Mapping tab of the action, so it cannot be used again to load the Code line item in the module. What you can do is to write a formula for it by using CODE and ITEM functions - Anaplan allows source file to use different date formats. You are right to custom map the date line items. - I am not sure about the Active? column in the source file. It might be used to create an employee subset in another activity for another action. - You only need to upload the file to Anaplan once. If the action that does not load the data correctly, what you can do is go to Actions pane, find and edit the action i.e re-map, and run it again - Please review this link for more details on clearing target module https://help.anaplan.com/anapedia/Content/Import_and_Export/Import_Data_into_Models/Clear_the_Target_for_a_Module_Import.html You can always raise your questions in this forum. Regards, Andre

andre.lie · ‎08-31-2020

Hi @sshunter77 Anaplan allows source file to use different date format. We need to tell Anaplan which format is used in the file i.e. YYYYMMDD. In the line items mapping tab of the action, click the checkbox next to you date line item, and then choose the correct format

andre.lie · ‎08-31-2020

@tompatrickting How about having another module by Code3 (need to create it as a list) where you summarize the number of counts for each Code3 (group), and use that to compare with the Rank result. You can then use this as filter: - when Rank is equal to the group count or - transformed Rank i.e initial Rank - group count + 1. In this case, you always use 1 as filter

andre.lie · ‎08-25-2020

Hello Everyone, I am Andre in Sydney, Australia. I have been using Anaplan for two years and excited about the product. I am happy to help if you have any questions and believe that I could also learn something new in the process. Regards, Andre

andre.lie · ‎08-25-2020

Hi @neg177 You are building formula for a target line item in REP04 module. However, your formula tells that your source line item 'Salary' is also in the same REP04 module because there is no module reference in front of Salary. If source and target line items are in the same module, you generally do not need to use a LOOKUP. You might need to think whether your source line item is actually in another module. In that case, you can use either LOOKUP or SUM function to bring the number to REP04 module

andre.lie · ‎08-20-2020

The ability to 'select levels to show' for time will be also useful when we need to export data in grid layout that includes no summary for time while keeping summary line item in the export. Using Omit Summary Items option as workaround for time level will remove summary line item as well.