Feature Boost for TARGIT Accelerators for Microsoft Dynamics

March 26, 2014

With the ever-increasing emphasis on quick acquisition-to-operation turnaround for Business Intelligence & Analytics solutions, the seventh generation of TARGIT’s Accelerators for Dynamics have received a feature boost to help increase the speed of both initial implementation and subsequent development cycles. 

In addition, the latest version further expands on the idea that the centralized, operational Business Intelligence in the organization moves towards a self-service mindset, even though it’s actually more rigid in nature.

With the TARGIT Accelerator, the focus of Business Intelligence development moves from a need to know specifics about Data Marts, ETL and cube development to modeling basic data structures from the source database. Accelerator handles the detailed steps in going from operational data to finished BI solution including data extraction, data quality assurance, cube modeling etc. behind the scenes – while still creating an open platform SQL Server-based solution that also allows for further development directly in the back-end; without the use of tools beyond those of the SQL Server platform.

In other words: you don’t need to be a master to get started right away with the best that TARGIT has to offer.

The main starting point of any Accelerator driven implementation is still the out-of-the-box cubes already implemented by thousands of customers. If you already know earlier versions of Accelerator, the new functionality will be an easy transition. If you do not, this is a good place to get started.

In the following video presentations, I focus on the two major features added to Accelerator 7. Enjoy!

Integrating data sources
The new version meets the requirement to integrate data from data sources external to Dynamics. Accelerator allows integration of data from Excel or any SQL Server database to mash up the data with the Dynamics data. Budgets or other performance goals are examples of data for use in measures, while demographics is an example for dimensionality. In the video, I show integration of an Excel item budget in the Dynamics AX sales cube.

Building advanced cubes from scratch
The option to add transactions to or expanding dimension in existing cubes have been Accelerator features for years. With the new version, the ability to build entirely new cubes from scratch based on any number of transaction tables and integrating both existing and user defined dimensions has been added. In the video example, I build a simple yet powerful Retail sales cube based on a Microsoft Dynamics AX 2012 R2 database. Adding calculated, virtual columns for use in measures and dimensions is also included in the demo.

The new TARGIT Accelerators for Microsoft Dynamics AX and NAV are released and available for download. New versions for Microsoft Dynamics CRM and GP will be available mid-April. Accelerators are currently available in SQL Server 2005, 2008(+R2) and 2012 editions, and will of course be available for SQL Server 2014 upon release.