About andre.lie

andre.lie

Hi @timothybrennan, I wonder how we get the seasonal pattern in the last screenshot. My understanding is that in general, if the data has a trend, we can get seasonal pattern only after we remove it first. Thanks

andre.lie

This is great for visualizing how the forecasts track the actuals. The accuracy metrics generated for the forecast models are useful for model selection within PlanIQ but it might not be informative for most of the users. The availability of this backtesting within Anaplan will help visualize the model performance.

andre.lie · ‎11-24-2021

Hi @timothybrennan , It is a great dashboard. I understand PlanIQ will do cross validation based on (historical) Data Collections used to train the model (and hence we get all those forecast accuracy metrics once the model fitting is done). As the dashboard shows dynamic metrics based on evaluation horizon, I am not sure about the timing we can do this analysis. - Does it mean that we need to hold some data and exclude them from the Data Collections and build the MAPE calculation manually in Anaplan module outside PlanIQ? - As the forecast results generated by PlanIQ are the out-of-sample forecast, does it mean that we can only do this evaluation horizon metrics analysis after the actuals are available, so for 6-week evaluation horizon, we need to wait for another 6 weeks for the actuals to be available. Regards Andre

andre.lie · ‎10-08-2021

This is a good addition to PlanIQ. What is the size of the Forecast Analyzer model template?

andre.lie · ‎09-20-2021

@EvgyK , I have setup the historical data collection as per recommended course above, created forecast model (Anaplan Auto ML) and action, and imported the forecast results back to the model. I wonder if there is any further course that walk us through how different algorithms affect forecast results based on the same sample historical data collection. I understand there is 'Deep dive on the algorithms under the hood' but it might be too high-level to understand how each affects the forecast results.

andre.lie · ‎09-09-2021

@EvgyK , thanks for the response. The link returned this error message. Can you please advise the course name?

andre.lie · ‎09-08-2021

嗨@annejulie, is there sample model (with historical data) that can be used with the E-Learning course? Regards, Andre

andre.lie · ‎09-02-2021

Hi @Jacob3 , the Applies To of your EMP02 module is the full E2 Employees# list. Hence, you cannot see the subset in the Pivot. Pivot will not show the subset even though the list has a subset if the subset is not used as part of the module lists. Please double check the instructions for creating EMP02 module activity whether the module should use full list or subset. If so, go to the Blueprint and change the E2 Employees# in the Applies To to the E2 Employees#.Active? subset. Andre

andre.lie · ‎09-01-2021

Hi @Jacob3 , I do not think there is anything wrong with your filtered view. The screenshot in the course material might be incorrect. E2 Employees#: Active? is a subset. You might have missed the activity that requires you to load an employee file to create and update that subset. Regards, Andre

andre.lie · ‎07-26-2021

Hi @Fanny The E2 Employees# is a numbered list. We cannot load the data based on the employee name but to use employee code. The error message you saw 'Item not located in E2 Employees#' list means that Anaplan cannot map the employee in the file to the one in the list even though this list uses employee name as display name. Regards, Andre

andre.lie · ‎07-14-2021

@ashish.banka, thanks for sharing your experiences on the issue. @JaredDolich, thanks for adding @DaanishSoomar into the loop.

andre.lie · ‎07-13-2021

It was confirmed by the Level 3 Support that these errors were due to issue at Anaplan side during the specific window when the Anaplan Connect scripts ran.

andre.lie · ‎07-13-2021

@ashish @QJ,如上所述。河岸,@abhay.kanik , you need to use Column Headers instead of Fixed line item. Once you change this to Column Headers the SYS08 tab will show the source columns that you can use to map to target line items. Regards Andre

andre.lie · ‎05-27-2021

Hi All, We have a number of Anaplan Connect scripts with certificate authentication, let's say 10, as part of a daily job. Somehow, jobs # 1-3 were successful, # 4-6 were failed, and # 7-10 were successful again. I wonder if the those failed ones were due to connection issue during that point in time as prior and subsequent jobs were successful. Different error messages were associated with the failed jobs: Error 1: Script just stopped with these last messages: 2021-05-28 07:37:22 INFO [t.AnaplanApiProvider:119 ] 9892 |-- Setting up proxy... 2021-05-28 07:37:25 INFO [t.AnaplanApiProvider:119 ] 9892 |-- Setting up proxy... 2021-05-28 07:37:27 ERROR [c.a.client.Program :650 ] 9892 |-- Anaplan API: Error 2: Certificate Authentication failed....server is temporarily unable to service your request. Not sure why it failed to authenticate if the jobs # 1-3, 7-10 were successful 2021-05-28 07:34:11 ERROR [c.a.client.Program :650 ] 1960 |-- Anaplan API: Certificate Authentication failed! (Feign: status 503 reading AnaplanAuthenticationAPI#authenticateCertificate(String,String); content: 503 Service Temporarily Unavailable

Service Temporarily Unavailable

The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.

Error 3: Failed to retrieve data from remote server (caused by: HTTP/1.1 500 ) 2021-05-28 07:36:04 INFO [c.a.client.Task :3880 ] 8620 |-- Import connector: Failed to retrieve data from remote server (caused by: HTTP/1.1 500 ) 2021-05-28 07:36:04 INFO [c.a.client.Task :3880 ] 8620 |-- errorMessage - Import connector: Failed to retrieve data from remote server (caused by: HTTP/1.1 500 ) Regards, Andre

andre.lie · ‎05-24-2021

Recently we found our Anaplan Connect job failed because the integration user account to run the Anaplan Connect script was locked due to five failed login attempts. However, only Anaplan Support can check this information. It will be useful if the user status if also displayed as part of the Users setting in the model. Andre

andre.lie · ‎05-24-2021

When we export module blueprint to a file, list formatted line item has the list ID as value in the Format column instead of the name of the list itself. It will be useful if the list name is also added so that the exact list used by a specific line item can be known more easily without referring back to Anaplan blueprint.

andre.lie · ‎05-24-2021

While I have not really noticed the third suggestion, improved functionalities on the first two would be very useful.

andre.lie · ‎05-24-2021

Hi @gnaneswar , I think it will be helpful if you can also share the screenshot of your filter and target modules. Regards, Andre

andre.lie · ‎04-26-2021

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