About usman.zia

Great picture @Alessio_Pagliano!  ... View more

Hi @PujithaB    Can explain a little bit more what it is that you mean?  Or can you explain what it is that you want to achieve?   Thanks,   Usman ... View more

Thanks @Yugnesh.Patel for organising again great session and great to discuss anaplan with everyone!    I hope to see you all very soon again for the next session!    Thanks,   Usman ... View more

Hi @VickiToy    There could be a possible work around for this without having to use the function you're describing above.  If you are always comparing 2 different versions each time then you could map your versions to a dummy versions list. Such as Budget to D Budget and Forecast to D Forecast.  This would be done by making the versions list a dimension in a module with a single line item called mapping with the format of the dummy list. Then you would map each of the real versions to the dummy versions. Then you could have a module for setting the 2 versions you want to compare each time with a line item for the mapping of version 1 with dummy version format and the version 2 also with the dummy version format.  Then you could reference the calculations for the variance to the version 1 and version 2 version for comparison and reference the relationship for picking up the real versions for the dummy versions against the real versions. And when you wanted to change which versions to compare in your variance you change the inputs in the line items mapping for version 1 and version 2.  Meaning you would change the input for the versions 1 and versions 2 line items for comparison and not the formula each time you wanted to change your version comparison.     I hope this helps to show a potential solution.   Thanks,   Usman ... View more

Hi @abhay.kanik    The Saleforce native connector is no longer supported by Anaplan.  So it is recommended to use the 'Hyperconnect powered by Informatica'.    Please more detailed information here: https://help.anaplan.com/anapedia/Content/Data_Integrations/Salesforce_Integration(PhasedOutEndSept17).html   I hope this helps.   Thanks,   Usman     ... View more

Your name :  Usman Zia  Your company :  Lionpoint Group - Anaplan Gold Partner - Specialising within the Alternative Investment Sector. Where you are on your CoE journey:  As a consulting partner for Anaplan we have developed and are always continuing to develop our CoE . We have also developed in house best practice tool kits, acelerator models and process documentation to support our clients.  If your CoE already exists, how long has it been around, and what is your role:  Our CoE and Best Practice tool kits have been around for since we began our Anaplan journey but have been update regularly . I am a consultant and Master Anaplanner, so my role is to advise on Anaplan Model Building and everything associated with the implementation process and maintenance process of Anaplan Models. What you hope to get out of this CoE section of Community (we constantly monitor this and are always looking for ways to improve!) :   To meet other partners and customers and understand the real world problems we face and how to best approach them. As the technology landscape changes and the business process, how are we approaching this with our Anaplan models. How are we integrating new product developments and how do we add this to our CoE best practice and processes.  Great to meet you all @mealvarez @ChrisWeiss @mb250575 @bdeaton @Jsalvata and learn about your current state and experience.    Thanks,   Usman ... View more

Hi @tsouris    Please see: https://help.anaplan.com/anapedia/Content/Administration_and_Security/Tenant_Administration/Security/ProcuringCACertificates.htm   Thanks,   Usman ... View more

Thanks @nmoore    Great to be a part of this program and looking forward to making many more contributions to the community! ... View more

Hi @Gwen.pryor    It would be great to know what the infrastructutre updates will be?    Thanks,   Usman ... View more

Hi @Chamanpreet    Would be good if you test a few changes to see if it records these changes in the history?   Also could you provide a screenshot of the history.  It could be a bug but I doubt this, alternatively you can contact support@anaplan.com if its a product issue and they can check it for you too.    Thanks,   Usman     ... View more

Hi @elaine.novel    I don't think you can do this by formula (unless proven otherwise). But this can be updated via an import process. If you create saved views of all the subsets with a boolean line item which you can use a formula of TRUE via boolean format. Then you can create an action to import these views into the new subset list property. This will update subset items.  I hope this helps and if you have any questions please do let me know.   Thanks   Usman ... View more

Hi @amnuay    You won't need to rebuild the model from scratch, it just depends on the dimensions you have used and how you have linked your calculations and how you've imported your data.    I would suggest checking that the hierarchy items match items within the data file and make sure that they are mapped when you import.    With calculations you need to check that the hierarchy and lists are being referenced correctly.    It may take some time but if you need more help please send some screenshots.    I hope this helps!    Thanks,   Usman ... View more

Thanks @Yugnesh.Patel    Look forward to seeing everyone and catching up!  If theres anything you need me to do before please do let me know.    Thanks,    Usman ... View more

@AnaplanIdeas I've been running into this issue a lot! Would be great to see this very soon!  ... View more

Hi @Lakshman1997    As @eije.wiersema says it is not currently possible without some workarounds.   However this would be a great idea for Anaplan to incorporate within the model settings and allow users to change them!  So i've suggested it here - https://community.anaplan.com/t5/Idea-Exchange/Alias-Names-for-Time-Versions-Modules-Line-Items-and-Dashboards/idi-p/46613   Thanks, Usman   ... View more

There was guide released this morning but now it doesn't show, I'm sure it will be back up soon. It had a full detailed explanation. I found it by searching for workflow process builder in the search bar.  ... View more

Thanks @AshaPatil I'm glad I could help!  ... View more

Ho @AshaPatil    There are many options to do this and it also depends whether you would like the values to accumulate month by month or just have a total.    For cumulation option please see: https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/CUMULATE.html?_ga=2.122764363.1373801139.1559028810-636186280.1545216924   If you wanted to add the previous value to current value based on time you could do use: https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/PREVIOUS.html?_ga=2.205165392.1373801139.1559028810-636186280.1545216924   To include the boolean line you use the IF formula to decide whether to include the value.   I hope this helps,   Usman ... View more

@abhay.kanik I would go with @DavidSmith 's method! (Learn something new everyday) ... View more

Hi @abhay.kanik    You could add line item within a reference module which is dimensioned by that list and call it 'count' and make the formula '1' so that you have 1 by every item. Next create another line item maybe call it 'list member number' then do a cumulative count of the line item 'count' with the 1s in, then you will get a calculation based 1, 2, 3, 4, 5 etc. and when one member is deleted it will recalculate. Then create another line item called 'display name' then make this convert the number to text and then create a property of the numbered list also called 'display name' which references the module with the line item 'display name' then in the general list settings make this the display name property. Then because the numbering is calculation based the display name will update as the members of the list do. However the numbers of the list items will change as you said but to prevent this would require many processes to clear and re-create the list, so this would be the best option, however I'm sure there are many ways to do it too!    I hope this helps!    Thanks,   Usman ... View more

Great Thanks @AdamB    As soon as the course is open in London please could you let me know.    Thanks,   Usman ... View more