About ashish.banka

ashish.banka

@rob_marshall Thanks for sharing.

ashish.banka · ‎04-10-2021

@ScriptStoryDude I am just wondering if you can work with the data integration team as Months data without year does not make sense. If you have months and years in different columns in the source file, I would assume you can work with them to include Month and Year to be concatenated before loading into Anaplan module. If that does not work, I guess, I would go with @ChrisHeathcote suggestion as a work-around. Hope this helps. AB

ashish.banka · ‎03-26-2021

@RavinderB Agree with both @Ingilavicus and @ChrisHeathcote . Just change the format of "Role" Line item from TEXT to Role List. That would help resolve the Lookup error. Hope this helps. AB

ashish.banka · ‎03-26-2021

@garima.rawat Not very sure from the error... however whenever you try to import from one model to another, I would always check the "Source Model" settings to check whether the source model from which we are importing is correct. AB

ashish.banka · ‎03-26-2021

@ClarenceA Looks like you have duplicates in the file. I mean you might be having multiple records for the same "Name" in the file which might be causing the error. Ideally when we load raw data from any external source or file, we need to create a Unique ID for each record, then first create Unique ID list and then load raw data in the module with Unique ID list as "Applies To". Hope this helps. AB

ashish.banka · ‎03-25-2021

@red11 Is this the link you are looking for: https://community.anaplan.com/t5/The-Anaplan-Way-Guide/ct-p/The_Anaplan_Way_Guide AB

ashish.banka · ‎03-25-2021

@spm18 It would be great if you can share the screenshot of the error. If I have to make an assumption... I guess that there must be a record in the source which has parent has "Null" which could be the cause for the error message "Invalid Parent". Please share the error message screenshot with the details of the error from Import action to help on this issue. AB

ashish.banka · ‎03-25-2021

@ClarenceA I tried replicating your file example and was able to load data without any failures Here are my Module Line item settings (Note: I assumed date in DDMMYYY format in the file) I guess... while loading raw data from file, you can look at Data line item to include "Date" format and use custom mapping to map the format of the data in the file Hope this helps. AB

ashish.banka · ‎03-23-2021

Thank You #AnaplanCommunity. You make learning Anaplan Fun!!!

ashish.banka · ‎03-19-2021

@Deepu I would definitely suggest to go through the link suggested by @Misbah . The link has all the steps required to set up email notification. When you review section #4 in the link, it suggests to more search criteria. I would suggest to add below string search in that section: 1) "ERROR" 2) "failed," 3) " !!! The operation failed !!!" You might find more such strings in the log file which you would like to include in your search criteria while performing error handling. Hope this helps. AB

ashish.banka · ‎01-27-2021

@tompatrickting I agree with @tbeilke . If you are using ALM, time setting would be migrated from DEV to PROD via Revision tag. I guess, we should include the request in Idea Exchange to exclude Time Settings from ALM. This would provide more flexibility while in development mode. AB

ashish.banka · ‎01-26-2021

@neg177 The best way to run a file daily is via automation. As @AWhitworth mentioned and @JaredDolich demoed, you can use the approach based on the tools and utilities available at your disposal. If you are interested in using UNIX shell Script to update flat file via Anaplan Connect via Cron scheduler, let me know and I can provide the required sample script for the same AB

ashish.banka · ‎01-25-2021

@Shailendr Great Question. I guess... if you are looking for an automation ID... I would keep it separate. 1) Create a NON-SSO system account for Anaplan automation (Exception User) 2) Assign Workspace Admin to the ID in Anaplan. 3) Get CA Certification of the NON-SSO system account for Anaplan Automation 4) Use CA Certificate in automation certificates. Hope this helps. AB

ashish.banka · ‎01-25-2021

@Shailendr No worries. Below are few links which would help you understand different authentication methods: CA Certificate : https://help.anaplan.com/en/23410167-f022-41fb-9f77-93c66e8e409f-Administration:-Security---Certificates SSO: https://help.anaplan.com/en/b5c78bc0-b39c-4e73-9e19-181399cef31d-Single-Sign-on-(SSO) Basic Authentication: https://help.anaplan.com/en/f5183f63-0a9c-4898-b4bf-5046bf9a78da-Standard-Web-based-Login Hope this helps AB

ashish.banka · ‎01-24-2021

@Shailendr If you are looking for automation via scripting or any integration tool, you need to create an exceptional user (Non-SSO system account for integration) which should have WSA (Workspace Admin access). Then you can either use Basic Authentication or CA Certificate in scripting or integration tool. Hope this helps. AB

ashish.banka · ‎01-22-2021

@Shailendr You can definitely import / export files to / from Anaplan platform even though your ID is SSO enabled and you are not a Model Builder / Workspace Admin. Your Model Builder / Workspace Admin should enable a dashboard for you which you can use to Import data into Anaplan / Export data from Anaplan. Hope this helps. AB

ashish.banka · ‎01-22-2021

@GeorgeDuckett You might want to follow below steps to get the dumps of failed imports which are part of process: 1) After running the process task : https://api.anaplan.com/2/0/workspaces/{WorkspaceId}/models/{ModelId}/processes/{ProcessId}/tasks, review the task by passing tasks ID to above URL: https://api.anaplan.com/2/0/workspaces/{WorkspaceId}/models/{ModelId}/processes/{ProcessId}/tasks/{taskID} 2) From the output of above, search for "failureDumpAvailable": true and get the objectID for the same. 3) Pass the ObjectID of the "failureDumpAvailable": true to the URL: https://api.anaplan.com/2/0/workspaces/{WorkspaceId}/models/{ModelId}/processes/{ProcessId}/tasks/{taskID}/dumps/{FailureDumpOjectID} The ObjectID is the import ID of the action which failed as part of the process execution. Hope this helps AB

ashish.banka · ‎01-22-2021

@Lavish Anaplan being a Planning platform should not be used for such purpose. Although Anaplan is a web-based platform but for such request, you should avoid using Anaplan. As David Smith says " Because you can, does not mean, you should". And I agree with @ArunManickam . Create a web-page outside of Anaplan and keep Anaplan from solving planning problems. AB

ashish.banka · ‎01-19-2021

@sandeep_bkyou are correct. However I assumed that @neg177 would be trying to load data into input line item rather than formula line item. I think it would be a great feature for Anaplan platform to disable mapping for those line item which does not have any data in the source file to avoid mistake. AB

ashish.banka · ‎01-18-2021

@GeorgeDuckett Just wondering whether you tried running the process via API or via Anaplan platform? I would suggest to run the process via API and check for dumps. Also if you are running the process from Anaplan platform, you can download the failures from the platform too. Hope this helps AB

ashish.banka · ‎01-18-2021

@neg177 It would be easier to understand the issue if you can share the source module, mapping module and target module details. Also the mapping module should have line item as list formatted for MIN to work. https://help.anaplan.com/c5c1e687-3d55-46ea-ab28-a7603eade586-x[MIN:y] Hope this helps. AB

ashish.banka · ‎01-18-2021

@neg177 It seems that the line items which are not mapped does not have any data in the source file, hence Anaplan engine is not allowing to map them manually. If you have values in those cells, it would either automatically map or allows manual mapping. Hope this helps. AB

ashish.banka · ‎12-11-2020

@DavidSmith I am so surprised to see your message. You have been like the strongest pillar in the community and your contribution can never be forgotten. I wish you all the luck for your new journey and you would surely be missed by the community. AB

ashish.banka · ‎12-11-2020

@tyagi_shub If you don't mind, it would be better to understand the issue if you can share the mapping tab details while creating an import from the saved view to list for list subset population. AB

ashish.banka · ‎11-30-2020

@lauragrippin Here the idea is to have a view created to import details of a list (Code, Parent) and create a Subset List using the system module line item. Hope this helps. AB

ashish.banka · ‎11-30-2020

@jmroesser It would be interesting to know whether you are trying to create a list or load data in a module, from the CSV file. Also, when the import is complete, you can check the details which shows how many records were created. AB

ashish.banka · ‎11-30-2020

@mgb14 Glad that it worked. AB

ashish.banka · ‎11-29-2020

@mgb14 It would be interesting to know the List which is applied to the module "SYS02 Region Details". Ideally the module should have G1 Region List in the applies to so that CODE function can work. Hope this helps. AB

ashish.banka · ‎11-28-2020

@kauldheeraj I guess the Transactional APIs published recently can be helpful in achieving the request you are looking for. https://anaplanbulkapi20.docs.apiary.io/#reference/process-actions Hope this helps AB

ashish.banka · ‎11-28-2020

@kauldheeraj Anaplan provides access to a Model if you have license for HyperCare. This model is based on the tenant of the organization and provides all the required info which you are looking for in a form of a Model wherein you can review Model size. This model is maintain by Anaplan platform team if you buy HyperCare license. However I am not sure whether Anaplan has exposed APIs to access all the information you are currently looking at. You can refer Audit APIs which could help you track the changes in the model : https://auditservice.docs.apiary.io/#reference/audit-events AB