Platform

karank

Thanks David This module is "Ready to export module" . If its ready and not locked as you outlined middle ware will trigger the final export . KK

karank

@Misbah Thanks for pointing out Misbah . My model can hibernate during non operational hrs no issues. But during operational time i need it polled every minute to to get up to date(near real time) information on a module.

karank

Hi All , I have a requirement to continually poll(every 1 min) and export data from an operational Anaplan model . I expressed my concerns about locking / slowing down model therefore to test it out i wrote a script which runs every min and downloads data from an operational model . Data to be downloaded is relatively small 20 rows and 2 columns . Script mimics what a middle ware would do i.e authentication , get ids , run export , download data . I have the script running every min for an entire day in production model while users were logged in and going about their day to to activities . Script has been tested and cofirmed working . To my surprise no one reported any degradation / slowness of model . No one reported unexpected blue pop up stating something running . I didnt notice / feel slowness nor i noticed the blue pop thing . Question : is any one out there doing such kind of frequent polling ? Am i missing something here ? personally i am not a big fan of polling operational model every min however i need a reason to back my unlikeness. thoughts ? Thanks

karank

Hi Guys I have been requested by a client to continuously poll Anaplan Operational Model ( every 1 min) to EXPORT data from a module . Module is relatively small so about 20 rows and 2 cols . Right of the bat this doesn't sound like a great idea to me due to potential lock up of the model etc. therefore i wrote a Python script to test it out . Script executes every 1 min and downloads the required data using Rest API. It simulates all the steps that a middle-ware like MULE will go through i.e auth , get id's , run exports , download data etc. for every run . To my surprise i dont see any degradation or slowness in the model . Also i dont see the Blue pop up which happens due to export or import . Script has been tested and it works confirmed !!!!. Script has been running for a day every min in production model where users would go in and do about their normal day to day stuff. I have confirmed with users and no one noticed or reported any slowness or performance issues . Question: Is anyone polling operational model with such frequency ? Am i missing anything ? Personally i dont like this however i dont see any impacts to backup my unlikeness if that makes sense Thoughts ?

karank · ‎10-14-2019

@nathan_rudman yes i have now . Support has acknowledged this as a bug .

karank · ‎10-14-2019

Hi All Just found out you can copy dashboards . This is how you do it Click copy on the dashboard to be copied Enter new dashboard name and functional area

karank · ‎10-11-2019

@Misbah This approach works for display only . However when you extract data it extracts all digits in csv.

karank · ‎10-11-2019

@Misbah I just what it to be consistent so either both 31.49 or 31.50. Reason i say this is because we have tried few things like replacing 100 with 10 in rounding formula but it works for some scenarios and breaks for others . Unable to get a consistent result with rounding function

karank · ‎10-10-2019

Hi We are getting some inconsistent results with round function in Anaplan which is causing bit of an issue at a client's end . I have seen few posts relating to round function so may be a know bug . Just trying my luck if anyone has been able to solve this . Below is an eg. Please note how rounding formula behaves differently for Input 1 (rounds up) and Input 2(rounds Down) Here is the blueprint All line items are formatted as follows

karank · ‎10-10-2019

@DavidSmith i get that but cells ->bytes -> GB's does not give me what Anaplan shows as model size . For it to work i have to do some approximation as you highlighted above . So if both methods are approximation i am getting better results with second one with much easier calculations. Perhaps we can have a way to show exact results size by items in Anaplan to take the guess work out of it altogether one day . This might be handy especially considering clients pay by space for Anaplan .

karank · ‎10-10-2019

@Damian_Broj My client has a requirement to track model size and some other KPI's on daily bases. I have an Anaplan model which keeps track of all other model cell counts on daily bases . I have tried it couple of ways on 8 models across multiple workspaces 1 - Using the suggested method i.e get each line item cell count and data type and get the bytes and convert to GBs Result :- 7 out of 8 models are way off with GB's displayed on Anaplan . Only 1 model comes very close . 2- Using the approximation method . I.e 1000000000 cells = 9.3 GB Result :- 7 out of 8 models are very close only one 1 model is way off . Interestingly 1 that is off is the one which works with approach 1 May be i need to convince my client to analyse model size on cell counts rather than Gb's since there is no way to find the gap cell/space which comes from line items within Anaplan

karank · ‎10-03-2019

Thanks guys I tried same calc on 8 different models including this and it works on 7 . Close enough considering its estimate . Out of these 7 one model is actually a dev copy of the same model on which it doesnt work ???? . i am using Alm and models are syncd . how can i get such huge cell count difference but model sizes are same ?

karank · ‎10-03-2019

Hi Guys I am using below calculation to find model size 1000000000 cells = 9.3 GB 1 cell = 9.3/1000000000 Total cells exported from module export = 6206436639 which gives me 57.71986074 GB's problem is Anaplan shows model size as 39.29 Gb's ?. I have used this calculation on 8 models and all of these comes close to model size shown in Anaplan , just this one doesn't work . Ps:- i also tried doing the calc by line item type and cell count by data type but still its way out like above 10 GB's out . I have attached an excel sheet as well with actual cells extract any idea ?

karank · ‎10-01-2019

Just found out what it was . It was my access 😛 all good Thanks

karank · ‎10-01-2019

@VIGNESH.M I tried the api call you outlined above and it works 98% of the times thanks !!!! For some reasons it misses some the modules from a particular model ???? I cant figure out why it would omit just some modules . I have attached an output of what it misses cannot figure out a pattern may be you can throw some light

karank · ‎09-30-2019

@rob_marshall Thanks its a very good workaround however in my case it will not work as it has to be manually updated .

karank · ‎09-30-2019

Thanks @VIGNESH.M i did not try this . I will give this a try

karank · ‎09-30-2019

@ben_speight What you have outlined is exactly how i have done it however the challenge i am facing is some of the line item names are bigger than 60 char which is prohibiting me for using these as codes when bringing back into my anaplan model . Bit of a background i have written up a python script which collects line item level information from various models (exporting grid -line items ) DEV , UAT , Prod and brings into another anaplan model on a routine bases . My client uses this to perform some analytics in-terms of how each model is growing space wise and some other KPI's . Challenge i am facing is a line one i highlighted above + line item name will be same in let say DEV and prod . Also cases like what if line item name was updated ? . Therefore i was hoping to get some uniqueness

karank · ‎09-30-2019

Hi Guys Does anyone know if we can export module / line items ids using anaplan rest api? Using rest api i can export workspace /model/files IDs etc however i cant seems to find any unique keys for modules /line items . Surely there has to be unique IDs for modules / line items behind the scene . Thanks

karank · ‎09-26-2019

@nmaram best thing to do is call your local Anaplan or get in touch here https://www.anaplan.com/contact/

karank · ‎08-06-2019

Hi Do you have historical data as in when there was national holiday last year how sales curve looked like pre and post holiday season ? if you do then you can implement quadratic regression in anaplan where you independent variables are days and holiday . holiday variable can be true or false . if you can share some sample data i can make something in excel /anaplan Thanks

karank · ‎08-01-2019

May be i am missing something here but it sounds like a simple regression to me based on what you highlighted . Below i have plotted some numbers in excel and used Linest function to show regression results Here is First screen shot where you can see data i made based on scenario you just explained We are predicting sales based on weeks where Z a constant to mark b as 0 in case its 0 , unsure what is d? you will notice on the graph that i have a simple regression line showing y=ax+ b Now i am doing the same workings using linest function without constant i.e z set to nothing . Notice how my a and b matches regression line Here is a screen shot of linest function with constant again values are the same as regression line . I showed you earlier regression is achievable in anaplan . So unless we know what data you are looking at it will be hard to know exactly what the issue is . Perhaps you could share something like what i have done above to know more about whats going on at your end . I am sure we can implement simple as well as multi(quadratic) regression in anaplan which is what i think linest function does Hope this helps

karank · ‎07-31-2019

Hi What is cz ? or do you mean Y=ax^2 + bx + cx + d if above is the case then you probably have 3 variable multiple regression and d is the error coefficient and your data when plotted looks like a parabola ? (I am Just assuming things) It will be helpful if you can plot your data sample on a graph and show here .

karank · ‎07-31-2019

Hi Unsure about linest function but recently i implemented a trend line or simple linear regression for a client . Below are some screen shots of how i did it . Green line is the trend line or simple regression forecast Calculated intercept a and slope b calculated y = a + bx I guess linest and regression should return the same trend line . I could be wrong hope this helps

karank · ‎07-31-2019

Hi Assuming you are using Chrome as your browser I use Chrome extension called download router using which you can default your download location by file type , web address and many other things I use anaplan.com as domain and specify where the file is to be downloaded . When i run export action from anaplan it downloads to my specified directory hope this helps

karank · ‎07-31-2019

Hi You can use these to capture cyclic trends . So for eg. icecream sales . icecream sales will always have cycles or seasonality i.e higher in summers and lower in winters . If i want to know the trend of icecream sales i.e sales going up or down ( not cycles but overall) i would use regression . it will give me a straight line slanting up or down but i would like to know the cyclic trend i.e going up or down with the summer cycles and winter cycles i could use trigonometric ratios . it will give you a spiral trend line going up or spiral trend line going down i hope this helps

karank · ‎07-18-2019

@kdoan Your dashborad defaults to total accounts . Whats is your summary settings in the module ?

karank · ‎06-19-2019

@fredrickstaube try this download ur module to excel in blueprint mode this is just to save your formulas then remove all formulas and access drivers change dimension put ur formulas back

karank · ‎06-12-2019

@LipChean_Soh This is brilliant!!! Just a quick question is your rank list a fixed list ? i.e fixed number of ranks ?

karank · ‎06-04-2019

@aakash You mentioned that changing file format is an option Is it possible to unpivot the data file like below Then you can import it like

Platform

Academy

Master Anaplanner

Programs

About karank