About LipChean_Soh

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) ... View more

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. ... View more

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

Hi,   To your point about the 48 hrs validity, it refers to data files that you upload into Anaplan, it depends on the private/default settings that you can learn more about below: https://help.anaplan.com/anapedia/Content/Import_and_Export/Import_Data_into_Models/Overview_Private_Default_Files.htm?_ga=2.184610346.2085110697.1562746682-1239638901.1550667215   But once data from the data files are loaded into Anaplan, and if you accidentally deleted the model, then you should email Anaplan support immediately, Anaplan support might be able to help recover the deleted model.   But generally speaking, if you're not sure whether a model should be deleted or not, i would suggest that you archive the model.   Thanks, LipChean ... View more

Hi,   As much as everyone in this forum would love to help you, the problem you're trying to solve is too big. I suggest you break your problem into more manageable pieces, and ask more specific questions.   Thanks, LipChean ... View more

Hi,   You can try the following: Assuming you have 3 Time Ranges shown above.     Note the 'Time Scale' and 'Time Range' in the 'FY20 - FY21' line item.   Please build according to DISCO, and build 'FY20 - FY21' in a separate System module.   Thanks, LipChean ... View more

Hi,   @Manuela_Apostol did a good post about this recently.   You can refer to  https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Is-there-a-formula-to-get-the-current-date/m-p/47182#M5956   Thanks, LipChean ... View more

Thanks LopChean. ... View more

Hi,   Before we talk about the solution, i do want to talk about 'In Anaplan, just because you can, doesn't mean you should'.   All of us love Anaplan, because it's super flexible and we feel empowered. But we must realize that Text must ONLY be used where ABSOLUTELY NEEDED, and not as a means to capture everything from the source system (at least i think that's why you did what you did). Text takes up a lot of workspace, and it consumed a lot of server overhead in the background, dragging the overall performance of your model.   Please talk to whoever needed, be it the Database folks or the business users to make sure the source is number formatted before sending it over to Anaplan. I might be wrong in my assumption, and please correct me if i'm wrong by providing more context. Do explain the above effects to the client.   Having said that, please see if the following works. Do note that i'm using ROUND, VALUE keyword, and the 'Decimal Point' options in the number format page.   Thanks, LipChean ... View more

Hi Gregory,    Is always tricky when you need to pivot the months..Usually to me happened the other way around: I sometimes receive source files with the columns as Months.. 🙂 However, you can achieve what you need, but in more steps:   1. Import the source file in a temporary module using a numbered list where all your source column will be line items 2. In the new module create a line item "Year" with the formula      Year Sales = Left(Sales Month, 4) 3. Create another 12 new line items formatted as number for the months with formulas like this:    Jan = if right(Sales Month, "01") then Sales Quantity else 0    Feb = if right(Sales Month, "02") then Sales Quantity else 0    Mar = if right(Sales Month, "03") then Sales Quantity else 0 .....    Dec = if right(Sales Month, "12") then Sales Quantity else 0 4. Now you are able to import the data in your target layout Create a saved view within this module and create an action to import your data into your target using the new line-items   Your target module need to have lists: Product, Year and 12 line items as months   Hope this help! ciao Alex ... View more

Hi,   Do see if the following time dependent Sales to Plan relationships shown below works for you. The 'Plan' formatted list is a field you can assign to different Sales at different point of time. To prevent yourself from entering new/old Plan ID every month, you can use the formula shown below to update itself with previous Plan ID unless there's a change in this month's Plan ID. Then subsequent modules can refer to 'Plan ID (Final)' for an up to date Sales-Plan assignment.     Another observation i made is that you use 'Plan ID' as the Code of Sales ID. I would strongly suggest against it, because we should use CODE the way it's intended, i.e. as a unique alphanumeric texts to identify the particular list member, so that Inbound/ Outbound integration is made easier. Having a good CODE naming convention is important towards Connected Planning.   Thanks, LipChean ... View more

Thanks, Rob.  I think that had also been suggested by previous repliers.  I was so focused on getting the "IF" part worked out for Regular vs PRN, I did not think too much on that.  I'll add that to my next steps. ... View more

Nice, Simple and sleek. My two cents,  I would look for options to prevent additional setups/inputs from the user, if it is acceptable to business, then to calculate the phasing from the lease start month, I would try to do that. For eg, Monthly does not need an input.  As well, Annual could be the month(lease_start), six month could be month(lease start), month(lease start)+6..something like that.. If business still want to have a input, it could be an override upon the calculation.   Thanks Arun ... View more