About karank

karank

@sjbows I think this question is at par with the question "what is the meaning of life" and I believe the answer is "it depends" Thank you

karank

@Misbah I agree with what you saying but I want to make sure if it is even technically possible. It seems like its not even technically possible . Access control will act as a work around but people with access can still deploy. Even segregation of workspaces will not work as you still need someone to deploy structural changes from dev to prod to uat . May be it has to be managed by a business process rather than technically

karank

If you select DEV ---> Prod , it works but later on , when you create one more tag and push to UAT and then feel to take it to Prod from UAT, it will fail bcos UAT and PROD will not be in sync. I tried above and it syncs unless i am missing something . Below are the steps i followed Copied test and renamed prod ( deployed mode) now i have dev -> test ( deployed) -> prod (deployed ) did a rev tag 1 from dev --> synced to test and then synced prod from test did another rev tag 2 in dev and sycned straight to prod and not to test did another rev tag 3 in dev and synced to test now test has 1 and 3 prod has 1 and 2 i then synced test to prod successfully which means all are in sync

karank

Thanks for your response but my question was more around I only ever want to deploy from test to prod . When you try and sync prod it also gives dev as an option .

karank

Cool . I will wait if anyone has any other suggestions else yours is the answer

karank

Thanks @jasonblinn Should have mentioned there is only 1 workspace 🙄

karank

Hi Guys How do i setup ALM so that it only works From DEV -- > Test and then only Test --- > Prod Currently i have DEV TEST In deployed mode synced with DEV NO PROD PS:- I know this is against the best practice as we should do DEV --- > Test and DEV ----> Prod but trust me client only want above . Thanks

karank · ‎02-26-2020

This is brilliant! Thanks for sharing

karank · ‎02-13-2020

I think this will be great functionality @andre.lie . Will upvote it

karank · ‎02-13-2020

@AW25 Try this Change your URL from https://api.anaplan.com/2/0/workspaces/workspaceid/models/modelid/files/fileid/chunks/chunkid to https://api.anaplan.com/2/0/workspaces/workspaceid/models/modelid/files/fileid/ Change your postman settings to get max response size in MB to 0(infinite) PS: Postman has issues with large file so you might have to try few times . Alternatively try same in Alteryx hope this helps

karank · ‎02-13-2020

Try this if you haven't Re-upload the file as workspace admin Set the file to everyone Run API (without delete) Change value Run API (without delete) Check 3 and 5 value , file should be diff as you changed some values in output wait for 48 hrs Change value Run API (without delete) You should have updated file i.e whatever you updated in step 8 You should get updated file with changed value

karank · ‎02-13-2020

@Sunilkumar you are getting response 403 have you checked your log in credentials ?

karank · ‎02-13-2020

@AW25 This is expected behaviour . What i normally do is I open a file(this is my final output file) in write mode and keep it open and [Loop]then make a API request for chunk 0 , read content and write to the open file[LOOP] . I loop this until i reach the end of chunk count . Then i close and save the file . This gives me 1 complete file without breakage I dont know how to achieve above in either Alteryx or Postman . Hoping someone posts more solutions here

karank · ‎02-13-2020

This is worth trying i am assuming your Java is installed at this location C:\Program Files (x86)\Java\jdk1.8.0_241 if this is the case Change your JAVA_HOME env variable to below C:\PROGRA~1\Java\jdk1.8.0_241 Alternatively install/copy java outside program files so something like c:/java/.... Reason for this is windows uses short names for Program Files (x86) Try hopefully it works

karank · ‎02-13-2020

@Jared Dolich Below are the steps i follow Create the export manually and run the action in Anaplan. (Use Postman or Python to get the fileID) From the API, Run the Export Action Get the Task ID of the executed action Check if task status changes to complete Once complete only then Download The File I do not delete file . Unsure why would you delete file . Will be interesting to know if there are any reasons .

karank · ‎02-11-2020

Thanks Alexandru Much appreciated

karank · ‎02-11-2020

Thanks for F2 tip , very handy indeed

karank · ‎02-11-2020

Hi @szechovsky From my experience Anaplan data integrations is categorised into four main categories Manual :- This is where users will upload / download data into and from Anaplan manually via a dashboard button aur via anaplan provided excel add ins Anaplan Connect :- It uses windows batch files for uploading downloading data normally automated using windows scheduler . Third Party Connectors :- Multiple connectors available like mulesoft connector , informatica connectors etc. RESTful API :- Anaplan has surfaced API points which can be used to import / export data in and out of Anaplan . In terms of choosing which method :- It depends on many things like customers capabilities , scope, budget, scalability requirements, security policies etc. For eg. if your use case is working with multiple models and lots of data points segregated geographically ,things like manual or anaplan connect are not the best options . On the other hand if your use case is simple but your company policy mandates that it has to be through let say informatica then you have to use informatica connector or RestAPI. If you are doing a Proof of concept (POC) then its quicker to do manual etc. It is not an easy question to answer but from my exp I always prefer to go automated rather than manual . prefer to do most of my data transformations outside anaplan where applicable , always try to have an ETL later before anything goes into or outside anaplan Always try to have Single source of truth for data coming in and going out API is picking up a lot as it can be used by many tools and even programming scripts like python etc. With every thing moving to cloud , Use of API's is becoming very common . hope this helps

karank · ‎02-10-2020

@Jared Dolich i figured that which is why i removed the question 🙂 Great article

karank · ‎02-10-2020

@Misbah you have pretty much highlighted the single biggest advantage which is space optimisation . I get lot of clients asking me why is my DEV and UAT space same as prod ? Most of the time they are not happy paying same money as production space for Dev space.

karank · ‎02-09-2020

There has been numerous occasions where by my clients have asked me to reduce time duration for DEV and UAT Models . For eg. i might have 20 Yrs forecast in prod but only 5 yrs in DEV and UAT . With number of periods being part of ALM it cannot be achieved . It will be great if we can take it out of ALM structural change if possible

karank · ‎02-07-2020

I am with you on this as i have experienced similar issue before but i resorted to switching to heirarcies as everything else was either too elaborate or too workaroundy . good luck

karank · ‎02-06-2020

We have exact use case at one of our client as @jasonblinn suggested we load today's date into data hub every morning like 7 am by running an anaplan connect script . This date is then sent to spoke models by executing actions, also done through anaplan connect . It serves 2 purposes 1-> Today's date is loaded in all models which can be referenced accordingly 2-> All models are out of hibernation which means when users logs in , models loads quicker We then use approve button(not a checkbox) which runs a process and copies today's date as approval date . You can use the same thing for submit etc.

karank · ‎02-06-2020

I will be interested in something like that . If not too much hassle , perhaps screen shot your steps and attach as word doco here ?

karank · ‎02-05-2020

@ryanwcloud Just like @rob_marshall i am not entirely sure of your use case for resetting the list however let me assume that you want your users to add /see that now we adding 2020 related items . Perhaps you can use display name property to say something like 2020_1 , 2020_2....... and so on . Where 2020 is current year and 1 2 can be incremental ? Also just a quick thought . If your users are adding items manually i guess it will take them a very long long time to reach 999,999,999 . I mean if we enter 1M items every day it will take approx 2.7 years to reach 999,999,999.

karank · ‎02-04-2020

Screen shot Currently it says no actions available atleast for me . Wondering if anyone has any 'Action items' showing up there ?

karank · ‎02-04-2020

@nsareen Quick answer to your question is No . I have worked on models which integrates to External ML models and spits out data back into Anaplan ( so Anaplan -> ML model ->Anaplan) however this is based on integrations . Anaplan acquired Mintigo last year which does have predictive capabilities so may be in future Anaplan will offer some ML capabilities within the platform

karank · ‎02-03-2020

Its Either OR based on my response I mean ( i provided 2 options ) you don't need start in location if you are specifying full path (this was option 1) If you are specifying start in position then you must specify script name ( this was option 2)

karank · ‎02-03-2020

it is EITHER OR not both options at the same time so if you are going option 1 don't do option 2 and vice versa

karank · ‎02-03-2020

@MarkTurkenburg Seems like windows scheduler cant locate your batch script . Try one of the following Give the full path for the script so something like "C:\User\Script Folder\Script.bat" or Specify "Start in" location (this is where script is located C:\User\Script Folder) and in program Script specify script name ( Script.bat) when scheduling task in windows task scheduler .