Kine: What is new in Dynamics NAV 5.0 Business Analytics (BA)Pay attention to permissions when upgrading DB from SQL 2000 to SQL 2005

[Blog bot]

A while a go we released Dynamics NAV 5.0 and with that a new version of Business Analytics Basic and Advanced. I want to spend a few lines of text to share what is new in this release and the reasons for these features making it into the product at this time.


First of all the Advanced client is now up to speed with version 2k5 of the Targit release with everything in that. This gives us support for presenting cubes created in SQL Server Analysis Services 2005.


Of other new things i can add gauges as a way of graphically representing KPIs in a trafficlight way. I also add improved integration with SQL Server Reporting Services.


In BA Basic list of new features looks as follows:
<UL>
Ability to apply filters on fact tables
(Allows customers with large volumes of data to create cubes containing only subsets of data. Filters can be set by the members of any of the dimensions in a cube)
<LI>Create calculations between virtual cubes
(Allows for cross cube calculations to be handled by BA Basic. An example would be having a cube with actual figures and one with budget figures. It would be obvious to create a measure reflecting the Story Today I solved one "mystery" which leads to data loss. But from the beginning... We have upgraded HW and MS SQL to version 2005 on 64bit platform. Everything without problems, because SAN was used, transferring the DB was just Detach/Attach...(read more)

Источник: http://blogs.msdn.com/clausba/archive/2007...o-sql-2005.aspx