About stephen.hoffer

Model A has a process that imports data from Model B..both in same workspace.   This process runs successfully if triggered manually in Model A   I have succesfully run Processes that are currently importing Csv data on a daily basis.   I cannot figure out how to trigger the intra-workspace import using the Anaplan Connect.   Any ideas? ... View more

My ability to login to AWS and reach bucket is validated and all is good on the AWS side   Setting up the Cloudworks Connection seems to work and getting a valid connection.   When an Integration is being setup, I can connect to model and see what I would like to export from Anaplan, but the Data Target remains greyed out and the error:  Failed to load files from Amazon S3   pops up.   Our AWS administrator can see that there is nothing beyond the connection.   I am set with integration role...and have tried it by loggin in with our service account with full access that is used for all our Anaplan Connect API integrations...this role is also set as Integration role.   Any ideas on what might be preventing getting the integration part setup with Cloudworks?     ... View more

Is it possible to publish two pie charts side-by-side with same source module with 2 separate views, but each one filtered on a different value. The goal is to see pie chart  side by side to show product % under two different regions, as an example ... View more

I would like to hear any experiences both good and bad regarding ALM on complex models.   Maybe any contrast between using ALM for stable models versus for a model that is still has extensive development going on.     ... View more

I can set a batch file that works and exports data, a small bit, but if I switch the action to a different one, it returns only headers. This is the exact file minus username:password and action name and path are removed.   To be clear, the action run by hand exports a csv and the data is all there. If I run it via API/Anaplan Connect, it does not fail, it just does NOT include any data other than the headers/column names   @echo off rem For Windows OS : This example explains the usage of basic Authentication with Anaplan Connect. rem It also loads a source text file and runs an Anaplan import into a module. rem For details of how to configure this script visit https://help.anaplan.com/anapedia/Content/Downloads/DL_Downloads.html set AnaplanUser= set WorkspaceId="8a81b09c652b03b101654519bfe258d4" set ModelId="DD17AA9F21E34DEEB412DCAB475D4E29" set ServiceUrl="https://api.anaplan.com" set AuthUrl="https://auth.anaplan.com" set Export="MYEXPORTACTION" set FilePath="<MYFILEPATH>\Test.csv" set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId% -export %Export% -execute -get %FilePath% rem *** End of settings - Do not edit below this line *** setlocal enableextensions enabledelayedexpansion || exit /b 1 cd %~dp0 if not %AnaplanUser% == "" set Credentials=-user %AnaplanUser% set Command=.\AnaplanClient.bat -d -d %Credentials% %Operation% @echo %Command% cmd /c %Command% pause  ... View more

So if I have created a process that I use via  a dashboard button. Step 1: clears a list Step 2: The file to upload selection is available Step 3: You choose the file Step 4: You hit run   The process runs manually without issue.   If I use the Anaplan Connect, I created a .bat file and can trigger this process and it apparently works just fine, but I am NOT having to select a file.   What do I need to do when I run this process?   Do I need to create an Import of the file as a first .bat and THEN run the process? Or do I define the file and file path that the process uses?   The following is my script...minus removing any identifying Parameters: @echo off rem For Windows OS : This example explains the usage of basic Authentication with Anaplan Connect. rem It also loads a source text file and runs an Anaplan import into a module. rem For details of how to configure this script visit https://help.anaplan.com/anapedia/Content/Downloads/DL_Downloads.html set AnaplanUser="USERID:Password" set WorkspaceId="WorkspaceID" set ModelId="ModelID" set ServiceUrl="https://api.anaplan.com" set AuthUrl="https://auth.anaplan.com" set File="CY_GROWER_ANAPLAN_IMPORT.csv" rem set Put="C:\QlikDev\Anaplan\Templates\CY_GROWER_ANAPLAN_IMPORT.csv" -put %Put% -File %File% rem set Action="IMPORT_CY_GROWER_ANAPLAN_IMPORT.csv" -action %Action% set Action="CY Grower Orders Update" set Operation=-service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId% -process %Action% -execute -output "ERROR PATH" - Do not edit below this line *** rem set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId% -P   setlocal enableextensions enabledelayedexpansion || exit /b 1 cd %~dp0 if not %AnaplanUser% == "" set Credentials=-user %AnaplanUser% set Command=.\AnaplanClient.bat -d -d %Credentials% %Operation% @echo %Command% cmd /c %Command% pause     ... View more

Is it possible to setup an action where a report export to xls loops through all territories and saves a separate file?     ... View more