BI for Dynamics
At Cimbax we have years of experience of implementing Business Intelligence in some of the largest companies, and we know that it's not just about a nice front end and a few dashboards. A Data Warehouse, the ability to handle change and a durable architecture are vital components of any sucessful Business Intelligence implementation.
These requirements led us to select timeXtender as the basis for all our BI practice and Dynamics BI offerings. timeXtender is an ETL (Extract, Transform & Load) and cube-building toolset, with a drag and drop interface, that generates native SQL code. It dramatically reduces the time and cost required to deploy any SQL data warehouse.
timeXender has a series of pre built cubes called QuickCubes that can be deployed in one day with a SQL Data Warehouse template.
timeXtender has QuickCubes for AX, NAV & MS CRM
Durable Information Architecture
The advantage of timeXtender with Dynamics AX, CRM or NAV is that it is possible to build a properly-architected Business Intelligence application, based on SQL Server, very quickly with no programming. The ability to produce a working proof of concept on a client’s own data within a few hours often provides the breakthrough that gets a BI project underway. The code produced is standard SQL – so there are no black boxes here.

There are a number of ways to get the most from data in Dynamics. Cimbax nearly always recommend a SQL Server-based staging area, data warehouse and OLAP server to do the job.
timeXtender has adaptors for AX NAV & CRM that understand the data structure and content of these applications. QuickCubes provide OLAP 'out of the box' for AX NAV & CRM. Together, these give the ability to get a proof of concept working with your own data within a few hours.
Front End Flexibilty
By producing an Information Architecture with a SQL Server Data Warehouse and Analysis Services OLAP cubes, the choice of tools to present the data to users is wide. In a Microsoft environment, SharePoint and Excel provide good functionality for analysis and delivery of information in 2007 - and especially 2010 versions.
The Analyzer product from Strategy Companion is popular choice, as is the Targit solution.
Many others exist, and with data being held in the Data Warehouse and OLAP cubes, hybrid solutions with more than one analysis and presentation product are also often used.
Interested?
To arrange a demo, or for a free one-day Proof of Concept on your on data, please contact This e-mail address is being protected from spambots. You need JavaScript enabled to view it
BI for AX
Dynamics AX (3, 4 or 2009)
Quickcubes for AX & Analyzer Package (example screenshots)




QuickCubes are built for:
- Finance
- Debtors
- Creditors
- Sales Orders
- Purchase Orders
- Inventory
- Production
BI for NAV
Dynamics NAV (4, 5 or 2009)
It does not matter which version of NAV you are running, connectors and adapters are available for both SQL Server and C-Side NAV implementations. In either case, QuickCubes powered by timeXtender generates a SQL Server 2005 or 2008 Data Warehouse and full Business intelligence solution with the following cubes out of the box:
- Finance
- Accounts Payable
- Accounts Receivable
- Sales Analytics
- Vendor Analytics
- Inventory Analytics
BI for CRM
Dynamics CRM
QuickCubes for MSCRM4.0 Free Dashboards *
- Activity 4 Sales
- Campaign 3 Marketing
- Case 2 Service
- Lead
- Opportunity
- Opportunity History
All this delivered on your own CRM environment in one day at an unbeatable price
* required purchase of one developer seat of Analyzer from www.strategycompanion.com








