About LipChean_Soh

LipChean_Soh · ‎08-25-2021

Hi @CommunityMember126793 I don't know what business case you're trying to solve, but it seems weird to me that you're copying a single value to another single cell. But in anycase, i think you're right that you'll continue to experience the import error. 1. What you can do is insert a single member dummy list, as shown below. 2. Create the source and target module as shown below (only source module is shown below, but target module is the same). 3. The import action is shown below. Thanks, LipChean

LipChean_Soh · ‎08-19-2021

Hi @ddevine I couldn't simulate what you experienced below. But perhaps you can try to 'reset' the time range, by unchecking the 'Total of All' of the time range, before turning it back on? Thanks, LipChean

LipChean_Soh · ‎08-01-2021

Hi @andygoh Some modifications are made. . 1. 'SKU 3' is the parent hierarchy of 'Price Transaction'. 2. There's no change in the 'INP Price Row' module. . 3. There's no change in the 'CAL Price' module, except the summary. 4. There's no change in the 'INP SKU' module. Thanks, LipChean

LipChean_Soh · ‎07-30-2021

Hi @andygoh For your SKU hierarchy, are prices entered at SKU 1 level or #1, #2 level? If prices are entered at SKU 1 level, do #1, #2 follow the price of SKU 1? Thanks, LipChean

LipChean_Soh · ‎07-27-2021

Hi @andygoh Without adding a lot of complicated validation, do see if the following works: 1. 2 lists are created, i.e. Price Transaction and 'SKU 3'. This POC is done in a test model, and i have 'SKU 1' and 'SKU 2' used for other purposes, hence the weird naming. 2. 'INP Price Row' is an input module where you enter 'Price, Start Month, End Month'. 'Price Transaction' list is used here. 3. 'CAL Price' sends the relevant price to the different months. 'Price Transaction' and 'Month' list are used here. 4. I'm assuming 'SKU 2' has the same price in the same month. 'SKU 2' and 'Month' list are used here. Thanks, LipChean

LipChean_Soh · ‎07-21-2021

Hi @stukcup The image you showed is the 'blueprint' view. You'll need to go to the 'data' view, before you can click on 1 or multiple line items using 'Ctrl + right click', before you select 'Hide' or 'Show' depending whether you wanted to hide or show the selected items. Thanks, LipChean

LipChean_Soh · ‎07-21-2021

Hi @brettnish Assuming you have Role A with access A, and Role B with access B, and you need to assign someone with access A and B, then you'll need to create Role C for that. It's easy to get out of hand by creating redundant roles, so you should do an audit once in a while. Thanks, LipChean

LipChean_Soh · ‎07-12-2021

Hi @akprasa1 That's an expected behavior of Anaplan, as mentioned in https://help.anaplan.com/c5c1e687-3d55-46ea-ab28-a7603eade586-x[MIN:y] You will see the following when you scroll down. Having said that, what exactly are you trying to achieve. It'll help the forum members to come up with a suggestion if you create a mockup in excel and attach relevant screen shots. Thanks, LipChean

LipChean_Soh · ‎07-10-2021

Hi @stukcup You can go to 'Actions', look for the relevant import action, click 'edit' and change the mapping (i believe you just need to make the additional change of mapping the 'Parent' field). Finally you can rerun the import action you just modified. Thanks, LipChean

LipChean_Soh · ‎07-09-2021

Hi @Darcman Assuming you didn't want to rely on an existing card to help narrow the width of your export action (row 2 above), the you can insert a Text card next to your action card (row 1 above), the trick is to turn off the 'Display card background' of the Text card. Thanks, LipChean

LipChean_Soh · ‎07-08-2021

Hi @LancyRebello . 1. I have created a 'Fake Day' list, and a 'SYS Fake Day Details' module. . 2. I created 'Post N' and 'Post N 2' to show the 2 different ways of getting the same results. 3. Post N = IF Working Day? THEN IF MOVINGSUM ( Working Day, 1 , SYS Fake Day Details.'No.' ) = 2 THEN SYS Fake Day Details.'No.' ELSE 9999 ELSE 9999. 4. Notice that the summary of 'Post N' is 'Min' 5. 'Post N' takes up more workspace, but 'Post N 2' is a long nested formula. You'll have to do some test to see which one works better for you. 6. 'To be sent' refers to 'SYS Native Day Details.Post N'. 7. 'To be sent 2' refers to 'SYS Native Day Details'.'Post N 2' Thanks, LipChean

LipChean_Soh · ‎07-08-2021

Hi @margauxplet I can think of 2 options. Option 1 You can upload a data file, i.e. Users.csv into a custom module in the Development model, before creating an action that pulls users from DEV to PROD in the PROD model. Option 2 If you are a workspace admin in the PROD model, then you can go to 'Actions > Import Data Sources > New Sources' to reupload a new but same named Users.csv, before you either run the action from the Actions page, or the published action on a dashboard. A model being in deployed mode shouldn't stop you from reuploading a new but same named file. Thanks, LipChean

LipChean_Soh · ‎07-07-2021

Hi @LancyRebello 1. 'SYS Day Details' is created to calculated the number of days to be used in the POST formula. 2. 'Any' is used in Summary of 'Working Day?' for the purpose of DCA in the subsequent module. 3. PostN derives the number of days to push back 4. 'SYS Day Details.Working Day?' is used as the Write Access Driver of 'INP Collection.Collection', this forces the user to enter Collection amount in a weekday that is not a public holiday. 5. Because 'Any' is activated for 'SYS Day Details.Working Day?', the user can see the total to be collected for each month, i.e. 190. Thanks, LipChean

LipChean_Soh · ‎07-06-2021

Hi @NancyKhurana . 1. Even if your model calendar doesn't have quarter total turned on, you can still create a Time Range with 'Quarter' checked. 2. You can select 'Quarter' from the 'Period' formatted line item, and apply the PERIOD() formula. Thanks, LipChean

LipChean_Soh · ‎07-05-2021

Hi @CommunityMember126793 1. 'Range' list is created with a top level item of 'All Range'. 2. 'SYS Range Details' is created with summary turned off for line item = Low, High, Comm% 3. Depending on the original 'Applies To' of your module, you can add 'Range' to it. Thanks, LipChean

LipChean_Soh · ‎07-02-2021

Hi @jamesreed What does Profile A and Profile B mean? How does Profile A run the action? Is it via an action button on the dashboard? And is the export file in a csv/xls/xlsx format? You also mentioned ' Also if Profile B runs an export from the table on the dashboard the export file is populated as expected.' How is this executed? It would be good if you can add relevant screen shots here. Thanks, LipChean

LipChean_Soh · ‎06-30-2021

Hi @Stacey_Gibbens What does " copy off a new version in his model" mean? Based on how you described the version creation, deletion and recreation, the same can be said of any structural list. Hence i don't see where the 'back to the future' is taking place in your example. Thanks, LipChean

LipChean_Soh · ‎06-30-2021

Hi @jtkerlin There really isn't a best practice for this, because different laptops settings setup their column separators differently, so i guessed consistency is what you should aim for, if possible. Technically, the same import definition can deal with both comma and semicolon as column separator, i.e. 1 import action for 2 different csv formats. 1. Comma as column separator 2. Semicolon as separator However, it becomes a problem if some of your users adopt the European way of using comma as decimal separators, as shown below. Notice how the comma column separator definition is applied to split 9,85 into 2 columns. So i would encourage you to find out what combinations of csv you have amongst your users, and then try to see if everyone can follow the same format. If not, you might need to do some tweaking to the import mapping definition, OR come up with more than 1 import definition for the same import. Thanks, LipChean

LipChean_Soh · ‎06-29-2021

Hi @LorraineGSD Cheers Please close the topic, and mark the topic as solved. Thanks, LipChean

LipChean_Soh · ‎06-29-2021

Hi @LorraineGSD 1. A list (Random List) and its subset (SS First 3?) is created, 2. A System module referring to the Subset is created. 3. The module of which you want to look for Subset can just refer to the System module created above. Thanks, LipChean

LipChean_Soh · ‎06-29-2021

Hi @Jsdeloria21 1. 1. Value line item - is where you set the conditional formatting, correct? Value line item is where you enter the % percentage. 2. %CF - is used to check if the total at parent level is 100%,right? Yes, and whether there's any input in 'Value', it doesn't make sense to set a blank cell to red, even if the parent is larger than 100%, right? 3. the screen shot on number 2 - is this the part where you tell the user that it exceeded 100% already? Yes, and I created a few more examples below. Thanks, LipChean

LipChean_Soh · ‎06-29-2021

Hi @Jsdeloria21 1. Assuming 'Region L1' is the parent of 'Country L2'. . 2. Assuming 'Value' is where you enter the %. 3. '% CF' is used to check whether the total % at parent level is more than 100%. Note that i have added another test to ensure only cells with values are highlighted in red, i.e. blank cells do become red. 4. A System module is created to follow DISCO. Thanks, LipChean

LipChean_Soh · ‎06-29-2021

Hi @Jsdeloria21 You might want to try changing the numbers to: Min: -0.01 Mid: 0.5 Max: 1.01 Also, you should also turn off the summary, because a percentage larger than 100% for parents isn't meaningful. Thanks, LipChean

LipChean_Soh · ‎06-25-2021

Hi @ClarenceAndre Perhaps you can attach an Excel mockup of what you're trying to achieve? Thanks, LipChean

LipChean_Soh · ‎06-25-2021

Hi @pratikjaiswal I'm assuming you're asking this, because you've seen something useful somewhere else. If you can ask a more specific question, it'll allow us to give a more specific reply. Thanks, LipChean

LipChean_Soh · ‎06-24-2021

Hi @Ashishpandit Apparently you won't find the 'Action' card in 'My Pages'. You will need to create a standard Page, before you'll find the 'Action' card. Thanks, LipChean

LipChean_Soh · ‎06-23-2021

Hi @jakesachs The format of the GL records is not ideal, the better way of doing things is to follow https://community.anaplan.com/t5/Best-Practices/Data-Hubs-Purpose-and-Peak-Performance/ta-p/48866 Pls scroll to the area that says 'Good Way' Having said that, pls see if the following works for your current data format: . . 1. I created '99999999' in GBAID as a dummy member. Same goes for 'ZZZ'. 2. I only created the relevant line items along with 3 months worth of data, so you can expand accordingly. 3. I avoided using FINDITEM for Jan, Feb, Mar because it would mean a lot of slow calculations repeated 12 times. 4. I used 'Jan+2' instead of 'Feb+1' for Mar, to avoid daisy chaining. 5. This formula needs to be extended once you included Apr-Dec data columns in the 'GL Records' module above. 6. While this works, you can also see the additional amount of SUM we have to use (12 times more). This is not good for the performance and sustainability of the model. Thanks, LipChean

LipChean_Soh · ‎06-23-2021

Hi @davidlan Pls see the following https://community.anaplan.com/t5/Anaplan-Platform/selection-control/m-p/111362#M26961 Thanks, LipChean

LipChean_Soh · ‎06-23-2021

Hi @drathod After checking with my colleagues, we arrived at the findings that 'Allow editing' is not allowed in My Pages. I was also informed that the training materials asked you to build in My Pages, but i didn't verify that part. So in summary, if you can create the dashboard in a normal page, pls do that; otherwise just ignore this part of the training materials and pls email academy@anaplan.com your findings. Thanks, LipChean

LipChean_Soh · ‎06-23-2021

Hi @drathod I'm not sure that's it, but you can give it a try. You can go to 'Users' followed by 'Roles -> Modules', before you update the relevant module access by roles. Let us know. Thanks, LipChean