About DavidSmith

@roger_griffin  We can't control List Properties in the same way as line items (one of the many reasons why we prefer not to use List Properties), so what I would suggest is rather than publishing the numbered list, I would publish a module dimensioned by the numbered list, with a line item to enter the display name.  Then link the display name property directly to that line item,  That way you can use DCA and you may find more flexiblity in what you show/don't show from the list I hope that helps David ... View more

@Jaakko @aatan  I would always try and avoid SELECTS if possible.  Using lookups is more flexible, even for top levels You don't mention that Rate is a line item in the Calculate module, but if it is a value, then you cannot use rate as a lookup parameter.  SUMs and LOOKUPs only work with formatted list items Assuming Sites and Sites and services are the same list (or Sites are a subset of Sites and services), and Rate is a value, you should be able to use the No of days line item as the lookup. I would read the following articles which explain the concept and relationships for SUMs and LOOKUPs well   https://community.anaplan.com/t5/Best-Practices/Converting-data-between-line-items-with-different-lists/m-p/37946#M1740   https://community.anaplan.com/t5/Best-Practices/Need-help-with-SUM-and-or-LOOKUP-functions/m-p/37145#M1686   I hope that helps David ... View more

@UMAMAHESH Hi Uma You will have to use a filter to achieve this The solutions described below only works with numeric values because it uses Line Item Subsets but it might work for you. If you need to filter out other attributes, then I suggest you split the inputs into different modules for each version and bring the data back together in a summary module.  you can direct users to different dashboards based on a list selection on a dashboard. See here for more details on that technique: https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Actions/Other_Actions/Open_Dashboard.html   The first solution assumes you have the versions dimension in the target module (You should also consider if this design is appropriate because of the sparsity of the module. See the point above about different inputs    Assuming we have this module: 1. Create a line item subset: https://help.anaplan.com/anapedia/Content/Modeling/Dimensions/Line_Item_Subsets.html      2. Create a filter module using this line item subset from the above and the versions dimension and "tick" the appropriate line item/version combination: 3. In the target module you now set up a filter to reference the above filter line item: 4.  The line items now filter accordingly:         The next solution assumes that you don't want/have the versions dimension in the target module.  Depending on the sparsity mentioned above, this might be a more practical and efficient design 1. Set up the line item subset as 1. above 2. Create a list 'Versions choice' - this is effectively a replica of the Versions list (as you cannot use Versions as a formatted item) 3. Create a "Choice" module with a single line item formatted as the list from 2. This can be published to a dashboard for the users 3. Create a module using the line item subset from 1. Add two line items, the first formatted as the list from 2. and the second a check against the module above The formula for Filter = Applicable Version = Filter Choice.Versions Choice 4. Apply the filter from 3. to the target module 5. The line items filter as before   I hope this helps Good luck David ... View more

The above (Line Item Subsets) is definitely the most efficient, but it will only work for numeric values You can use versions as per the previous post and use Version Formulae to pick up the relevant line item You will set up a line item subset in the target model  See here for more details https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Add_Version_Formula.htm Good luck  David ... View more

@ankiutel You won't be able to do that kind of check However, you can create a line item that is formatted as a time period (Months) and publish that to the dashboard.  Then you can check that line item using the IF ITEM(TIME) = Selection module.Choose month   If you need the use to only select certain months (so either Jun or Dec), you'll need to create a list with those two members, create a module by that list with a line item that is formatted by month.  the the check will something like: IF ITEM(TIME)= Choose months.Month[LOOKUP:selection module.Choose month]   I hope that helps David   ... View more

@Pronoy You might find this poist helpful too https://community.anaplan.com/t5/Best-Practices/Change-fiscal-year-without-losing-Data/m-p/37949#M1696   David ... View more

@visivasa @chris.friederic @Griffink Hi This is a know issue of summing from a time dimension to a module without time, but the good news is that is can be solved 1. Create a fake list of days covering the timescale. 2. Create a module using 1. above and and map the real days to the fake days on a 1:1 (start is formatted as date) 3. You also map the Cohrt months here too 4. Create a module also dimensioned by the 'fake days' (in my example I also need Products) and map the data from the real source into this module using a lookup from the above mapping module.   5. Map the data into you Cohrt Months target module using the first mapping module I hope this helps Good luck David        ... View more

@Sheethal There is no advantage or disadvantage of the "ordering" as such and have had discussions internally about automatically re-sorting list.  What I would say is the consistency of the ordering is actually more critical than which comes first.  I would always advocate ordering the modules in the way you think about or describe the business and be consistent.  This may be different to how you have ordered the lists in the General lists, It is also worth pointing out that any views of the module (including the default view) are not impacted by the ordering in the Applies setting.  It is worth adding a request to the ideas exchange if this is something of high importance to you I hope that helps David ... View more

@andre.lie Hi Unfortunately, I don't think you can do the "reverse" sync as you describe.   However, you might be able to achieve a similar effect using filters If you create a filter in Module 2 that is referencing the selection in Module 1, you can use that to "sync" module 2.  The filter will stay active even if the list is pivotted to pages.  It does mean that you will have to lose the page selector for the list, but it might work         The filter line item has the following formula: ISBLANK(Selection.Selection) OR Selection.Selection = ITEM('1-10') You use the BLANK check to allow all items to be shown if nothin is selected   1-10 is my list (although I was using a subset 1-3)   I hope this helps, even if it's not quite what you are after David ... View more

@andre.lie By default you can't assign Roles to Line items. However, using Dynamic Cell Access you can assign access by User to line items (using a line item subset), although this will only work for numeric values If you want to assign this access by role, you will need to create a dummy list of roles, assign the users to the role and then map the access to the users.  you can then apply this to a module dimensioned by users and the line item subset. This can then be applied to the module Have a look at this App in the App hub (and the associated video); there are worked examples of line item access https://community.anaplan.com/t5/Learning/Dynamic-Cell-Access-Learning-App/ba-p/33869   I hope this helps ... View more