Languages: DE | ES| IT | NO |UK | SI |

Technical Information

BI4Dynamics Step by Step Data Transformation Process

Staging Database A staging database is a separate storage area created for the purpose of providing continuous access to application data. >>	Data Warehouse A data warehouse is a place where Microsoft Dynamics data are structured, pre-calculated and stored for further analysis. >>	OLAP Cubes In OLAP Cubes, data are categorized and calculated by dimensions to improve query time over relational databases. >>	Analysing BI4Dynamics delivers fast and accurate analysis, allowing anyone to slice, dice and drill data with the click of a mouse. >>

BI4Dynamics NAV Documents and White Papers		BI4Dynamics AX Documents and White Papers
	White Paper: Description of analytical areas with corresponding measures and dimensions.		White Paper: Description of analytical areas with corresponding measures and dimensions.
	Installation Manual: System requirements overview and detailed screen by screen installation instructions.		Installation Manual: System requirements overview and detailed screen by screen installation instructions.
	LS Retail: Description of BI4Dynamics for LSRetail and list of dimensions and measures.		Requirements BI4Dynamics AX: Check system requirements.
	Pebblestone Fashion: Description of BI4Dynamics for Pebblestone Fashion and list of dimensions and measures.
	Requirements BI4Dynamics NAV: Check system requirements.

Frequently Asked Technical Questions

What are the system requirements for BI4Dynamics?

(Minimum) Hardware Requirements

2 GHz CPU

2 GB RAM

Required hard disk space depends on the size of the NAV database (usually the same size as the Microsoft Dynamics NAV database used)

Software Requirements

32 or 64-bit Windows Server 2003, 2008 or 2008R2, Vista, Windows 7

Microsoft SQL Server 2005, 2008 or 2008R2 (Standard/Enterprise/Development version)*.NET Framework 3.5 SP1

Database Engine

Integration Services

Analysis Services

MS Dynamics NAV native database; 2 codeunits export data, NAV application server does automation; Version 3.10 and later are supported.**

* You can install on SQL Server 2000 but this is considered a custom implementation (no wizard, only English version (partner localization) and higher price).

For older versions (2.x) the solution needs to be customized.

Connections and Permissions**

Remote Desktop Connection to the Server where BI4Dynamics will be installed

Windows account with local administrator privileges

SQL/Native DB connection to the Microsoft Dynamics NAV server to get the data (privileges to read data)

user on MS SQL Server with Create, Drop database and linked server permissionsuser on MS SQL Analysis Services with permission to deploy new analytical database

Server has to be connected to the Internet with port 80 opened. This is needed for authorization purposes

Is it hard to install and configure BI4Dynamics?

No. A Wizard is provided that builds up the data warehouse in MS SQL Server and deploys OLAP cubes in MS Analysis Services. Deploying the solution is easy and quick.

Can BI4Dynamics be customized to fit our needs?

BI4Dynamics can easily be customized. Users with basic MS SQL Server knowledge and MS Visual Studio experience can use BI4Dynamics as a platform for more demanding BI projects (meaning you can also bring in data from other database servers).

BI4Dynamics includes an Administration module to help you with management and customization.

Can BI4Dynamics be localized?

BI4Dynamics can be fully localized. BI4Dynamics uses UNICODE character set for data warehouse and metadata model of OLAP cubes. Any language can be used in the data warehouse.

Can we manage user permissions and access to data?

Yes. User permissions and data access can be managed in MS Analysis Services or your BI tool.