About LipChean_Soh

LipChean_Soh

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

LipChean_Soh

Hi @Jared Dolich , @MarkT83 I just checked with a colleague. At the moment, all userID that has ever been created will remain in your Tenant Administration, including those that have been deleted (this explains the inconsistency experienced by Jared). Within Tenant Administration, UserID cannot be deleted, they can only be disabled. Please upvote this link https://community.anaplan.com/t5/Idea-Exchange/Delete-Dormant-Users-from-the-Anaplan-Tenant-Admin-Tool/idi-p/39537 Thanks, LipChean

LipChean_Soh

Hi @Jared Dolich Since this is not something i can easily test, i believe disabling users prevents the disabled user from logging into Anaplan, but it doesn't stop a Workspace Admin from deleting the disabled user from the relevant workspace/models, i.e. you need not reactivate the disabled users prior to deleting them. Do let us know if you manage to do a test with your users. Thanks, LipChean

LipChean_Soh

Hi @MarkT83 You can disable users (active or dormant) in Tenant Administration, but you'll need to go to individual models to remove the user. And of course once you remove the user from the model, that user is also removed from the workspace of which the model belongs to. https://help.anaplan.com/anapedia/Content/Administration_and_Security/Tenant_Administration/Users.html https://help.anaplan.com/anapedia/Content/Modeling/Users/Users.html?cshid=1137&_ga=2.94109273.537569476.1577651307-1837980065.1573133992 At least you can use the Tenant Administration to view all models/ workspaces of which your user of interest belongs to. Regarding your question of why you don't see the full user list in the Tenant Administration, a user can only belong to 1 Tenant, so perhaps the user of interest belongs to a different Tenant. I would suggest that you email support@anaplan.com to verify that. Thanks, LipChean

LipChean_Soh

Hi @mwaltz0213 @rob_marshall is right, to make Anaplan models sustainable (S of PLANS), we must aim to make our models as dynamic as possible, i.e. refer to System Models as much as possible. With your latest requirements, please see if the following works: 1. 'SYS00 Time (No Time)'.Current Month Entry assumes you have a month of reference that you change often, and that you want to apply TRUE to all months that fall within the previous years relative to 'Current Month Entry'. Thanks, LipChean

LipChean_Soh

Hi @mwaltz0213 You can try Month(Start()) >= 8 and Month(Start()) <=12 You need not add "IF THEN ELSE" if the line item is Boolean formatted. Thanks, LipChean

LipChean_Soh

Hi @PujithaB This is an interesting question. I am not sure if there is a limit from the incoming CSV point of view, i have heard of 40Gb CSV files being uploaded into Anaplan, and it still went through, though it took a VERY long time. And it's also possible that you can have CSV_A (with number formatted data) which is smaller than CSV_B (with text formatted data), but it ends up such that the loading of CSV_B results in an error because you've hit the 130Gb limit in Model B when you tried to load a lot of TEXT into Model B. I would look at this problem from another angle, i.e. do we need to bring in so much data? I'm not saying Anaplan cannot handle large amount of data, but sometimes we need to make a challenge to the data warehouse or business side. Just because Anaplan can, doesn't mean it should. Please refer to https://community.anaplan.com/t5/Best-Practices/Data-Hubs-Purpose-and-Peak-Performance/ta-p/48866 Especially the part below: Thanks, LipChean

LipChean_Soh

Hi @PujithaB When more users are using the same model, performance is worse than the case if less users are using the same model. Then the question becomes: 1. How many total users are added to the model? 2. What's the % of users who are concurrently using the same model? Please refer to https://community.anaplan.com/t5/Model-Concurrency-Testing/tkb-p/Customer-Performance-Testing-Database Regarding your question of " And how to increase performance if there is large data load and multiple users are loading into same module at same time?", i would suggest looking into 2 possibilities: 1. Create a data hub. Please refer to https://community.anaplan.com/t5/Best-Practices/Data-Hubs-Purpose-and-Peak-Performance/ta-p/48866 2. Split the 2 activities, eg schedule the large data load to happen during an offpeak period, so that when your business users are online, they won't be affected by this large data load. And as usual, please refer to the best practices in https://community.anaplan.com/t5/Best-Practices/tkb-p/communitykb to design an optimal solution. Thanks, LipChean

LipChean_Soh

Hi @Riccardo @VIGNESH.M For best practice (Refer to 2.02-12 of Planual), please avoid hardcoding of list member, and do the following instead Thanks, LipChean

LipChean_Soh

Hi @Sravan_Kumar The file is in Sprint 1 - User Story 4. https://learning.anaplan.com/mod/page/view.php?id=11963 Thanks, LipChean

LipChean_Soh

Hi pratyaksh.dua@polestarllp.com There's an index in the background that keeps track of all list member created, this index cannot exceed 999,999,999. For example, if you have a list called "Transaction", and if at any time, you only have 1000 members, and you only have 1 module called "Transaction Module" with a number formatted line item called "Sales". Then the total workspace consumed is about 1000 * 500b + 1000 * 8b = 0.508 Mb Note: 1 list member takes up 500b per member, 1 number format takes up 8b. If you keep deleting all 1000 member and recreating different 1000 member, the index in the background will increase from 1-1000 > 1001-2000 > 2001 > 3000 , etc etc. One day you'll hit 999,999,999, and when that happens you'll need to reset the index. Please refer to https://help.anaplan.com/anapedia/Content/Modeling/Dimensions/Lists.html Now, if you want to test the limit of how many concurrent list members you can have in Anaplan, then it's as @Misbah said, it's about 250-260 million member. The maths is as follow (assuming we also have 1 module with a number formatted line item using this list) (250,000,000 * 500b + 250,000,000 * 8b) = 118Gb approximately. Having said that, i'm a little concerned if you are bringing such large amount of data into Anaplan. Please refer to https://community.anaplan.com/t5/Best-Practices/Data-Hubs-Purpose-and-Peak-Performance/ta-p/48866 especially the section below: Thanks, LipChean

LipChean_Soh

Hi @shadmani Does that mean you have already found your solution? If not, i would suggest that you create a mock up of what you're trying to achieve on Excel, and then share the screen shots here. Thanks, LipChean

LipChean_Soh

Hi @Sravan_Kumar That's weird, it works for me. Can you email academy@anaplan.com to ask them about it, so that whatever they suggest will benefit other Anaplan users who happened to experience the same error you did. But in anycase, attached is the safety stock csv. Thanks, LipChean

LipChean_Soh

Hi @AnushaAttuluri Please refer to https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Time-line-chart-not-synching-with-View/m-p/37140#M839 Thanks, LipChean

LipChean_Soh

Hi @Sravan_Kumar The bold row members indicate it's a parent member, so i am guessing you've created a module using P3 SKU, but you have only inserted members for P2, hence all the row members are only at P2, and you cannot input values at P2 for a module with P3 SKU in 'Applies To'. To fix this, just start inserting members in P3 SKU. Thanks, LipChean

LipChean_Soh

Hi @agni_gold I would suggest that you start with the following: 1. Get access to Anaplan, so you can start building models in your own sandbox environment. Nothing beats actual hands on experience. 2. Go through at least L1 and perhaps L2 of the model building courses offered in https://learning.anaplan.com/totara/dashboard/ These 2 courses will teach you basic navigation within Anaplan, while you slowly get familiar with the jargons, and best practices in Anaplan.. 3. Go through Best Practice documents in https://community.anaplan.com/t5/Best-Practices/tkb-p/communitykb 4. Subscribe to the forum that you just posted this question, and check it out constantly. It's very likely that a problem you'll face in Anaplan has been faced by your counterparts from all over the world. There's healthy ongoing discussion, and later once you feel more confident you can also contribute to the community. Thanks, LipChean

LipChean_Soh

Hi james.cunningham@slalom.com You can probably check with your local Partner Success Business Partner from Anaplan. Thanks, LipChean

LipChean_Soh · ‎12-23-2019

Hi @prash248 The following works if the list you're working on is a numbered list: 1. Num List 2 is the child of Num List 1. The method i'm suggesting works for any new Numbered List created under any parent, i.e. Num List 1. 2. I put in some dummy members in Num List 1, Num List 2. Note that Num List 2 have members starting with '#' because it's a numbered list. . 3. The module 'Num List 2 Details' is created. Set summary method of 'Number' to 'Max'. 4. Blueprint of 'Num List 2 Details'. 5. 'Lookup Module 4' is created to capture the largest number from 'Num List 2 Details'.Number, and turn that into 'Num List 2'. You can then publish 'Lookup Module 4'.'Latest Num List 2'. Note that the '4' in 'Lookup Module 4' is arbitrary, i have 3 other 'Lookup Module' in my test model. Thanks, LipChean

LipChean_Soh · ‎12-23-2019

No worries. Happy holidays. Regards, LipChean

LipChean_Soh · ‎12-23-2019

Hi @dgregs Do see if the following works: 1. Create Fake Mth as shown below. I only created 24 members but you can expand to 60 members. 2. Cost Center Date Module is created to capture Date of 1st month. 3. Another module, i.e. 'Date to Fake Mth' is created. Results are shown in 'Fake Month (List)'. 4. Blueprint of 'Date to Fake Mth' module. Thanks, LipChean

LipChean_Soh · ‎12-23-2019

Hi @prash248 Do see if the following works: 1. I have a simple list, i.e. Cost Center. It has 3 existing members, i.e. CC 1, CC 2, CC3 2. A System module, i.e. Cost Center Details is created. 3. The blueprint of 'Cost Center Details' is shown below. 4. A Saved View called 'New CC' is created with the following filter. This saved view will be published in the dashboard in step 6 below. 5. A process with the 2 import actions below is created. 5.1 'Load Cost Center Details' copy 'Cost Center Details.True Flag' --> 'Cost Center Details.Old?' This step marks existing Cost Center members with a TRUE flag. 5.2 Create Cost Center is an import action that adds new Cost Center members. In my case, i'm using a Cost Center.csv with 3 members, i.e. CC X, CC Y, CC Z. 6. The process and saved view are published in an Admin Page dashboard. 7. Attached below shows the results of the newly created Cost Center. Thanks, LipChean

LipChean_Soh · ‎12-22-2019

Hi @CommunityMember117741 Do see if the following works: The other keyword that you might want to use instead is LASTNONBLANK, depending what your requirement is. Thanks, LipChean

LipChean_Soh · ‎12-21-2019

Hi @CommunityMember117741 I'm still unsure about some of your requirements, but based on my understanding of position and ramp profile, and how it can affect Ramp %, i have created something below. Do see if you can modify accordingly to achieve what you need. Thanks, LipChean

LipChean_Soh · ‎12-21-2019

Hi @vsbwofficial Yes Anaplan can take in unique data. However please have a read of the Best Practice article in the link below https://community.anaplan.com/t5/Best-Practices/Data-Hubs-Purpose-and-Peak-Performance/ta-p/48866 You'll see that while you can use Date as part of the unique code, you should avoid doing so, unless there's a very good reason. Also, i can't seem to see any screen shots posted by you. Thanks, LipChean

LipChean_Soh · ‎12-20-2019

Hi, It would help if you can provide Excel screen shots of what you like to achieve. Thanks, LipChean

LipChean_Soh · ‎12-20-2019

Hi, You can try the following: Thanks, LipChean

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

LipChean_Soh · ‎12-19-2019

Hi @Misbah I think we're probably talking about different things, i.e. you're talking about model setup such as formulas, modules, dashboards while i'm talking about the CODE of lists. If you're talking about model setup, then i do agree with you that we can restore DEV model to any point in time in the past, and export any information out into Excel for analysis, then restore DEV model to the present, then do any Compare & Sync. Out of curiosity, what is RT? Thanks, LipChean

LipChean_Soh · ‎12-19-2019

Hi @Misbah A few comments on your suggestion below: "If ALM was Implemented - Any code would have been pushed from Dev to Prod. We can restore the Dev model to the whatever ID in the past. Export the code from Older Dev model" 1. Any code would have been pushed from Dev to Prod - Only Codes of Structural List (i.e. list where the Production Data is NOT ticked) are pushed from Dev to Prod. Codes of Production List are either: a. Sent from another model, eg Data Hub, b. Manually created in Deployed Model, c. Imported from a flat file into the Deployed Model. 2. whatever ID in the past - We must be careful when we restore Dev to the past. If you restore Dev to a point BEFORE any List is converted to Production list (eg Employee), then you're essentially changing that list back to a Structural List. What that means is that when you then do a Compare & Sync, your deployed model will be synced with Dummy members for Employee. That means all transaction data related to Employee in your deployed model is now gone. So please be careful about restoring too far back into the past. See image below from https://help.anaplan.com/anapedia/Content/ALM/Compare_and_Synchronize/Fixing_Production_Issues.html Thanks, LipChean

LipChean_Soh · ‎12-18-2019

Hi, I would add some conditions to @VIGNESH.M 's solution. Assume your FY is represented as Month in my suggestion below. Thanks, LipChean