Hi guys,
I am facing few problems and I want to share them with all of you. How SQL Server 2005 Analysis Services (SSAS) differ?Also Explain the purpose of synchronization feature provided in Analysis Services 2005.
Thanks in advance.
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.
In SQL Analysis Server 2005 Services, the next generation OLAP and data mining technology maintained backward compatibility on the API level. The model came with the form of UDM(Unified Dimensional Model) It gives the business data an integrated view. The SQL Analysis Server offers interoperability with MS Office 2007. It has improved tools. Provides faster query time and data refresh rates.
The synchronization feature copies data from one source server to a destination server. When the synchronization is in progress, a user can browse cubes. Once the synchronization is complete, the users are redirected to the synchronized database.
