Analysis Services (SSAS)

SQLServerCentral Article

Build an OLAP Cube in SSAS using an ADO.NET Data Provider

  • Article

SQL Server Analysis Services (SSAS) is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data models for business reports and client applications, such as Power BI, Excel, Reporting Services reports, and other data visualization tools. When paired with ADO.NET data providers, you can create cubes from external data […]

5 (1)

You rated this post out of 5. Change rating

2019-04-30

3,575 reads

SQLServerCentral Article

How to Change an Analysis Services Instance to Tabular Mode

  • Article

In this post I will show a procedure to change Analysis Services instance to tabular mode in SQL Server 2016 if you accidentally setup SQL Server Analysis Services to multi-dimensional mode instead of Tabular mode

4.67 (15)

You rated this post out of 5. Change rating

2016-11-28

47,654 reads

Blogs

Truncate Table Pitfalls

By

 Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....

dataMinds Connect 2025 – Slides & Scripts

By

You can find all the session materials for the presentation “Indexing for Dummies” that...

“SQL Server Is Slow” Part 4 of 4

By

Parts 1, 2 and 3 got you to the (SQL) engine room. Now we...

Read the latest Blogs

Forums

visual studio seems to lose "provider" on pkg imports

By stan

hi, just to get this part out of the way, if my intended target...

ERD Tools recommendation

By Coffee_&_SQL

Hey All, I'm looking for a free ERD tool. Does anyone have any recommendations?...

Stairway to Azure SQL Hyperscale – Level 3: RBPEX Caching Layer Internals

By Chandan Shukla

Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...

Visit the forum

Question of the Day

Vector Datatype Dimensions

The new vector datatype in SQL Server 2025 requires a number dimension parameter. What is the maximum number of dimensions supported?

See possible answers