Do you know where your bottleneck is? Microsoft Dynamics 365 for CE

Now that we are running in larger data centers with the power of Microsoft Azure and with hardware technology such as solid state storage (moving away from the limitations of rotating platters) we all want to take a deep breath and make a sigh of performance joy. 

Unfortunately when you eliminate one bottleneck the data moves to the next. Additionally bottlenecks are not just hardware.

Consider a rock wall layered in a stream of water, you remove the rocks blocking the water, and the water rushes to the next barrier. The same concept applies to data. 

If you are working with millions or hundreds of thousands of data records you might want to consider:

  • Performance Tune the Microsoft SQL Server Database (SQL Server gurus can appreciate this one!)
  • Adding MS SQL Server Indexes to your largest Entities.
  • Watching out or reviewing JavaScript (JavaScript is a language that allows developers to inadvertently and easily create application bottlenecks) Luckily OOB Dynamics 365 has been deeply tested for bottlenecks continuously over the years and has continued to pass with flying colors.
  • Consider Latency (Microsoft now offers data center distributed processing for their Worldwide Dynamics Customers, reducing the trips across the oceans)
  • Understand if you have a bottleneck and where it is (Dynamics actually ships with a Diagnostic tool to check latency and bandwidth: Use https://[your crm url]/tools/diagnostics/diag.aspx  
  • If you are hosting your own environment, you can also tap into the Microsoft Professional Field Engineering teams Performance Analysis and Tuning Services (the PFE Sustainability Engineers Rock) or
  • you might consider a powerful tool such as ThousandEyes:  https://blog.thousandeyes.com/monitor-dynamics-crm-performance/ and https://www.thousandeyes.com/solutions/dynamics-365-monitoring 

What are your favorite tips and tricks for performance? 

Oh and as a last note .. there are customers processing 100,000s of data records a DAY with the Microsoft Dynamics platform. The power is incredible with a little love.

 

 

 

 


In the world of Dynamics 365, configuration/customization/extension does not equal the old world assumptions of "custom software"

When thinking of the experiences or backgrounds needed for any specific project, don't let assumptions trip you up. These terms can help with your communications. 

 

 

Configuration – knowing of and Answering all the questions related to setting up the system for a specific customer. These include all the options under SETTINGs including but not limited to items such as turning on auditing, configuring number formats, turning on relevance search, setting up duplicate detection, configuring territories, setting fiscal year end and more. This is done on every Dynamics 365 project (hopefully) and there are more than 50 questions.

 

Customization – A functional consultants power to configure the system for specific business models such as renaming entities, adding entities, adding system charts, lists/views, adding workflows, creating business rules, formatting the data entry fields and forms, creating PowerApps, setting up relationships between entities and more. The term customization often waffles between configuration and extensions depending on who is using the term.

 

Extensions – extending the functionality of the system using developer resources and many, many, many different code options (.Net, C++, JavaScript, AngularJS, and about 30 more) and includes items such as creating an integration layer with queuing to manage external data integration (although this is shifting to configuration), adding new advanced features, adding advanced automation, extracting/manipulating and resaving data from numerous entities, onSave/onChange/onLoad have the data jump through hoops and blink, etc. The platform is built to be extended and extensions upgrade as they are built using a predefined best practices Software developer kit (SDK) from Microsoft.

 

The world of technology is deep and wonderful. 


Understanding the Maturity of a Feature

As Microsoft releases more and more features, modules and wonderful goodness into the Microsoft Dynamics 365 platform it is good to build out your understanding of the maturity of each feature. The maturity defines the number of layers of updates or changes that any given feature might have experienced as well as it's depth of functionality. You can also relate this to the version of a feature; although, the version is not always the deciding factor. It is possible to have a very mature version 1.0 feature. 

Why is this important? It helps to set the expectations of where the strengths and weaknesses are as you adopt the platform and extend the features. It also helps you understand and manage your expectations around what the speed of change will be with regards to a specific set of features. 

Extract from the people on your team who have worked with the platform for many, many years - You need to knowledge share around the age and growth of key features. It is also important to have these conversations so you can stretch all resources into considering alternative approaches including the experienced team members. Change is not only constant in this wild world of the Microsoft Stack, but it is also speeding up.

So how do we go about understanding maturity? 

As much as I would like to list every known feature in the system (I might save that for a future blog post), I think the key area to start with on each project is with a list of the features that are relevant. When working on a custom service/call center project you might not care as much about the sales automation processes or when working with an xRM or AnyRM project you might not need to be as concerned with cases and knowledge management.

So once you have a high level understanding of the areas of the platform that you want to leverage, make a quick chart of maturity.  There are a few items that you want to capture as follows:

1) When was the feature released? What version (your choices include version 1.2  all the way up to version 9.1.x.xxxx)

2) Understand how the feature or area of the platform fits within the Microsoft Roadmap. Is this a feature that is waning into deprecation or is it positioned for rapid growth? 

3) Acknowledge what the team knows about the strengths and weaknesses of the feature. A good brain sharing exercise. 

4) Understand the feature dependencies. Take for instance, Cases - Cases have a wide set of dependent entities and functionality that goes fairly deep from SLAs to Contracts to Knowledge Base(s) and Closures. 

5) Acknowledge what can and can't be configured. 

6) Understand which ISVs (third party vendors) have bundled offerings that extend the features so you know your choices. Take for instance Accounts - There are numerous offerings that validate addresses and that help with extracting data on accounts from the internet. There are also numerous social engagement offerings including Microsoft's own Microsoft Social Engagement (MSE) Offering.

7) Always keep an open mind for the way that you would solve a problem on your last project is not always the same way to solve the exact same problem on your current project. 

and lastly do a little deep diving into who on the product team or what group among the product team owns the feature set. This research is a key exercise for anyone attending one of the many conferences. Understanding or even meeting the product team who updates and extends features can help you better understand the vision and growth. 

 


Oh Internet Explore

If you have started having difficulty with Microsoft Dynamics CRM or Microsoft Dynamics 365 for Customer Engagement and you are using Internet Explore v11 then you want to make sure you have the latest KBs. The March 20th updates broke a few things, the March 27th updates fixed these.

For Windows 8.1 and 7 SP1 Users

KB4016446 - https://support.microsoft.com/en-us/help/4016446

KB4016446 Download Link - http://www.catalog.update.microsoft.com/search.aspx?q=KB4016446

For Windows 10 users search the catalog for

Windows 10

http://www.catalog.update.microsoft.com/search.aspx?q=KB4016635 

If you have other Internet Explorer Issues then you might want to walk through this set of Articles.

Compatibility Settings https://support.microsoft.com/en-us/help/3124955/compatibility-with-microsoft-dynamics-crm-2016

Internet Explorer: Web application requirements for Microsoft Dynamics 365 https://technet.microsoft.com/en-us/library/hh699710.aspx

Internet Explorer: FAQ for IT Pros https://technet.microsoft.com/itpro/internet-explorer/ie11-faq/faq-for-it-pros-ie11

Microsoft Edge Deployment Guide for IT Pros https://technet.microsoft.com/itpro/microsoft-edge/index

Compatibility Changes in IE 11 https://msdn.microsoft.com/library/bg182625(v=vs.85).aspx

 

 


Keeping a Clean House: Sometimes it is about the data

Microsoft CRM supports tracking of e-mail messages and e-mail messages often come with attachments. If you want to prevent Microsoft CRM from storing an e-mails attachments you can set the file size within Configuration to 0.

What if you don't want to block all attachments or what if you inherited a system that has a ton of attachments stored in the database?

You can purge e-mail attachments from the CRM Database.

Take a look at the EMEA Support Teams Blog Post on the subject for more.

Kids-cleaning


Out of the Box (OOB) Microsoft Customer Relationship Managment (CRM)

If you don't know what you get out of the box, then you might be inclined to ignore all the greatness and create your own entities. This is an option, but what it tends to bypass are all of the OOB integrations and small enhancements that offer some incredible power.

Take for instance "Case" and "Case Resolution" These two entities are a married pair. The first tracks the incoming details on any specific case and the second tracks all of the different derivatives of the resolution to that case.

For instance a case can be cancelled with a reason or it can be completed with a failure or a success.

It should be noted that when closing a case, the configuration offers choices. The status reasons can be modified for each Status of ACTIVE and INACTIVE.  

Status Active - Status Reasons

Status Resolved - Status Reasons Status Cancelled - Status Reasons

 


So you want to configure your Dynamics CRM System?

First define your desired architecture! (Think Design your addition or house)

Then do some reading and planning! (for instance you might want to have your upstairs bathroom above your downstairs bathroom to make the plumbing easier)

Consult an expert or hire an expert! (They have the experiences of numerous projects rolled out successfully that are often very, very, very similar to what you are doing)

If you want to learn by doing, calculated in the learning curve, because you will make mistakes and you will want to have a plan for fixing the mistakes so that the system is not compromised. (Consider what happens when that addition to the house or the house is not built to code)

Reading: Take a peak at this great TECHNET content!


Microsoft Dynamics CRM Support Lifecycle

Microsoft Dynamics CRM is a continuous book, with pages being edited and new pages being added with each release. Those who build their projects to live with the growth of their companies do not need to be concerned for the book continues as your business continues.

For those who are still running Microsoft Dynamics CRM older versions, this page might be of interest. The Microsoft Support Lifecycle Page

What is a Support Lifecycle, you ask or more appropriately, what is the support lifecycle policy? There is more on the website, but consider this ...

"What is the Support Lifecycle policy?
Microsoft provides an industry-leading Support Lifecycle policy—in length and provision—giving customers consistent, transparent, and predictable timelines for which software is supported."

 


Thinking of an Upgrade to Microsoft Dynamics CRM?

Are you thinking about moving your Microsoft Dynamics CRM instance to Azure? Or perhaps you want to move to CRM Online? Maybe you just want to upgrade from a much earlier version to the most current version?

Microsoft Consulting Services has a set of services that will provide you with an upgrade assessment.

Now is a great time to get that assessment done and to start thinking about polishing up the heart beat technology of your company. The products every one of your staff use : Microsoft Office (or O365) and Microsoft Dynamics CRM!

Learn More


Smart Clients

In catching up with the communities I saw comments regarding a client who wanted to make sure development and extensions were supported.

Kudos to the client for recognizing that Microsoft Dynamics CRM is flexible, configurable and extendable with supported paths and that developers can sometimes be a little too creative without remembering the long term cost.


Answers to the easy and hard questions to consider as we think about Managed and Unmanaged Solutions (#Msdyncrm)

Answers to the easy and hard questions to consider as we think about Managed and Unmanaged Solutions

1) How do you create a managed or unmanaged solution?

  • Select Settings
  • Select Solutions
  • Select New

New Solution

  • Give your solution a name
  • Add a publisher (see next question for details on publishers)
  • Add a version such as 1.0.0.0
  • Add existing entities you want to modify or new entities you want to create
  • Save your solution
  • Export as either an unmanaged or managed solution

2) What is a CRM publisher?

A publisher allows you to define a prefix and variables for your solutions. A publisher can be used to organize or classify components added to a solution. To create a publisher

  • Select Settings
  • Select Customizations
  • Select Publishers
  • Select New
  • Publisher
      Newpublisher
    Give your publisher a name
  • Set your prefix
  • You can also set the starting number for any values in option sets
  • Save your publisher (you can now use it when creating solutions)

3) What benefit does the publisher give the customizer?

  • Every component (attribute, entity, etc. is prefixed with that publisher prefix)

4) What happens when you import an unmanaged solution?

  • The solution is merged with all other unmanaged solutions.

5) Can you export a managed solution?

  • No, you can only export an unmanaged solution which gives you the option to create a managed solution.

6) Who is the primary audience for managed solutions?

  • Independent Software Vendors (ISVs)

7) What are the disadvantages of using managed solutions?

  • The components of a managed solution can not be changed.

Visual Studio Online

Did you know that if you track all your requirements and backlog iteration items in Visual Studio Online you can easily bridge Business Speak and Developer Speak?

The developers live in Visual Studio, writing code and looking at lines of characters that are often Greek to the non-dev folks, but by using work items in Visual Studio Online you can all work in one world.

Better yet, you can add Microsoft Test Manager test cases and link those to the work items. Just for fun you also get full graphing on burn down and task management.

I like the AGILE TEMPLATE, but also use the SCRUM Template despite my mantra of all CRM projects should be ITERATIVE or a mix of AGILE and WATERFALL.

Check it out: https://www.visualstudio.com/en-us/products/what-is-visual-studio-online-vs 

PS: Online, available from anywhere and it sync's with your local version of Visual Studio and Office AND there are some free try it out options.


Dev to Dev, Let them out once in a while

Sometimes the developers have to sit at the table and talk to each other.

In the really big Enterprise projects, where you bring together the greatest of the great (sometimes still bleeding) AND you pull in the well established, proven technologies, you often end up with a wide variety of languages, thoughts, strengths and weaknesses. (sprinkling in acronyms and it can get really crazy) 

Each person is a deep expert in their specialty, but getting each expert to use a language that other experts can understand is a challenge worth noting. 

If one person is talking Plugins, Processes, and Actions and another is talking approval cycles, statuses and signoffs and a third is discussing throughput, bottlenecks and distribution you might have a disconnect.

The trick?

Recognition. : Acknowledge and recognize that different languages are being spoken.

The second Trick?

Diversity Training : Point out that each person is incredibly different, show a few videos.

The Third Trick?

Collect all the egos and put them in a bag on the table. They cause so much heart ache!

Now add transparency. Acknowledgement and diplomacy.

I have yet to master all of the above. My fears, well ingrained XRM/CRM Think, opinions and even my female blond hair have known to get me in trouble, but  I don't regret my transparency and shared knowledge. I regret my lack of occasional sensitivity. I get so excited about the project and the technologies, I can forget about the people.

It does TAKE all variables. People, Process, Technology (well recognized buzz)

So back to the first line of this post. In the world of partners, there is this tendency to yell over the fence to the developers the criteria and requirements that need to be met. This works for many a plugin or DLL, but sometimes the developers really need to talk to other developers.

So this is a shout out to partners, vendors and ISVs to let the guys and gals with their heads down coding out in the field, to fine tuning their business skills and to encourage them to participate in some dev to dev discussions.  It can increase quality and create a bigger network of knowledge shared, knowledge learned.

Oh and a message to all developers in the world of Dynamics CRM and External apps talking to CRM: Keep an open mind, find the STRENGTHS and learn how to work with the not yet released or newer weaker areas, from those who have mastered the road before you.

Your developer peers are a close knit team writing code every day with variables that you might not be aware of.

 


Calling All CRM Users: Please send feedback on the new DYNAMIC HELP Features!

 

Calling All CRM Users: Please send feedback on the new DYNAMIC HELP Features!

"This feature was introduced in the Dynamics CRM 2015 for Outlook Client and is referred to as “Dynamic Help”.   Prior to this feature, the Outlook Client included a help link that always directed you to the same troubleshooting page regardless of which error you encountered.  For each error code that occurs during configuration, Dynamic Help can now direct you to a KB article designed to help resolve that specific issue.  This feature was also backported to CRM 2013 Update Rollup 1 for Service Pack 1 and CRM 2011 Update Rollup 18.  The Dynamic Help feature is also included in the new CRM App for Outlook. "

To Read More and To provide Feedback CLICK,

One Person Can Change the World!

 


Developer? New to Microsoft Dynamics CRM?

Many years ago when I was trying to ramp up on all things Microsoft Dynamics CRM, I started with the What's new features. I took each feature and mastered it and moved to the next. We also had a great need to depend on books and externally provided information. Needless to say one reason I wrote a book.

Today is Different.

Today developers new to Microsoft Dynamics CRM are lucky to have the Microsoft Dynamics CRM Developer Center.

If you have not visited, check it out!


The Power of Choice (and the risks)

One of the most fabulous features of Microsoft Dynamics CRM is the number of choices that any given business can have when leveraging the power of the toolset. This helps the solution and the product, the processes and the people to grow and change as businesses grow and change. 

This is also one of the biggest dilemmas for the "New to Dynamics CRM" crowd. Choice makes a number of seasoned veterans to business applications scratch their heads and ask "Why". They assume that what they see is what they get.

They often mention things like "Why does the product do this out of the box" or "I need to talk to the development team about how (pick your vendor Siebel, SAP, Oracle, etc. etc. etc.) models this differently". They can even lock themselves into a box by eliminating a huge number of choices and blocking these from the business because of their own filters.

What is often misunderstood is that the consulting partner, resource, resources, mix and match team or IT department that a business works with, needs to understand both your business, the CRM Industry and methodologies for success and the depth of the technology.

This is a big ask, but so many customers have found success! It is not an impossible ask.

This post is to encourage CxOs to consider and discuss and participate in technology as part of their long term growth and to insure that the adaptability of that technology is part of the discussion. Take small bites (small phases) and let teams grow, change and mature on a continued and seamless path to success.  Lastly don't make a decision and walk away. The heartbeat of a business is living and changing and many times always being updated. Setup reviews both of the solution and of the processes and make continued decisions.


Integration, Integration, Integration

Microsoft Dynamics CRM is providing ONE PLATFORM for so many different applications out there that I can't even keep up. It is built to be one and it is built to integrate so that it can display, interact, pull in and/or integrate all of your data and all of your applications.

Now that Dynamics CRM is one of your options, what are options for integrating all of your other applications? Don't get stuck with even more distributed data, leverage MCS or leverage one of the great Microsoft CRM partner resources.

A bunch of field resources put together their knowledge and released this WIKI article on Microsoft Dynamics CRM Integration and I must admit it is one of the most requested tips that I get. If you have more to add, dive in or if you just need answers take a look.


Don't Forget a Bit of Dynamics CRM Housecleaning!

The people who work on Microsoft Dynamics CRM don't always know all the details of loving and caring for Microsoft Dynamics CRM and although it doesn't need much, it does like some care.

This is why the community is so incredible and no amount of thanks can truly show the appreciation for the hundreds of hours community members spend blogging and sharing great information.

So today  I am sharing an older post for those using all versions of Microsoft Dynamics CRM, but particularly for those who might want to do even more to keep their system singing and moving along.

Take a look at this blog post about maintaining the tables that many business analysts depend on for efficient workflow functionality.


xRM Best Practices

Microsoft Dynamics CRM is an incredible out of the box, configurable system AND is also used as a development platform. As users adopt and learn some of the incredible features they quickly realize how many other systems it can replace.

It is like an awesome heart that embraces and wraps all things "need a solution" into it's solution platform, BUT if you have never worked with Microsoft Dynamics CRM then you can make a bit of a mess.

The following are some best practices for working with any technology in today's world.

1) Always ask yourself. If I extend or I get a developer to extend my product how does that align with what the Out of the Box Development team is releasing. They are writing code daily as well., but MANY extensions are 100% supported with all rollup updates and upgrades being easy to install, but some are not and we know how creative developers can be. Make sure your developers think xRM. 

2) Understand and stay current with the product roadmap. Major releases are now coming faster and faster and faster. Two incredible major releases this year and with CRM Online driving an elimination of the world of the "upgrade" staying alert is key.

3) Love the SDK. Yes, you are a .NET Master and a long time senior developer, BUT the Microsoft Dynamics CRM Software Developer's Kit offers you so much more and helps to define the rules of engagement.

4) Embrace the well loved and well used Dynamics xRM Tools, but know who wrote them and their strengths.

5) The Dynamics CRM platform is a set of many different options. Too much choice, but so much choice can also be wonderful. Understand your choices - there are times when adding an ISV solution is so much smarter then building your own, and even within Microsoft the choices are many. Take for instance customer service on the Dynamics platform with and without Parature or Microsoft Social Engagement (also referred to in the past as Microsoft Social Listening) and of course there is the entire Office 365 suite that is forever growing in terms of new cool.

6) Work with a partner who has proven experience building long term supportable xRM projects OR if you work with a partner new to Dynamics CRM understand the risks. Learning curves can be frustrating for teams.

7) IT looks easy, and can be easy, but never under estimate the power of the CRM Architect. It is easy to drive a nail in a piece of wood, but rarely do you build a house without an architect OR add an addition onto an existing house without some review of impact.

8) Don't change software products because you picked the wrong vendor. Hundreds of CRM failures across all vendors have occurred going back 40 or 30 years. People, Technology, Process all have places that need continual current review. Many times it is not the software that is the issue.

 

 

 


What's New - Thanks to Dynamics CRM

One of the best parts of being semi-snowed in is that I can convert my travel time into learning and sharing time.

Let's look at a feature that everyone assumes that everyone else knows about. The What's New Social Pane.

Why do I point this out? If your team uses activities to track, retain touches and to communicate (e-mails) this pane gives you an incredible look into which contacts and accounts are actively engaged. It also lets you see an account that is requiring extra attention, a colleague who is working on something that you can help with or an activity that you needed to know about. (but because it is so easy to get into our own little spheres it was missed)

It is about raising the bar of transparency and shifting a culture and it is about creating a culture of sharing among all the users of your Dynamics CRM system.

What only inside Dynamics CRM?

Well actually NO! If you have YAMMER enabled you click a button in configuration and configure Yammer and your YAMMER Feeds become an option under What's New. Bringing in other (even perhaps non-CRM user) conversations into the mix.

Just imagine!

WhatsNew
 


Back in the CRM v2011 Days

Back in the Microsoft CRM v2011 days there was an issue with the “Send an error report to Microsoft” configuration where the OOB features of Dynamics would cause generic errors to appear when in reality there were no errors or perhaps just a slight delay. The timing was over sensitive so although there was some debate about it is designed to do that, it was doing it way too often.

In the field we turned off the alert.  The message was not helpful and also would block an occasional real error. Needless to say for a year or two we would need to turn off this feature both under Settings, Administration, PRIVACY settings and under a user’s personal options.  

Does anyone remember these times?

Does anyone still have a blog post on the issue?

 

 


Fine Tuning MS CRM for Enterprise Level Performance

Microsoft Dynamics CRM has now been running in some of the largest enterprise accounts across the countries, but with millions and millions of transactions comes a need to fine tune so here are a few tricks of the trade from the Enterprise Technical Developers, Database gurus and Consultants!

1) Although perhaps obvious, it is worth adding Indexes to your  SQL Server Database if you are dealing with millions of transactions

2) Enable the Quick Find Limit and encourage users to use Advanced Find when doing more sophisticated searching

3) Kerberos authentic can cause performance issues if it is not turned on AND if it is hitting various incompatibility with different server versions, particularly really old versions so check your server versions and your Kerberos.

4) Go back to the basics at the front end CRM Server, Do you have "Enable HTML Compression?" Set to  Yes?  Turn it off

5) You can also "Turn off the Page Counter" for the Grid  1 of 250, 5000+

6) Review the columns that you have enabled on Quick Find, for each column added the query is increased and overhead is increased.

7) Review the following SQL Server Flags with your CRM SQL Server guru

  •  MAXDOP =
  • IDSCountForUsingGUIDString =
  • IDSCountBeforeCausingJoinsForSecurity =
  • Optimize for Adhoc =
  • ERMO =

 


Microsoft PFE Team (Premeire Field Engineering) releases awesome ticklers as well

AND the PFE Team (Premeire Field Engineering)  releases awesome ticklers as well. Take a peek at this little tidbit enhancement to Quick Find !

and you can follow the CRM PFE Team Blog !


MICROSOFT Dynamics CRM and the huge CRM Community!

The Microsoft Dynamics CRM Community has an incredible history of leveraging the Dynamics xRM platform to meet some really tough business challenges. If you work with a proven Microsoft Dynamics CRM partner or with Microsoft Consulting Services (the MCS CRM Team), they bring to the table their own incredible library of experiences, but also their own depth and reach of resources and tools.

Knowledge in "CRM" is critical.

There are also great open source resources such as CODEPLEX where partners and clients can download and take ownership of kick starters and CODEPLEX is not Dynamics specific so you can tap into the entire Microsoft stack.

To follow the team at CODEPLEX, read and follow their blog.

Search on CRM on CODEPLEX

AND CODEPLEX is really just a small taste of the greater community resources. Take for instance following a few Dynamics CRM Specific blogs such as some of the ones listed on this blog. You start and the list just grows and grows and grows.  The number of shared resources, code snippets, tools, configuration best practices and more is so unlimited. OK, so you are now tapped into the blogs ...

Have you looked into the ISVs? The Independent Software Vendors writing solutions to compliment the Dynamics CRM platform? Take a peek at ADXStudio for instance who has a huge library of PORTAL options and ALM! or perhaps empowering SALES Teams with complex ordering proposals and integration? Look at Experlogix or maybe you just want some nice address verification and compliance, you can talk with Dun & Bradstreet.  The list really is endless!


What is a Microsoft Dynamics CRM View?

Within Microsoft Dynamics CRM each entity has a set of system views. These system views can be configured or added to and as such are a powerful feature within the system. You can even create new views.

So what exactly is a view?

If you are familiar with a spreadsheet, you know that you have rows and columns of data and each piece of data sits in its own little cell. A view in Dynamics CRM is just like a spreadsheet. It has rows and columns of data. Additionally any given view in the system also let's you "click" and export to Excel.

Other powerful features of views include the ability to add columns of data from not just the entity where the view is defined, but from every entity that is related to the entity where the view is defined.

You can also sort views of data by clicking on the header of a column and secondarily sort by shift clicking on the next column.

People using Dynamics CRM can also use "Advanced Find" to create their own personal views of data. So if your IT Department is a bit buried under a long to-do list, you don't have to wait. You can create your own personal views AND you can even share these views with your peers or manager.

OK, so you really don't want to give up Excel and all the pivoting and graphics that you can do with it. Guess what, you don't have too! Views feed Excel and all the powerful data manipulation techniques that Excel offers. Check Out PowerView, PowerBI and PowerPivot, if you love Excel, you will go over the top with these Excel add-ins. CRM + Microsoft Excel "Better Together"

Views have another role within the world of Dynamics CRM. They feed charts, so setup your favorite view and then use the CRM Chart feature to chart the data from that view. These charts can be added to Dashboards for instant, dynamic, graphical love!

If you want to learn even more about views you can read about them in the MSDN library entry called Customize Entity Views.  


What Are Some of the Default Entities? #msdyncrm

When you purchase Microsoft Dynamics CRM a number of entities come with the system (if you need a refresher in entities, see previous post). You can create hundreds more, but here are some of the building block Entites.

  • Lead
  • Account
  • Contact
  • Address
  • Opportunity
  • Case
  • Case Resolution
  • Activities including
    • Social Activities
    • Tasks
    • Appointments
    • E-Mails
    • Phone Calls
    • Faxes
    • Letters
  • Product
  • Article
  • Competitor
  • Connection and Connection Role
  • Contract
  • Document Location
  • Entitlement
  • Goal
  • Invoice
  • Order
  • Price List
  • Queue
  • Campaign
  • Team
  • User
  • and so much more!

 


What is an Entity? #msdyncrm

What is a Microsoft Dynamics CRM Entity?

Think first about a table within a database and then add more. A entity in CRM is one focal point of data including a set of fields, a set of views, a set of forms, a set of relationships and more.

An  entity includes an unlimited number of system views that display the data in a spreadsheet like format. Views can also include related data.

An entity includes an unlimited number of data entry forms, although many rollouts have one form per entity. A form is a set of fields laid out in a manner that allows easy data entry. Forms can be tied to security roles.

An entity  includes relationships to other entities. For instance you have an Account entity that has a relationship to a contact entity and this relationship is one account to many contacts. You can also have different types of relationships including One to Many, Many to One, and Many to Many.

An entity includes Charts. A chart is a graphical representation of the data that is contained in the entity and it's related entities. Charts can also be filtered and displayed based on the views.

An entity includes system messages that can be configured.

An entity can be named or renamed to represent the specific needs of a business. Take for instance Account, the Account entity can be renamed to be Company, Corporation, Building, Farm, Sign, Hospital, Department, Office and more.

New entities can be created to meet the demands of many different types of businesses and data tracking.  


Rollup 15 MS Dynamics CRM v2011

Microsoft has posted CRM v2011 Update Rollup 15.

Do you have a lot of other OutLook Integrations? CRM Outlook Client causing you grief on just one machine? 

This  rollup includes “process isolation” to split the Outlook Client out from the core Outlook process, an upgrade to SQL CE 4.0, and reductions in isolated performance issues with a large address books (among other things, it’s all in the KB)