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 Is A Free & Open Source Database GUI
Best SQL query & editor tool I have ever used. It provides everything I need to manage my database. - ⭐⭐⭐⭐⭐ Mit
Beekeeper Studio is fast, intuitive, and easy to use. Beekeeper supports loads of databases, and works great on Windows, Mac and Linux.
What Users Say About Beekeeper Studio
"Beekeeper Studio completely replaced my old SQL workflow. It's fast, intuitive, and makes database work enjoyable again."
"I've tried many database GUIs, but Beekeeper strikes the perfect balance between features and simplicity. It just works."