About karank

Good Article @Misbah  ... View more

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

@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   ... View more

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  ... View more

@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    ... View more

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  ... View more

@JaredDolich    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 .    ... View more

Thanks for F2 tip , very handy indeed ... View more

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    ... View more

@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.  ... View more

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 ... View more

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. ... View more

@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.     ... View more

@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 ... View more