About ashish.banka

ashish.banka

@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

@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

@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

@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

@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

@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

@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

@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

@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

ashish.banka · ‎11-24-2020

@Kunal0489 I would be interested to know how you are building the flat lists. Ideally while building Flat lists, you would like to include Code for Flat List items which you can leverage to build a SYS module to get G2 Country List with Parent. And you can use the SYS module to load G2 Country list. You can use the similar approach to load G3 Location list with G2 Country List as Parent. Hope this helps. AB

ashish.banka · ‎11-23-2020

@kotoponus Yes. And you can leverage SYS Location module to populate other Location related lists too. The idea is to maintain details of a List in one SYS module and leverage it for Lists creation/ LOOKUP etc. Hope this helps. AB

ashish.banka · ‎11-23-2020

@kotoponus You do not need to export the data from the SYS module in Step 4 into a csv file. You can create an import using Module / Saved Views too using "Connect to Anaplan Model" and selecting the same Model and the corresponding Module / Saved View. This works similar to Import using CSV however in place of CSV, the source would be Module / Saved View Hope this helps AB

ashish.banka · ‎11-23-2020

@Kunal0489 It would be interesting to know how you are building G1 Region, G2 Country lists. Ideally you should be using Flat List (Region, Country) in combination with SYS modules(Region Details, Country Details) to import G1 Region, G2 Country List items and its code. AB

ashish.banka · ‎11-22-2020

@kotoponus Anaplan best practices suggest that any List properties or List Subsets should be populated via a module. Hence, I prefer below approach to load Lists, its properties and List Subsets. 1) Create a flat list items using a csv file. 2) Create a module using the newly created flat list. 3) Create line items in the modules (Step 2) which would correspond to List Properties and / or List Subsets. 4) Use csv file to import and load data into the module with List Properties and / or List Subset (Thus naming it as SYS module) 5) Create an import to load Flat List properties and / or List Subsets from the populated module (Step 4) Hope this helps. AB

ashish.banka · ‎11-22-2020

@Kunal0489 Can you check your G2 Country List items and its code? Also it would be interesting to know G1 Region and how you are mapping the Parent to G2 Country List. AB

ashish.banka · ‎11-22-2020

@neg177 Ideally you should be able to import data into Anaplan via a CSV file. This is how I would approach the load from Excel to Anaplan. 1) Convert Excel file into CSV file. 2) Create modules for each Excel tab (if you want to load all the Excel Tabs data into Anaplan) 3) Map the Time using "Time" tab during Anaplan Import creation 4) Map line items to the Excel / CSV row items. Hope this helps. AB

ashish.banka · ‎11-19-2020

@JaredDolich Thanks for sharing your journey and what it means to be a Master Anaplanner.

ashish.banka · ‎11-06-2020

@Pankhuri Could you please share the selection which you made while saving the Export. If you want to get the Export automated, ideally you should select "Administrators Only" option. AB

ashish.banka · ‎11-05-2020

@MarkTurkenburg I would prefer to use Order List functionality as suggested by @anirudh That the great way to manage List's Order. AB

ashish.banka · ‎11-05-2020

@brookec We have been using a service account and we did not have any pushback from our service directory team. However, I would suggest to check with your service directory team to create a dummy id and associate it with a valid email ID (may be a secondary email id which could be the Anaplan Platform owner email id) so that the password can be maintained by that user. AB

ashish.banka · ‎11-05-2020

@ankulkarni Did you try un-mapping the Parent field: Hope this would help AB

ashish.banka · ‎11-05-2020

@titanic_neo The Line Items - Current Period? and Current Period Start is BLANK in the screenshot, which suggests that in the Settings->Time->Current Period is not selected correctly. I agree with @chenjack.sonos , please look at the Current Period settings and populate it with correct month of the line items to work. Hope this helps AB