About LipChean_Soh

MarkTurkenburg · ‎01-21-2020

Thanks @LipChean_Soh & @JaredDolich I'll work with the support team to track down with Tenant those Users are located

LipChean_Soh · ‎01-21-2020

Hi @hina1994 There's plenty of discussion on allocation, a quick search reveals the following. Note there is plenty of other examples too https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Allocation/m-p/54553#M8630 https://community.anaplan.com/t5/Anaplan-Platform-Discussions/How-to-create-allocation-key-based-on-last-forecast-data/m-p/36638#M1625 https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Top-down-allocation/m-p/24876#M2168 https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Territory-Allocation-Urgent/m-p/55899#M9072 https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Prioritized-Allocation/m-p/42502#M4577 Thanks, LipChean

SonalTripathi · ‎01-21-2020

Hi, Please have the values in column as List i.e. create a list for the values in column (let's say list x) Then create a line item(count) in module with Number format and value 1 . count =1 Then create a line item with number format and use below formula:- Count[SUM: x, LOOKUP: x] This will capture the count. Hope this helps.

mwaltz0213 · ‎01-09-2020

@rob_marshall I agree to avoid these. In this case, it was when we went live with the sales plan in Anaplan, so it will never change.

AlejandroGomez · ‎01-08-2020

I am glad it came in handy. See you around, guys

Misbah · ‎01-07-2020

@PujithaB As @LipChean_Soh already mentioned that more the robust design less the performance issues. Anaplan handles it quite well even if there are dozens of concurrent users on the same dashboard provided we'd followed the best practices in the model design. On Data Load - See if you can break the load in chunks - you can take it to 30, 40 chunks etc. and make sure that the load doesn't happen during peak time. Data Load from End users - Now this is something that is the bone of contention. Let me share my views: If there are end users who start loading their data at the same time then it might take sometime (here we are talking about 10 seconds to 20 seconds - based on the size and the number of users). If your processing time is higher than a minute or two then it might be worth to break the calculations link based on the input line item and stage/store end user driven numbers into standalone module and then pull the data for calculations later (schedule the job later during offpeak period) - this you have to take a buy in from end users that there will be a trade off between the performance and the real time Hope that helps Misbah

usman.zia · ‎01-06-2020

Hi pratyaksh.dua@polestarllp.com Always worth considering why you would need that amount of list items and if the reason is having multiple transactions then it may be better to use a consolidated data source with less items. Anaplan is an amazing tool but currently using extreme dimensions does not work well and it definitely not a data science tool. I would never recommend to ever using anaplan with 999,999,999 items its crazy! Thanks, Usman

Sravan_Kumar · ‎01-06-2020

Thanks for your kind help @LipChean_Soh

shadmani · ‎01-05-2020

@LipChean_Soh , yes found the solution already 🙂

karank · ‎01-03-2020

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.

Sravan_Kumar · ‎01-03-2020

Thanks so much @LipChean_Soh. I will mail academy on this. Regards, S. Kumar

Sravan_Kumar · ‎12-31-2019

Thank You. Yes you are right.

usman.zia · ‎12-30-2019

Hi @agni_gold, If you want to understand the possibilities and current use cases please do explore the app hub too! https://community.anaplan.com/t5/App-Hub/ct-p/APPHUB Also feel free to post questions! Thanks, Usman

JaredDolich · ‎12-27-2019

james.cunningham@slalom.com, @LipChean_Soh is right. Your BP can definitely help. The partner statistics are really important - they also help define the partner tiers. Slalom is a gold partner which means you have at least 8 certified modelers. Although the number of modelers for gold tier requirement may have changed and there may be more required to meet the gold tier - but your BP will know and can also get the training stats for you. Recommend you also sign up for the partner communications if you haven't already. Often, they will announce stats, particularly averages. The big thing right now is the new UX.

prash248 · ‎12-24-2019

thanks @LipChean_Soh I think this solution best fits to my requirement.

LipChean_Soh · ‎12-23-2019

No worries. Happy holidays. Regards, LipChean

CommunityMember117741 · ‎12-22-2019

Thank you. Regards, Gabriel

CommunityMember117741 · ‎12-21-2019

Hi, Thank you for your help. I will try this out. Kind regards, Gabriel

LipChean_Soh · ‎12-20-2019

Hi @Panji If your number uses 'dot' as thousand separator, you can do the following: 1. Assuming this is the data file, note that the thousand separator is 'dot' 2. Blueprint format of receiving Anaplan module. Note the change to 'Thousand Separator' 3. In your import action definition, change the 'Decimal Separator' to 'Comma'. 4. Below is the end result in the receiving module. Thanks, LipChean

Misbah · ‎12-19-2019

@LipChean_Soh Revision Tag 🙂 Yeah you got it! I was talking about the model setup Misbah

Sorna Raja Prabhu · ‎12-19-2019

THANKS VIGNESH, IT WORKS. 🙂

LipChean_Soh · ‎12-16-2019

Hi @EHarris I still don't know what your requirements are, but to answer your question below, i have prepared something for your reference: "Import G3 Resources into a module --> Delete all children of the G2 site --> Import Current Resource (formerly Future) back into that G2 Site from the module. The actions above will update the entire G3 list (for all sites). How can I create an action to import only the G3 Resources for one specified G2 Site? Is there a better way to achieve the functionality?" 1. The 'Staging' module is where you Import G3 Resources into a module. 2. The 'City Code' i'm using below corresponds to your G3; and it rolls up to Country, which corresponds to your G2. 3. I have created 2 selection matrix, i.e. Valid Country and Valid Type. 4. Depending on what's entered in 'City Code, Type', 'Final Valid' will be TRUE or FALSE. 1. Final Valid is used to create a Saved View. You can then use this Saved View to help create the G3 that you need. 1. Below is the blueprint mode of 'Staging' module. Thanks, LipChean

vsbwofficial · ‎12-16-2019

Thanks

nathan_rudman · ‎10-14-2019

Hi, I think what you are asking here is simply how to access the new UX. when you are connected to anaplan, you can see on the top left corner a Hamburger menu. Click on it an select Apps. This will take you to the NUX and show you the apps and pages you have access to If you are asking how to be able to create content in the NUX, then your user needs to be a "Page Builder". Your tenant admin can assign that role in the admin console, which you can find in the same menu as mentioned above in the "Administration" section (if your org has no tenant admin please contact support)

vsbwofficial · ‎10-13-2019

Thank you so much

AlejandroGomez · ‎08-01-2019

Great job @LipChean_Soh LipChean! Thanks for sharing it. I hope @peggyhai managed to have dinner in time! haha.

Misbah · ‎07-27-2019

@kdoanThere is no such formula in Anaplan called TimeFilter. Also, you can see if Brought Forward functionality helps in your case. Point to remember is that Anaplan won't add that Previous Year to current year automatically. However it will display last year's time period into your current time scale - which will help you in showing the data in one module instead of two modules. You can find Brought forward feature in the Blueprint mode. Happy Planning. Misbah

kavinkumar · ‎07-24-2019

HI Guys, What if I want to clear only one line item and don't want to disturb the other line items(Manual inputs). So it is best practice to use 'All mapped items" so that you will not loose any other data. @MadhabikaM If you want to create an action, go with the approach of creating line item and make it as No data as this will save your model size(This will clear out for any formatted line item ex. Number, Text, Boolean, list etc.) and import into your desired line item. I hope this helps. Regards, Kavin.

nebisht · ‎07-16-2019

My intent was only to suggest alternative approach importing only the delta items. Capturing the deletes in source model in a say "archive" list, which would be used to 'delete using selection' in the target model. This will send through only delta i.e. new creates/modified/deletes in the import action and keep the processing of the model optimized.

Vladimir · ‎07-11-2019

It is not possible to do directly, I know. But if you create duplicate flat list, and then using some formulae I could?