About usman.zia

Thanks @rob_marshall  please be sure to share the link to idea and you'll have my support!    ... View more

@Jared Dolich @rob_marshall    List item order management is something that can be difficult to manage in models that are always growing.    Has there been a best practices guide published on this?    Thanks,   Usman ... View more

@jatinnayi  Also could you show the formula for the cell that you are drilling down on?    Thanks,   Usman ... View more

Hi @jatinnayi,   Is the list you are using a numbered list?    If it is then then the creation ID will display the order of how it shows in the drill down.    Otherwise I would expect it to show in the correct order as in your hierarchy structure.    Please can you explain which type it is.   Thanks,   Usman ... View more

Hi @Alessio_Pagliano,   Great point you've raised here!    Do you have an idea of the current requirements / functionality where these changes may have an impact?   When other providers change their systems / platforms it is always very important to consider the impact to our current anapan ecosystems!    Very important to stay up to date and tackle issues as soon as we see them!    Thanks,   Usman ... View more

The global search is a great development of the community platform!    Loving the new icons and statisitics! As soons as everyone sees this post navigation will become a lot clearer!  Is it worth having the page as blog post so it can be viewed on the homepage?  ... View more

Great idea @shreyak.garg having more flexibility in design is key to having the best looking dashboards!  ... View more

Hi @hgrosen    I believe this is on the roadmap already as it is one of the key features and selling points of anaplan but not sure when we can expect it to be released?   ... View more

Great Idea @shreyak.garg this is definitely something I have been thinking about!    Reading KPIs can sometimes be confusing and having clear colours to differentiate the performance of the KPI is a great way to do this!    I hope to see this soon!  ... View more

@CommunityMember113703    As both @rob_marshall and @Misbah  explain text can easily cause performance issues and created really large memory modules.  I would first question what is the need to have this process in Anaplan?  What you are trying to achieve can also be possible to do before the data enters Anaplan and cleansing the data outside of Anaplan is more efficient. Have you considered this?    Would be great to hear more about the use of this.   Thanks,   Usman     ... View more

Hi @karank    I agree with @VIGNESH.M approach to the problem.  Creating more line items to simplify the complexity and allowing you to see the how the access works is the best option. Also worth testing a few cases to make sure it works for all scenarios!   Thanks,   Usman ... View more

Also I have not tested this but you may need to create another setting to allow the dummy versions to switchover from actuals to version.    This can require some effort but is easier for the user / admin to manage then having to remember which formulas to change.  ... View more

Hi @MarkT83,    Great question and I'm sure there a numerous answers which really depend on your use case!    First of all I would point out that the first decision is always to decide whether to use native versions or a dummy version list.    This decision is often made easy but deciding on the number of versions you will require and whether you will need to optimise performance by creating a subset of versions to reduce sparsity. Also as you will know some of the functionality that can be used on versions versus a general list are limited which means you may have to use the select formula.    In the case you describe I can see you've opted for native versions meaning you have to use select.  As select on versions is not always sustainable you must consider creating flexibility and allowing yourself to not have to change the formulas every year. In this scenario it always better to create a module where you can reference the version that needs to be selected for the formula, this way you can change which version is selected. I would suggest creating a dummy version list and mapping it to the real versions and then use a boolean to define which version to lookup for your formula, for this to work the module will need to be dimensioned by the dummy version.    I hope this helps!   Thanks,   Usman   ... View more

Hi @DavidSmith,   Just wanted to say thanks!   You really have been an inspirational leader on the community and I'm sure you're the one person everything thinks of when theres a complex problem to solve, the great mind that can solve it is you David and this will be a real loss! But having said that there are many great members that have grown because of your efforts. I have learnt so much from you and it will be sad to see you go but nonetheless when duty calls you have to go! You have helped so much to support an incredible and unique learning and development platform and it truly has inspired me to become the best anaplanner I can become so thank you so much David! I hope to see you at anaplan event soon!    All the best in your new role and have a very merry christmas also!    Thanks,   Usman ... View more

Hi @segadvd,   The community site has developed since I made the posts so I believe the links have changed.   I will repost the links and if they don't work please let me know and I can direct you.   The link to the level 1 on demand training: https://community.anaplan.com/t5/On-Demand-Courses/Level-1-Model-Building/ta-p/54499   University connect program:  https://community.anaplan.com/t5/University-Connect/tkb-p/universityalliancetkb   I hope this helps!   Also if you're based in the UK and are wanting to join a university connect program please message me and I can help support to set it up.    Thanks,   Usman ... View more

@Stan    Is the User Directory live now? ... View more

Great solution @DavidSmith thanks for shaining!    This is complex but it a great solution for avoiding large if statements!  ... View more

@Jared Dolich    Unfortunately Imgur only keep images that receive 1 view every six months if they are public images.    Thanks,   Usman ... View more

Hi @DeveloperCYT    You can get images with a suffix:  1. on the top menu under your username go to images 2. Then select the image by clicking on it which opens an inpage window. 3. Then copy the direct link which will be a .png or .jpeg   If you have any difficulty I can provide screenshots.   Thanks,   Usman     ... View more

Hi @DeveloperCYT    Thanks for posting your problem. I haven't experienced this before but my thoughts are since sharepoint is a microsoft product it may not work so well with a mac for image hosting (just a thought and could be wrong). I would initially test another image hosting solution such as https://imgur.com/upload (very safe one to use). Then use this link to test and see if you experience the same issue in both mac and pc.  As I would believe this is hosting issue and not an anaplan issue.  Would be interesting to see the results.    Also which web browser are you using to do this test?   I hope this helps!   Thanks,   Usman ... View more

Great Idea @ablack I've come across this issue before but have always used the workaround! Would make sense to build the functionality to support this use case.  ... View more

Thanks for sharing @Noemi.andres great to see this functionality live!  ... View more