How SQL Server 2005 Analysis Services (SSAS) differ

How SQL Server 2005 Analysis Services (SSAS) differ

Hello John Sena.
Unified Dimensional Model: – This model defines the entities used in the business, the business logic used to implement, metrics and calculations. This model is used by different analytical applications, spreadsheets etc for verification of the reports data. Data Source View: – The UML using the data source view is mapped to a wide array of back end data sources. This provides a comprehensive picture of the business irrespective of the location of data. With the new Data source view designer, a very user friendly interface is provided for navigation and exploring the data. New aggregation functions: – Previous analysis services aggregate functions like SUM, COUNT, DISTINCT etc were not suitable for all business needs. For instance, financial organizations cannot use aggregate functions like SUM or COUNT or finding out the first and the last record. New aggregate functions like FIRST CHILD, LAST CHILD, FIRST NON-EMPTY and LAST NON-EMPTY functions are introduced. Querying tools: – An enhanced query and browsing tool allows drag and drop dimensions and measures to the viewing pane of a cube. MDX queries and data mining extensions (DMX) can also be written. The new tool is easier and automatically alerts for any syntax errors. MDX in SQL Server 2005 Analysis Services brings exciting improvements including query support and expression/calculation language, Explain MDX in SQL server 2005 Analysis services offers CASE and SCOPE statements. CASE returns specific values based upon its comparison of an expression to a set of simple expressions. It can perform conditional tests within multiple comparisons. SCOPE is used to define the current sub-cube. CALCULATE statement is used to populate each cell in the cube with aggregated data.
Synchronization feature is used to copy database from one source server to a destination server. While the synchronization is in progress, users can still browse the cubes. Once the synchronization is complete, the user is redirected to the new Synchronized database.
Hope you will be understand.