Platform

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

karank · ‎05-29-2019

Thanks @rob_marshall My Clients user list changes more often than your typical environment . Having ability to sort either by name or role will help them tremendously . May be i can have a user maintenance dashboard which (will enable sorting) and import changes from there . Re: Idea Exchange, seems like its been requested ( List sorting) few times now . I will add add my vote to it . Thanks

karank · ‎05-29-2019

Hi Guys Does anyone know a way to sort users in anaplan . I am talking about the User setup / Access Area . I don't want to delete users and re-add sorted lists as it will generate email notifications to users . Cheers

karank · ‎05-23-2019

@DavidSmith yes noticed after i typed my answer (i am a slow typer) . But its interesting to see how you are suggesting a superset approach vs my formula approach . Are there any pros and cons if we compare these ? .

karank · ‎05-23-2019

Your model cal doesn't go before 2019 which is your your formula PERIOD(Asset Acquisition date) returns nothing . So your formula is doing this If <nothing>+28.63 = (nothing as its time formatted) < Mar 19 then 0 else 28.63 If Nothing < mar19 then 0 else 28.63 which is why you are getting 28.63 you can change your formula to check if if isblank(PERIOD(Asset Acquisition date) + Asset life) or PERIOD(Asset Acquisition date) + Asset life <Cal Start of timeline THEN 0 ELSE Asset life may be you can put this part as final date to check = (PERIOD(Asset Acquisition date) + Asset life) if isblank( final date ) or final date < Cal Start of timeline THEN 0 ELSE Asset life Hope this helps

karank · ‎05-23-2019

Hi @naveed.bakshi What is your model time settings ?

karank · ‎05-22-2019

Hi I am assuming you have this list / module published on dashboard . instead of using button you can train users to go edit >> insert from the grid menu . This will then alow users to specify numbers of items to be added in the list Hope this helps

karank · ‎05-02-2019

Hi Guys Is there an approach you guys use when deciding on line item vs list ? for eg. I am loading three different kinds of volume data Volume type 1 Volume type 2 Volume type 3 Data is loaded by month Option 1 Create a module with 3 line item and time dimension Time Line item Volume type 1 Line item Volume type 2 Line itme Volume type 3 Option 2 Create a module with 1 line item called Volume and 1 list ( volume type 1 , Volume type 2 , Volume type 3) and time (Volume type List ) X Time Volume line item Which option would you choose and not choose and Why ? Is there a best practise for these kind of scenarios or it doesn't really matter ? If you have another way of doing it what is it and why ? Thanks

karank · ‎04-29-2019

@DavidSmith with Finditem is there a difference between IF ISNOTBLANK(TEXT) THEN FINDITEM(LIST,TEXT) ELSE BLANK VS IF ISNOTBLANK(FINDITEM(LIST,TEXT)) THEN FINDITEM(LIST,TEXT) ELSE BLANK in-terms of performance ?

karank · ‎04-24-2019

@DavidSmith Time being non production has posed some challenges We cannot have time reduced DEV/ UAT models and have to maintain the same time scale as production if using ALM Workaround technique suggested(for switchover) might work for smaller models with 1 or 2 model builders however it becomes extremely difficult to plan if there are multiple model builders at different geographical locations .

karank · ‎03-20-2019

Thanks Vignesh For a very detailed response , i really appreciate your effort . One thing i would like to understand is why i doesnt work . Thanks again

karank · ‎03-20-2019

Hi Guys I am trying to import data from data hub module structured with just line items (no dimensions) into A module in spoke model also structured as just line items ( no dimensions) and it just doesnt work . The value field doesnt come up source module time(line item) date formated target module time(line item) date formated PS: i have also tried importing into Text formated line item with no luck

karank · ‎01-24-2019

Hi , My name is Karan Kochhar and i have been working with anaplan for some time now . What brings you to the Anaplan community? To connect with fellow anaplanners and share ideas and knowledge What specifically are you working on at the moment? Why do you use Anaplan and what is your favorite thing about it? Working on trade promotion planning model for a client. I like using anaplan because it is very flexible when it comes to solving a problem . It enables me to approach a problem from many different angles .My favourite thing about anaplan is that you can spin an environmnet just by clicking few buttons . Have you been to any of our meetups, or seen us at an event? Not yet but would like to do so What's one way or suggestion to make this forum and Anaplan better? Perhaps a meetup for all interested anaplaners 🙂

karank · ‎09-26-2017

Hi All , I am trying to make a summary module which has mutiple calculated measures . Summary module is like an intersection between these calculated measures . Eg below on vertical axis i have measures like revenue $ revenue margin % to cost invoice cost etc on horizontal axis i have measures like original value , adjustments book value ( original value + adj) WIP , contrcat value ( book value + WIP ) , current ( Actuals + forecast ) and variance ( contract - current value ) I am confused with what would become my lists and what would become by line items .? Any help will be really appreciated

karank · ‎09-21-2017

Hi I have 2 module views published on dashboard module 1 has a list heirarchy(projects) which is like state -> branch -> project applied to it and time module 2 - has a numbered list(#projectXcost) which is flattened intersection of project and cost and time . #Project X cost list also has a list property which links to projects list . on dashboard i have project heirarchy (from module 1 )as page selector and 2 grids(grid 1 from module 1 and grid 2 from module 2 ) from above modules what i need to acheive is when i select project as page selector module 2 grid only shows me rows where it matches the seleted project . is this possible ? also is there a better way to do this ? Thanks

karank · ‎06-29-2017

Hi We have multiple business units forecasting at product levels. Product heirarchy is pretty standard however forecasting is performed at different level for eg business unit 1 product level 1 -> product level 2 -> product level 3 = forecasting is performed here . Actuals will be loaded at product 3 level Business unit 2 product level 2 -> product level 3 -> product level 3 -> product level 4 = forecasting is performed here . actuals will be loaded at product level 4 level . My question is how do manage above scenario without having mutiple duplicate heirarchy also how do i manage this on dash boards i.e for business unit 1 dashboard drill down goes till level 3 for business unit 2 dashboard drill down goes till level 4 thanks

Platform

Academy

Master Anaplanner

Programs

About karank