SQL Server 2005 Analysis Services (SSAS) projects are developed and deployed using the SQL Server Business Intelligence Development Studio that is installed as part of the SQL Server installation. SQL Server Management Studio, on the other hand can be used to manage the Analysis Services databases instantiated from these projects.
In this tutorial from Microsoft, you will learn how to build a SQL Server 2005 Analysis Services cube using the SQL Server Business Intelligence Development Studio. You will build the sample cube and deploy it on an instance of Analysis Services.
During the course of the tutorial, you will learn how to define data sources, data source views, cubes, dimensions, hierarchies and attributes. You will also learn how to view cube and dimension data by processing the deployed objects and populating them with data from the underlying data source.
Lesson 1: Defining a Data Source View within an Analysis Services project
Lesson 2: Defining and Deploying a Cube
Lesson 3: Modifying Measures, Attributes and Hierarchies
Lesson 4: Defining Advanced Attribute and Dimension Properties
Lesson 5: Defining Relationships Between Dimensions and Measure Groups
Lesson 6: Defining Calculations
Lesson 7: Defining Key Performance Indicators (KPIs)
Lesson 8: Defining Actions
Lesson 9: Defining Perspectives and Translations
Lesson 10: Defining Administrative Roles
Beekeeper Studio Es Una GUI de Base de Datos Gratuita y de Código Abierto
La mejor herramienta de consultas y editor SQL que he usado. Proporciona todo lo que necesito para gestionar mi base de datos. - ⭐⭐⭐⭐⭐ Mit
Beekeeper Studio es rápido, intuitivo y fácil de usar. Beekeeper soporta muchas bases de datos y funciona muy bien en Windows, Mac y Linux.
Lo Que Dicen Los Usuarios Sobre Beekeeper Studio
"Beekeeper Studio reemplazó por completo mi antiguo flujo de trabajo con SQL. Es rápido, intuitivo y hace que trabajar con bases de datos sea agradable de nuevo."
"He probado muchas GUIs de bases de datos, pero Beekeeper logra el equilibrio perfecto entre características y simplicidad. Simplemente funciona."