About rob_marshall

rob_marshall

@Epratt Check this and see if this works for you... Rob

rob_marshall

@ChrisHeathcote Formula scope should only work on Versions so I think your instincts are correct.

rob_marshall

@hyudolee Why not just use Lot as your Code and unique member? Why are you wanting to use the "Row ID"? Then import the transactional data (Amount) to a module dimensionalized by Time and Lot. Rob

rob_marshall

@mlecrivain How big is the UAT model and how much workspace do you have? Are the Dev and UAT models on the same workspace?

rob_marshall

@Shrankhla While combination of properties can work, you should try to avoid using this feature as much as possible as it will require you to load all metadata and transactional data via the use of properties as there will not be a true code defined. Additionally, it adds longer load times because the system will have to "figure" out the uniqueness of each row when inserting a new member. A couple of Planual rules to remember: https://community.anaplan.com/t5/Chapter-1/1-05-02-Always-use-a-code/ta-p/71177 https://community.anaplan.com/t5/Chapter-1/1-05-03-Avoid-using-List-Properties/ta-p/71178 https://community.anaplan.com/t5/Chapter-1/1-05-04-Numbered-List-should-always-have-a-code/ta-p/71179 Hope this helps, Rob Thanks, Rob

rob_marshall

@aawd1945a See if this helps

rob_marshall

@Saurabhkumarkunwar Before you start going down the path of a numbered list and since you don't have a code, how many unique values do you have in the first column? That should be a flat list (no hierarchy). Same thing with the LOB (2nd column). Then, create a module dimenisonalized by Time as well as those two new lists (1st column and 2nd column) and import the transactional data into that module. Take a look at this for more information on loading data: https://community.anaplan.com/t5/Best-Practices/Data-Hubs-Purpose-and-Peak-Performance/ta-p/48866 Rob

rob_marshall

@massenm Take a look at this: https://community.anaplan.com/t5/Academy-Training/Course-305-Content/td-p/7418 as well as this training video: https://community.anaplan.com/t5/On-Demand-Courses/Hub-Model-Hierarchy-Management-305/ta-p/202 Rob

rob_marshall

@cbraithwaite Yes, that is correct, so you have to delete every level. Create a process that has the actions to delete all the levels. Rob

rob_marshall

@ChrisHeathcote I think there is an easy solution to this, now that you have given Mark the solution. HA... In your last picture, change the Time Scale format to Week, but keep the overall Time Scale for the module at Month. Added some pictures for your viewing pleasure: Let me know how it goes and if this gets you home. Rob

rob_marshall

@KOBAYASHI If your source has one unique member, it will be a lookup. If your source has multiple members, that will be a sum. Rob

rob_marshall

@Chmacpherson Question, why are you wanting a text field when Text is less performant than a list formatted line item? Based on what you are stating, the Display Name is list formatted (which is the correct way of doing this) and I assume it is linked to an Employee Flat list of some kind. If that is the case, I would also assume the Employee Flat Display Name is text formatted. So, the formula would be: employee Flat.Display Name[lookup: this list.Display Name] where "this list" is the list with a display name that is list formatted. But again, try to stay away from Text. Hope this helps, Rob

rob_marshall

@pdekas In order to help, can you please let us know what modules 1 and 2 are dimensionalized by, as in what is the Applies To?

rob_marshall

@waleedhakim98 I would consider reporting this to Anaplan Support (support@anaplan.com) Rob

rob_marshall

@PujithaB As others have stated, there is no other way, but I will offer this: do all calculations using Native Time for the "other" time hierarchy, and then have a mapping module mapping Native Time to your Fake Time for reporting. Rob

rob_marshall

@KOBAYASHI Because those could be two different answers. The Last Sunday in March is always in March and Sunday nearest the end of March can actually be in April.

rob_marshall

@jtkerlin Please try to refrain from using TextList() as it is performance killer. See if this post with examples of not using TextList() helps. https://community.anaplan.com/t5/Anaplan-Platform/Lookup-Sum-and-Textlist-Cheat-Sheet/m-p/53085#M8205 Rob

rob_marshall

@Sachinsourav02 I understand what @kavinkumar wrote, but you need to be careful here because if I am understanding what you are wanting to do, it is not possible. The main reason, the Display Name that Kavin showed, which is a formula to a module, only works if that module is "flat" meaning that list is the only list in the Applies To. Also, I HIGHLY recommend using a code, especially when using a numbered list. In order to have a project be the same but have different regions, those will need to be different list members rolling up to the desired Country/Region. Lastly, if the Country/Region is a line item in the flat module and is concatenated with the project name, that will work only until someone else changes the Country/Region line item. If this happens, then you will need to make sure your code is independent of Country/Region concatenation. Hope this helps, Rob

rob_marshall

@rakb2020 Please don't post internal information from your company to this Community. If you are attempting to contact to support, that email address is support@anaplan.com. Thanks

rob_marshall

@akibulmn Ok, in that situation, in your delete module, create a line item IsBlank(parent(item('L10')))...this will return a boolean where you can use the "Delete from List using Selection". Rob

rob_marshall

@akibulmn The data that is still there is from the parent list, in your case the Location list. If you want to delete all members in L10, then you will need to delete the "detailed" members of L1 through L9, that is assuming you have 9 lists that are parents. But when you do that, just know it will delete all data in all modules associated with those lists. Rob

rob_marshall

@einas.ibrahim Quick question, when you sync'd the Prod model to Dev, in Dev, did you have a file or source as a placeholder in order to load the users to Production? Rob

rob_marshall

@ChrisHeathcote Please DON'T use TextList(). Folks used Textist() instead of using FirstNonBlank/LastNonBlank but if you look at this thread, there are ways around it. https://community.anaplan.com/t5/Anaplan-Platform/Lookup-Sum-and-Textlist-Cheat-Sheet/m-p/53085#M8205 Rob

rob_marshall

mark.beese@ncr.com Yes, absolutely.

rob_marshall

@dshafton While you can use My Pages, I would rather you get this fixed correctly. I would email support@anaplan.com to get you Page Builder access as I believe further in the training, you will run into issues with using My Pages. Rob

rob_marshall

Hey mark.beese@ncr.com It really depends on the knowledge you have in-house vs. your appetite for having a brand new iPaaS solution. You have a couple of solutions: Anaplan Connect (script file) iPaaS solutions (Informatica Cloud, MuleSoft, SnapLogic, Boomi) Workiva who purchased One Stream (uses API's but has a great wrapper around it) REST API's - totally custom code The benefit with iPaaS and Workiva, they already have connectors created to access systems that are not Anaplan. Hope this helps, Rob

rob_marshall

@L0068407 You cannot have one page hit multiple models, but an App can. So, you can construct multiple pages for these reports and the user can navigate to the proper page.

rob_marshall

@fredrickstraube You can use the function CurrentPeriod() if you are setting the current month in Time Settings. Then, create a SYS Time Module with the following line items: FY Year (formatted as Period Year): The other line item needed is Current Year formatted as a boolean Hope this helps, Rob

rob_marshall

@AntoineHM Which "reset" button are you talking about? If you are talking about the one for lists entity ID's, that can only be done by an administrator, and when the ID's are greater than 900k. https://help.anaplan.com/f5f76c88-127f-4109-b022-d215917cba24-Reset-the-list-index Rob

rob_marshall

@OliverMunns Nothing is stated that you can't have multiple LISS's defined. But in reality, I guess it depends on your calcs and what you are attempting to accomplish. Rob