About karank

karank · ‎02-17-2021

Thanks @JaredDolich this works as well

karank · ‎02-17-2021

Yep this works thanks

karank · ‎02-17-2021

Hi Guys I have been trying to solve this issue and having no luck. Reaching out if anyone had a similar issue and was able to solve it with clever tricks Module 1:- dimensioned by the user ( native user list) A user enters no of lines as a numeric value Module 2 :- Dimenshioned by List 1 and List 2. Please note that this is not dimensioned by user list List 2 has items numbers 1 - 15 Question :- I want to filter this module based on the number of line entered by user in module 1 . In my show ( boolean) i have a simple formula . Show is dimensioned by List 2 and users ( native) if value(name(item)) >= module1.no of lines then true else false Caveats I cannot dimension module 2 by user I would like to avoid FAKE user list Does anyone has a clever way of acheiving this ? Thanks

karank · ‎02-13-2021

Cheers Jared Always helpful Thanks

karank · ‎02-11-2021

Hi Guys Has anyone implemented a new Cloudworks API ? Here is a scenario I have a process that has 2 imports call it Process A 1- imports list items 2- imports monthly data(measures) related to list items when I am setting up my cloud works integration I am not getting an option for selecting a process just imports actions Question Process A has 2 imports even though it is one integration point. Will Cloudworks count it as 2 integrations? ( please note that there is a limit of 25 integrations per tenant) Is this typically how you setup cloud works imports? or there is a better way ? Karan

karank · ‎10-28-2020

@hyudolee Below is what i think why new UX was designed It looks better than old and looks more inline with todays style It is more efficient than old UX . In old UX you can open multiple tabs within anaplan but new ux will not let you . It always opens of one page at a time . This keeps the cloud servers in the background running more efficiently New UX renders better on modern technology devices like tablets and mobile phones .

karank · ‎08-12-2020

Good Article @Misbah

karank · ‎06-06-2020

@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 · ‎06-06-2020

@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 · ‎06-06-2020

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 · ‎06-05-2020

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 · ‎06-05-2020

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

karank · ‎06-05-2020

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

karank · ‎06-05-2020

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

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

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

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