- Community
- :
- About GeorgeDuckett
Ask the Community
-
Ask a QuestionGet answers to platform specific questions from Anaplanners everywhere.
-
Suggest an IdeaShare ideas for platform improvements, training, the Community, and more.
-
Get Training HelpComplete your training with support from the experts.
-
Contribute ContentWorkshop content, submit for approval, and contribute best practices to the Community.
-
Connect with CommunityShare feedback, ask questions, and get support from the Community.
About GeorgeDuckett
since
08-05-2020
Online
GeorgeDuckett
Occasional Contributor
Activity Feed for GeorgeDuckett
- Kudoed Re: How to I access a failure dump of an action within a process using the API for ashish.banka. 01-25-2021 01:00 AM
- Posted Re: API to access list of Process Steps on Anaplan Platform. 01-19-2021 03:24 AM
- Posted Re: How to I access a failure dump of an action within a process using the API on Anaplan Platform. 01-19-2021 12:58 AM
- Posted How to I access a failure dump of an action within a process using the API on Anaplan Platform. 01-18-2021 05:40 AM
- Posted API to access list of Process Steps on Anaplan Platform. 01-18-2021 03:21 AM
- Posted Re: Create new List Item from Module on Anaplan Platform. 10-28-2020 10:46 AM
- Kudoed Re: Create new List Item from Module for rob_marshall. 10-28-2020 10:46 AM
- Posted Re: Create new List Item from Module on Anaplan Platform. 10-28-2020 07:54 AM
- Posted Re: Create new List Item from Module on Anaplan Platform. 10-28-2020 02:18 AM
- Posted Re: Create new List Item from Module on Anaplan Platform. 10-26-2020 03:00 PM
- Posted Create new List Item from Module on Anaplan Platform. 10-26-2020 08:06 AM
01-19-2021
03:24 AM
In case it's useful, I figured out that once i got a process id for a given process I can query /processes/ProcessId to get the actions. I then query the list of imports to find the corresponding import details for any action that is an import, then I query files to get the info about the datasource: var anaplanFiles = await client.GetJsonObjectAsync<FilesResponse>($"https://api.anaplan.com/2/0/workspaces/{WorkspaceId}/models/{ModelId}/files");
Console.Write($"Getting list of processes.{new string(' ', Console.WindowWidth)}".Substring(0, Console.WindowWidth - 1) + "\r");
// Get details of processes
List<Process> anaplanProcesses =
(await client.GetJsonObjectAsync<ProcessesResponse>($"https://api.anaplan.com/2/0/workspaces/{WorkspaceId}/models/{ModelId}/processes")).Processes;
var processIdsByName = anaplanProcesses.ToDictionary(p => p.Name, p => p.Id);
Console.Write($"Getting list of actions.{new string(' ', Console.WindowWidth)}".Substring(0, Console.WindowWidth - 1) + "\r");
var anaplanActions = (await client.GetJsonObjectAsync<ActionsResponse>($"https://api.anaplan.com/2/0/workspaces/{WorkspaceId}/models/{ModelId}/actions")).Actions;
Console.Write($"Getting list of actions for each process.{new string(' ', Console.WindowWidth)}".Substring(0, Console.WindowWidth - 1) + "\r");
var processesActionsToRunTasks = ProcessesToRun
.Select(async p => (await client.GetJsonObjectAsync<ProcessResponse>($"https://api.anaplan.com/2/0/workspaces/{WorkspaceId}/models/{ModelId}/processes/{processIdsByName[p]}")).ProcessMetadata.Actions).ToArray();
Task.WaitAll(processesActionsToRunTasks);
var processesActionsToRun = processesActionsToRunTasks.SelectMany(t => t.Result).Where(a => !string.IsNullOrEmpty(a.ImportDataSourceId));
var usedFiles = processesActionsToRun.Select(a => anaplanFiles.Files.Single(f => f.Id == a.ImportDataSourceId)).ToArray();
... View more
01-19-2021
12:58 AM
Hi @ashish.banka, I kicked off the process using the API. When you say run the process via the API and check for dumps I'd be running the process using url https://api.anaplan.com/2/0/workspaces/{WorkspaceId}/models/{ModelId}/processes/{ProcessId}/tasks, but then what url would I use to check for dumps against the actions that the process runs (not a dump of the process itself)? That's what I'm having issues with.
... View more
01-18-2021
05:40 AM
I understand I can get an import's failure dump if I run the import, then get the task id, then construct a url: https://api.anaplan.com/2/0/workspaces/{WorkspaceId}/models/{ModelId}/imports/{ImportId}/tasks/{TaskId}/dump . My issue is that i'm running a process, which runs a number of imports. One of which has a failure dump. I have the ProcessId, and TaskId of the task that ran the process, however it's not the process that has a failure dump, it's the import within that, so I can't work out the correct url. I've tried things like "https://api.anaplan.com/2/0/workspaces/{WorkspaceId}/models/{ModelId}/processes/{ProcessId}/tasks/{TaskId}/dump" , however I just get a 404, presumably because the process itself doesn't have a dump available.
... View more
Labels:
01-18-2021
03:21 AM
I'm currently using the Anaplan Integration API to upload files and run processes containing imports. This all works great. Currently if I want to run a process I need to be careful to upload all files associated with any imports it runs beforehand. What I'd like to do is to query the process I want to run and discover what import actions it runs. I can then query those to work out what files I should upload first. I see I can get the current step of a running process, but I can't see how I can get a list of all steps that a process has. Is this possible?
... View more
Labels:
10-28-2020
10:46 AM
@rob_marshall They do want the individual figures for Sku by branch, so do need the skus under branches, rather than just the figure for all skus under each branch. Those numbers come from the flat lists, not hierarchical lists. That's correct that SKU to customer isn't 1-2-1. I think I follow your suggestion. I'll give it a go and see how I get on.
... View more
10-28-2020
02:18 AM
Hi @AWhitworth, Sorry, I'm probably not explaining myself clearly. The list items I need to create are for the branch-SKU combinations that need to be created as a result of combining the Customer, Sku forecast data with the list of customer branches, to create a list that's in terms of customer branches and SKUs. If I have a forecast of 30 for Customer Cust1 and product SKU1, where the customer has branch Br1, Br2 and Br3, but no actuals for that SKU1 for any branch of that customer for the same period, then I need to create the list items Br1-SKU1, Br2-SKU1, Br3-SKU1 where each branch has 10 of the original 30. My issue is creating those new combinations; the allocation I'm fine with doing via a simple formula. Those new Branch-SKU combinations (Br1-SKU1..) don't exist anywhere in the data directly; we have the list of customer branches; BR1, Br2, Br3 and the list of skus; SKU1 but I don't have anything I can import into Anaplan which has Br1-SKU1. I'm struggling with how to 'combine' the branches with SKUs in order to have something in Anaplan that can be imported into a list to create these new items.
... View more
10-26-2020
03:00 PM
Hi @AWhitworth Thanks for the quick response. My understanding is that the Create action is what I would use if I want users to be able to create list items one at a time, however in my use case the forecast comes from an external import, hence I can't expect users to manually add every combination of Branch and SKU applicable (based on the imported file's CustId/SKU combinations together with the historic actuals Branch/SKU split). Is there some way of automating their creation using Actions? Or is there some other method I need? The main case to handle would be where historic data doesn't contain any Branch/SKU list item because we've never sold the SKU to any customer's branch, but according to the data to be imported we will, therefore we must split the SKU evenly across the customer's branches. In that case the Branch/SKU combination won't be there as it never needed to be, up until now so to do the split, we need the branches created (with no user input beyond doing the import). I hope I've explained myself clearly. Is that possible?
... View more
10-26-2020
08:06 AM
Hi all, I have a hierarchical list of Customers where the bottom two levels are Customer and Branch. I've got a separate hierarchy for products which as its bottom level has SKU. Due to space considerations our Anaplan consultant created a level below Branch for SKU, where items are only created where there is data. We've got actions that import transactions into a LOAD list, then a DATA module in terms of that LOAD list with a view that facilitates creating Branch->SKU list items when they exist in the data. We now have the requirement that some forecast data is loaded in at the Customer and SKU level then broken down into Branches (based on actual data which is by Branch/SKU). Due to size issues I'm planning on creating a level below Customer which has the SKU, so we'd end up with; "P6 SKU", "C8 CustId", "C9 Branch", "C10 SKU" by Branch and now "C9 SKU by CustId". I can create the C9 SKU by CustId items using the same method as C10, however I'm trying get my head around how to handle breaking these figures down by branch, when the C10 items relating to each branch/SKU may not have been created for a given Customer/SKU. The step I think I'm missing would be a module that enables creation of the missing Branch/SKU C10 list items, however I'm not sure how to construct that. I'm new to Anaplan, and have only seen List item creation from a module that uses a LOAD list. Am I thinking about this in the right way? How can I get the additional C10 list items created so I can end up with a module that can do the spreading of Customer/SKU to Branch/SKU? Many thanks, George
... View more
Labels:
My Accepted Solutions
| Subject | Views | Posted |
|---|---|---|
| 58 | 01-19-2021 03:24 AM |
Posts I kudoed