Problem: What is SQL Server Analysis
Services.?
Solution:
In SQL Server, Analysis Services is a Business Intelligence
Tool used for developing Online Analytical processing cubes.
You may to have check before whether Analysis Services has been
installed on the machine where you are planning to develop a cube. To check
that we can see from the SQL Server configuration tools for analysis services
like below screenshot.
You can connect to the analysis services from SQL Server
management studio using analysis services catalog.
Just like SQL Server database engine that has databases, here
also we have databases that are actually data cubes which have facts and
dimensions under the hood.
0 comments:
Post a Comment