Posted On: Jan 7, 2022
Amazon RDS for SQL Server now supports SQL Server Analysis Services (SSAS) in Multidimensional mode. There is no additional cost to install SSAS directly on your Amazon RDS for SQL Server DB instance.
SSAS is a Microsoft Business Intelligence tool for developing enterprise-level Online Analytical Processing (OLAP) solutions. You can now configure Microsoft SQL Server Analysis Services (SSAS) in Multidimensional mode on Amazon RDS for SQL Server. Amazon RDS supports SSAS in the Single-AZ configuration for SQL Server Standard and Enterprise Editions on the following versions:
- Tabular mode:
- SQL Server 2019, version 15.00.4043.16.v1 and higher
- SQL Server 2017, version 14.00.3223.3.v1 and higher
- SQL Server 2016, version 13.00.5426.0.v1 and higher
- Multidimensional mode:
- SQL Server 2017, version 14.00.3381.3.v1 and higher
- SQL Server 2016, version 13.00.5882.1.v1 and higher
Learn more about how to configure SSAS in RDS from this Blog post, and see the Amazon Relational Database Services User Guide for more information.
Amazon RDS for SQL Server makes it easy to set up, operate, and scale SQL Server deployments in the cloud. See Amazon RDS for SQL Server Pricing for pricing details and regional availability