About karank

karank

Combine the file as one and import

karank

Hi Can i ask how are you making this copy ? If you are doing Manage model > Copy OR Manage model > Import (to make copy) then yes you will have same size model If you are doing Revision tag > Create model from revision Then model should not take production data

karank

If it is adhoc then you can compare formulas as well using excel just extract modules in blue print mode

karank

Hi @sunilramakumar Without going into too much details about your your use case i can think of few ways if you are doing this in a very adhoc way then download data from module 1 and module 2 into excel and use excel if you want something within Anaplan then you can do it in 2 ways create a third module to compare module 1 and module 2 line items ( not the best way) another way is to use inbuilt compare functionality however you will have to change few things create a list and add 2 members base 1 and base 2 apply this to your module. You only need 1 module as you can have different values by base 1 and base 2 use anaplan compare function and compare base 1 and base 2 using specific base i can think of other ways as well like using subsets but will be great if you can list more information about your query . hope this helps Karan

karank

Hi Is size column in you data is a definitive list ? i.e a product can only be of certain sizes ? if it is then create 2 lists customer and size and load data into a module dimentionlaised by customer ×size × time(day) with quantity as line item . else concatenate customer and size as one list as suggested above.

karank · ‎12-12-2019

@nathan it does feel buggy which is why i posted here . I will show this to support when i get some time

karank · ‎12-12-2019

Thanks for your input @usman.zia its always welcomed 🙂 @VIGNESH.M i did try your approach and i must say it comes out different , something i have never seen before . eg This is how it looks even though its subsidiary view . Have never seen a subsidiary view editable at top (i.e without going in) When i try to import into this it gives me option to choose dimension which means i will have to have 2 actions 1 to import into main list 1 to import into subset of main list So essentially this works like having 2 modules into one . If i made ACCESS control module 2 for subset it would have been same as this . From simplicity point of view i think top level and all option works if that is an option else this could be an alternative if you do not want to create 2 modules ( centralised access control) .

karank · ‎12-11-2019

@vignesh Thanks , I will try this . I thought It's not possible to use a list and a subset created from it in the same module as stated on anaplan wiki . Probably i am reading it wrong . I was thinking of creating Nevertheless it will be good to know why it did not work like lookup . Thanks

karank · ‎12-11-2019

Thanks @kavinkumar I did try what you are suggesting however I was trying to avoid summary level and top level for this list. It would be nice if some one can explain why it did not work . I guess i am going to miss @DavidSmith !!!!

karank · ‎12-11-2019

Hi Guys, I am trying to create a DCA access control module and noticed something . Wondering if someone can shed some light on this So i have a list and the list has a subset eg below I have 3 modules -First one "lets call it module" has above list as "Applies to" with 1 line item "Read" as Boolean and Formula as "True" . -Second one has Above list as "Applies to" with 1 line item "Line item" as number and Read is set to above module.read . Works no issues -Third one has subset from above list as Applies to" with 1 line item "Line item" as number and when i try to set Read to module.read i get below error Why is this happening ? I would have thought this will work as just like lookup can someone shed some light on this ? Many thanks

karank · ‎12-05-2019

I do custom scripting and call it from Anaplan by having a link to a batch script which executes a python script. My use case is to get Now() and some other data points . It works but i do agree if we can have it directly from anaplan with possibility of passing variables will be awesome.

karank · ‎12-05-2019

I think this post has gone onto a different tangent . I will mark this as close for now . I do want to share a sentiment though .Best practices are Best practices and we should stick to them wherever possible to get the best outcome . But guess what ? the world is not perfect . As a consultant i can advise on best practices but i cant impose best practice as a solution . Thanks for everyone's input

karank · ‎12-04-2019

Source system is a transnational system so i would assume it will have some sort of unique transaction Id . May be below should clarify things further . Yellow transactions are the ones which changed/updated price .You could argue how can the transaction price change but that another story which doesn't belong on this forum .

karank · ‎12-04-2019

If i go to source system ID level data volume goes 10 folds besides i dont need it at that level . To avoid it we did group by price in data integration layer . Upside -data volume reduced a lot but downside i dont have a uniqueID . Surely i am not the first one to face this . There has to be a better way of doing this .

karank · ‎12-03-2019

Thanks @Jared Dolich I agree with you re. @david and @rob's article on sparsity and data hub respectively. Indeed very informative and insightful .

karank · ‎12-03-2019

Hi @rob_marshall Let me give you some context Data in question is by store by group( customer in this case ) by PRODUCT by DATE ( its not product date but PRODUCT and DATE) . In a day a store can sell 10 quantities of product A at price 20 let say till 1PM . Now after 1PM the price goes up to 30 because some cap was exhausted so we need to know the quantities sold at that price . Group by price and quantities is performed in data integration layer data file coming to Anaplan today is as follows #1 date 4/12/19 customer A store 1 product X price 30 quantities 10 (please note the # list id, this is generated by data integration layer ) #2 date 4/12/19 customer A store 1 product X price 32 quantities 20 (please note the # list id, this is generated by data integration layer ) Tomorrow store realises that 32 price was incorrect it should have been 33 so they resend this data to us as follows . #1 date 4/12/19 customer A store 1 product X price 30 quantities 10 #2 date 4/12/19 customer A store 1 product X price 33 quantities 20 " Customer_Store list by Time at the day level with two line items: Price and Quantity" will not work . This is not unique i need to store quantities by both prices in this solution it will override Previous Amount Previous QTY Load? which is a boolean having this formula: Amount<>Pervious Amount or QTY <> Previous QTY This will also not work because i do not have previous values notice the numbered list id's today #1 date 4/12/19 customer A store 1 product X price 30 quantities 10 (please note the # list id, this is generated by data integration layer ) #2 date 4/12/19 customer A store 1 product X price 32 quantities 20 (please note the # list id, this is generated by data integration layer ) tomorrow #1 date 4/12/19 customer A store 1 product X price 30 quantities 10 #2 date 4/12/19 customer A store 1 product X price 33 quantities 20 If i snapshot price and quantity and compare it will not work for scenarios where i have received a completely different line . I cant change this to non numbered list as price cannot be a list. it can change to anything. Only thing i can think of is if we get the lowest level from data warehouse and do the group by in Anaplan but that is lot of data and i want to avoid this if possible. I hope i have made the problem statement clearer

karank · ‎12-03-2019

Hi All, I have an issue which needs to be addressed for a client. I do have a solution however would like to reach out to amazing community and get a different viewpoint on this if possible . Problem statement : we need to clear an item from a module however there is no simple way to identify the item to clear Below is a screenshot of what we get let say today ( I have also attached an excel version) Import file :- This is the file we get from source system , It goes into data staging module . in Datahub Data staging :- In this module we create an id concatenation of customer store product date and price as below (i know price should not be part of id however there is no other way to achieve uniqueness as price changes within day and we need to capture QTY / price ) Data final :- This is a list where we load the ID's . So essentially we keep history of old records . We do have processes to remove old records however lets not go there ( in spoke model) Tomorrow we receive below Please notice that #3 transaction has updated price so think of this as yesterday there was an error and today its fixed . We cant have a flag which says what has been updated or ref to old record by IT in the file . Issue :- We need to some how clear the transaction which was loaded yesterday i.e A_1_Y_4/12/2019_30 Solution : Any suggestion ideas will be really appreciated . Karan

karank · ‎11-27-2019

best to filter it using intregration i.e only update data for relevant period or you can import in 2 stages 1-load data into staging create filtered view by unlocked period 2-import data from filtered view

karank · ‎11-27-2019

Hey Winsent ( you know who this is 😛 ) You can possibly use an excel macro to hide BOLD rows (parent items) Something like below Sub showbold() Application.ScreenUpdating = False ActiveSheet.DisplayPageBreaks = False For r = 1 To ActiveSheet.UsedRange.Rows.Count Cells(r, 1).EntireRow.Hidden = Cells(r, 1).Font.Bold = False Next r End Sub

karank · ‎11-26-2019

Hi @stephen.brook Exact solved this issue Thanks

karank · ‎11-17-2019

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 · ‎11-14-2019

@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 · ‎11-14-2019

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 · ‎11-14-2019

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 .