SQL Server Analysis Services(SSAS) delivers online analytical processing(OLAP) with data mining functionality for business intelligence applications.
Analysis Services supports OLAP by letting you design, create, and manage multidimensional structures that contain pre aggregated data from other data sources, such as relational databases.
In data mining feature Analysis Services, it lets you design, create and visualize data mining models that are constructed from other data sources by using a wide variety of industry-standard data mining algorithms.
Analysis Services main features include:
User-Friendly Conventions for names:The user experience, especially for ad hoc queries is one of key feature of SSAS. These conformed dimensions which can used for multiple Fact Tables.
Calculations/Pre-Aggregations:Calculations/pre-Aggregations of facts like proft, sales year to date, and sales same period last year is another key feature of SSAS.
Security: This is another main feature where limited Access through Perspective or restricting users from particular Access.
Query performance: Query performance is the frst reason most people are attracted to OLAP. SSAS offers excellent dimensional query performance.
The steps involved normally for Developing SSAS Cube:
1. Develop your plan.
2. Set up the design and development environment.
3. Create a Data Source View.
4. Create and fne tune your dimensions.
5. Run the Cube Wizard and edit the resulting cube.
6. Create calculations and other decorations.
7. Re-Iterate again and again until you get it right and acceptable.
I will post more information on upcoming posts….