About usman.zia

Thanks for sharing @CallumW this would be very useful and save line items when converting.  ... View more

Thanks for sharing @Jared Dolich it would be also great if the New UX had the same capability. ... View more

@karank Thanks for sharing!   @Jared Dolich I believe it came out in janaury or the end of last year or could be when I noticed it!    I haven't seen this in the new UX though!  ... View more

Thanks for sharing @AlejandroGomez great explanation!   Will definitely be sharing this!  ... View more

Hi @Filip    I haven't seen anyway to do this within the new UX builder. The only way I can suggest is to create a saved view within the model where the hierarchies levels are hidden and then use this within the new UX.   There is functionality to show and hide within cards but this only applies to the view on the grid and if it is a selector you cannot hide from it.    So I've suggested the idea here on the community:  https://community.anaplan.com/t5/Idea-Exchange/New-UX-ability-to-extend-the-show-hide-functionality-to-all/idi-p/53062   Thanks,   Usman  ... View more

Great idea @M.Kierepka! the last modified and last modified by user are essential for Anaplan Centres of Excellence! ... View more

Great guide! Thanks for sharing @Misbah!  ... View more

Hi Ceri,    One simple solution would be: To create a new module with a new line item and dimension it by the L2 list.  Then make the formula the original line item which is calculating at L3 with summary method sum. This would then sum up the city level 3 values to country level 2. You could also do this in the original module but it would create a subsidary view which may not be the best way to view the data.    I hope this helps,   Thanks,   Usman     ... View more

Great Idea @Rebecca this would be really useful!  ... View more

Hi @Michael.downer    Currently there is no option to create a display name entry with an action button for a numbered list item creation.    It is possible via an import process if the display name is a property that is imported as the list item is created.    I hope this helps!   Thanks,   Usman ... View more

Hi @HendrikDeCuyper    I believe some of the functionality you describe is coming soon such as: "  -Ability to use the standard Anaplan functionality from the old Dashboards. (Sort, Filter, Drill down)" "- Ability to configure Actions to open a Page"   For the other items I have not seen those described so it may be worth suggesting them as ideas in the idea exchange.    Thanks,   Usman ... View more

Hi @hina1994    You would use some formulas to split the date out into numbers such as: Day Number Use LEFT(Date Line Item, 2) takes the day characters as text Then VALUE(above line item) converts the text into number  ***This could all be done in one line item, so in this format for the purpose of explaining Month Number  Use MID(Date line item, 2) takes the month characters as text Then VALUE(above line item) converts the text into number   Year Number Use RIGHT(Date line item, 4) takes the year characters as text Then VALUE(above line item) converts the text into number   Then you would sum each of these across as explained earlier.   Then to combine them back into date you would use: DATE(Year, Month, Day) This would then give you the date.    I hope this helps!   Thanks,   Usman ... View more

Hi @hina1994    The SUM function won't work on a date only on a number.   One method could be to convert the date into a number and then use SUM and then convert back into a date.   Or if you create a saved view you could try an import process.    I hope this helps!    Thanks,   Usman ... View more

Hi @Yugnesh.Patel  great idea!    I would be keen on continuing the New UX and doing some more live build.   Also happy to help people with their problems!    Also @Paul continue being a legend!    Thanks,   Usman ... View more

Hi @visivasa    I see, it is quite common to not always use the native versions in Anaplan and instead create a dummy versions list.  So the best option for the formula described above is to have another line which stores the actuals and then to have the fomula which switches based on the condition of the timing or the actual cell <> 0.    I hope this helps to support your solution.   Kind Regards,   Usman ... View more

Hi @visivasa    They way you currently doing things is very close to the solution using the formula method.   The best way to achieve your condition for 'Do Nothing' and import actuals instead is too: 1. Create a line item that has the actuals in it and then import the actuals into that line item. Essentially always having them preloaded in the background.This is already the revenue actuals line item you have created so could be reused.  2. In the formula you suggest for the 'do nothing' part then reference the line item created above which is the revenue actuals.    The other method which is more advisesable but again depends on your architecture and use of native anaplan versions.  Is to use Anaplan native switchover functionality, which essentialy switches between an actual version and budget or forecast version. Then you're able to load in the actuals up to the switchover date and then from this point onwards the revenue is forecasted using your calculation method.   Switchover explained here:   "Select the checkbox if you want the switchover date defined for model versions to be applied to a line item. A line item must have versions applied for the checkbox to be enabled. The list of available time periods depends on other settings in your model; see   Time Period Selection. You can set the switchover date for versions in   Model Settings   >   Versions. Switchover does not apply to the   Actual   version."   Some way down the page but link:  https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Modules.html https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Blueprint.html#UseSwitchover   I hope this helps and if you need any further explanation please do ask!   Thanks,   Usman ... View more

Hi @karank    To quote Michael Gould: Each list item carries a memory allocation of 500 bytes per item. This is an estimate to allow for the item name, item code, parent and other built-in properties, along with internal indexing that is needed to give efficient look-ups. Custom properties are additional to this - the size for custom properties is calculated as if they were a 1-dimensional line item. Source: https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Model-sizing/m-p/1177#M1985   So it could be that your model is extremely slim on list item properties?  Also I have seen someone else quote a lower number of  0.0000000074126 as @Alessio_Pagliano mentioned on the link above also.   I hope this helps,   Usman   ... View more

Hi @Chamanpreet and @Jared Dolich    I completely agree with this idea and have put my support forward for both!    This would be incredibly useful in sensitivity analysis.  Also this would be incredibly useful in users being able to create new items in lists and then copy across inputs from other list items.  However this could also be very destructive so there needs to be the ability manage which types of users have access to this type of functionality.  'With great power comes great responsibility' type of scenario.    Thanks,   Usman   ... View more

Hi @Ryan8219    Thanks for sharing!  When I completed the course I didn't make a note of any issues I found but it's great you've made a detailed list!  I'm not sure if there is a specific area on community to give feedback around errors found in the training programs but maybe @emilydunn  could point us in the right direction?    Thanks,   Usman ... View more

Hi @mooreta    I completely agree with what @nathan_rudman has expertly suggested!   But it would be great to know the issues you are currently facing and why you are looking to change the way you import data?    Also I was at CPX London yesterday and I heard talks about improvements coming the currently Anaplan API soon.    Thanks,   Usman ... View more

Hi @OSUBlakester    For the issue you have described there are multiple solutions to choose from depending on what you want your main objective to be.    But first think about what you are trying to achieve and how you will view the outcome.    Things to consider: - Are you going to want to compare the old hierarchy and new hierarchy at any point? If not then you can just update the current hierarchy to the new hierarchy and plan against this. If yes then you need to consider a method for taking a snapshot of the old hierarchy. This could be done by creating a 'Planning Hierarchy List' and a 'Snapshot Hierarchy List' and creating separate modules for each to plan and compare against.    Also it would be great to understand why you change the hierarchy so often and plan like this? Because it could be a case of re defining the process.    It would be great to hear from you and I hope that this helps!    Thanks,   Usman ... View more

@MagaliP I've voted for this idea 🙂   ... View more