Cloudworks integration - import action with input parameter

Hi All,

I have an import action which required a target period as an input parameter to execute it. Then, a Cloudworks integration has been setup to execute this action. However, there is no way for me to input or setup the input parameter.

The cloudworks integration failed with the missing input parameter.

Any idea to get it work?

Thanks

Accepted answers

Ivan_Lo_

Hi,

A user want to import Opening Balance in the starting period every year.

And the data source is from Azure, not within Anaplan.

Even Cloudworks allow setup the action input parameter, it is still a challenge on how to populate the parameter dynamically into the setting.

I think the ideal solution is populate the target period from the source data.

Thanks.

All comments

M.Kierepka

Hi @Ivan_Lo_,

Unfortunately, such option is not available (yet?) in CloudWorks. I'd ask why you need dynamic period selection, and how CloudWorks would know which one it should put for a specific run? If it should be i.e. new month every time, then maybe you can make it two-step process:

1. Update "Current Month" line item (in some SYS module), using this method: https://community.anaplan.com/t5/How-To/Easily-Get-Current-Date-Using-CloudWorks/ta-p/120636
2. Pull this value to your import source view, and map this new column to your target Time dimension.

Hope it helps, please let me know if you tried this, and it worked or not.

Ivan_Lo_

Hi,

A user want to import Opening Balance in the starting period every year.

And the data source is from Azure, not within Anaplan.

Even Cloudworks allow setup the action input parameter, it is still a challenge on how to populate the parameter dynamically into the setting.

I think the ideal solution is populate the target period from the source data.

Thanks.

M.Kierepka

Yes, the best solution is to get this information from the source in a column (general rule is always fixing/refining you data in source - Anaplan is not data lake/warehouse/ETL system).

Another way can be setting up staging area in Anaplan - you import the data (to module without Time dimensions), then you pick/map based on some calcs/settings what should be the target period, and reimport it to the actual target module (with Time dimension).

Quick Links

Can you help?

Unanswered questions

Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?