- MS SQL Server - Analysis Services
- MS SQL Server - Integration Services
- MS SQL Server - Execution Plans
- MS SQL Server - Reporting services
- MS SQL Server - HA Technologies
- MS SQL Server - Services
- MS SQL Server - Monitor Database
- MS SQL Server - Assign Permissions
- MS SQL Server - Create Users
- MS SQL Server - Restoring Databases
- MS SQL Server - Creating Backups
- MS SQL Server - Drop Database
- MS SQL Server - Select Database
- MS SQL Server - Create Database
- MS SQL Server – Login Database
- MS SQL Server – Managment Studio
- MS SQL Server – Architecture
- MS SQL Server – Installation
- MS SQL Server – Editions
- MS SQL Server - Overview
- MS SQL Server - Home
MS SQL Server Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
MS SQL Server - Analysis Services
This service is used to analyze huge amounts of data and apply to business decisions. It is also used to create two or multidimensional business models.
In SQL Server 2000 version, it is called MSAS (Microsoft Analysis Services).
From SQL Server 2005, it is called SSAS (SQL Server Analysis Services).
Modes
There are two modes − Native Mode (SQL Server Mode) and Share Point Mode.
Models
There are two models − Tabular Model (For Team and Personal Analysis) and Multi Dimensions Model (For Corporate Analysis).
The BIDS (Business Intelpgence Studio till 2008 R2) and SSDT (SQL Server Data Tools from 2012) are environments to work with SSAS.
Step 1 − Open either BIDSSSDT based on the version from the Microsoft SQL Server programs group. The following screen will appear.
Step 2 − The above screen shows SSDT has opened. Go to file on the top left corner in the above image and cpck New. Select project and the following screen opens.
Step 3 − Select Analysis Services in the above screen under Business Intelpgence as seen on the top left corner. The following screen pops up.
Step 4 − In the above screen, select any one option from the psted five options based on your requirement to work with Analysis services.
Advertisements