Analytics Accelerator R2 for Microsoft Dynamics CRM 4.0 available – now for SQL Server 2008
Accelerators, Consulting, CRM 4.0, Downloads, Salespeople June 23rd, 2009
Microsoft recently released the Analytics Accelerator R2 for Microsoft Dynamics CRM 4.0 on CodePlex. This version adds reporting for SQL Server 2008, as well as enhancements to the older SQL 2005 reports.
Analytics R2 Accelerator - Sales Manager Dashboard Report
The future R3 version will add cubes, data mining applications, PerformancePoint scorecards and other great analytical tools.
Be sure to download this release and give it a trial run on the April 2009 VPC. Let me know if you like it!
Download Link:
- Analytics Accelerator for Microsoft Dynamics CRM 4.0 [CodePlex.com, 5MB]
- Sample Sales Manager Dashboard Report [PDF]
Excerpt from the Whitepaper:
The Analytics Accelerator for Microsoft Dynamics CRM 4.0 will be delivered in three releases – each release will build on the capabilities of its predecessor. Here is a summary of what each release will include:
Release 1 (December 2008):
• SQL Server 2005 Dashboard reports
• Simple SQL Server 2005 Analysis Services (SSAS) cube
Release 2 (THIS RELEASE):
• SQL Server 2008 Dashboard reports
• Fixes and enhancements to the SQL Server 2005 dashboard reports
Release 3:
• Simple SQL Server 2008 Analysis Services (SSAS) cube
• Sales Pipeline trending analysis example (SQL Server 2005 AND 2008)
• Enhanced SQL Server Analysis Services (SSAS) cube (SQL Server 2005 AND 2008)
• Embedded data mining applications
• Microsoft Office PerformancePoint Server scorecards
• Security synchronization plugin (and source code) to replicate the Microsoft Dynamics CRM security model to the SSAS cubes
Tags: CRM, CRM Accelerators, download, Reporting
MSCRM 4.0 Documentation Generator (Excel Add-in), perfect for the CRM Consultant’s Toolbox
Administrator, Consulting, CRM 4.0, Customizations, Developer, Downloads June 9th, 2009
Once in a blue moon you’ll find the perfect tool for the job, and this is one of them. On Microsoft’s open source CodePlex site is the MSCRM 4.0 Documentation Generator, an Excel 2007 add-in that will automatically generate documentation for the CRM 4.0 entities, fields, picklist values and JavaScripts you’ve developed.
This tool will save countless hours of documentation time, and will keep you focused on the real creative development and customization efforts that directly benefit your clients.
The resources you’ll need to get going:
- Download the MSCRM 4.0 Documentation Generator (link to CodePlex download site).
- Export the Customizations file (either ZIP or XML) from your Microsoft Dynamics CRM 4.0 deployment.
- Microsoft Office Excel 2007
- Microsoft Visual Studio Tools for the Microsoft Office system (version 3.0 Runtime)
- This installation is provided in the setup of this tool, but you can also download it directly at this link.
- This installation is provided in the setup of this tool, but you can also download it directly at this link.
As an alternative tool for generating CRM 4.0 Documentation, be sure to check out the CRM 4.o Form Reporter (direct link to the CodePlex site).
Full instructions from the CodePlex site below.
Installation
The add-in will run on Office 2007 Excel (with Visual Studio Tools for Office (3.0)).
Extract the installation files and run Setup.exe – it will attempt to install any prerequisites.
Once the setup completes, Start Excel.
The first time Excel runs with the add-in, you will be presented with a customization installation message – choose “Install.”
Usage
Open the Add-Ins ribbon, press the load button to load your XML, then press the “Forms” button.
Once you’ve created a “Forms” documentation spreadsheet, open a new blank spreadsheet and click the “Scripts” button, and then repeat with the “Picklists” button.
Many thanks to CustomerEffective’s Scott Sewell (and Merijn van Mourik) for sharing this thing of beauty.
Tags: CRM, Documentation, Excel, Generator, JavaScript, Microsoft Dynamics CRM, Tools
New Microsoft CRM Discussion Groups are ready and able to answer your questions
Administrator, Consulting, CRM 3.0, CRM 4.0, Developer, Links, Microsoft Dynamics, Support June 3rd, 2009
There are new discussion group resources available in your quest for answers regarding Microsoft Dynamics CRM, most notably a CRM Online forum. Engage with the MVP Experts and discover a solution to that one support or development issue that’s been gnawing at your patience all week.
¡Socorro!
The other new international discussion groups will be excellent support resources for our Spanish, Italian, German, Russian and Chinese brethren.
See all Dynamics CRM discussion group links below, and be sure to bookmark the ones you’ll need!
Link to all Dynamics discussion groups, including Dynamics GP:
http://social.microsoft.com/Forums/en-US/category/dynamics/
CRM
Forum for discussions with Microsoft CRM experts, MVPs, and Partners.
CRM Deployment
Forum for discussing Microsoft CRM deployment questions.
CRM Development
Forum for discussing customization, add-ins, and integration with Microsoft CRM.
CRM Online
Forum for discussing Microsoft Dynamics CRM Online specific questions.
CRM Chinese
CRM community space for an international audience, these new forums will be monitored by the CRM MVP team.
CRM Italian
CRM community space for an international audience, these new forums will be monitored by the CRM MVP team.
CRM Spanish
CRM community space for an international audience, these new forums will be monitored by the CRM MVP team.
Microsoft Dynamics AX/NAV/CRM
Microsoft Dynamics AX, NAV and CRM Russian Discussion Group.
Microsoft Dynamics CRM (German)
Mit Microsoft Dynamics CRM optimieren Sie all Ihre kundenorientierten Geschäftsprozesse. Diskutieren Sie mit anderen Anwendern oder stellen Sie ihre Frage rund um die Installation, Anpassung und Entwicklung von Microsoft Dynamics CRM.
Tags: CRM, development, Discussion Group, International, Microsoft Dynamics CRM, Support
About
