SSAS

Analysis Services : OLEDB Error while processing in SSAS

  • Article

Problem This is one of the errors that I frequently encounter while deploying or processing SSAS OLAP cubes on the client's computers or on a remote server. Recently, one of my team members also faced the same issue and so I thought to write a resolution for the issue. The error is something like this: […]

5 (3)

2020-02-03

1,736 reads

Browsing SSAS Instance over the internet

  • Article

Problem Developing OLAP cubes have always been fascinating to me. Right after completing the development of a data warehouse, my next line of action often becomes setting up Analysis Services for the warehouse. Although, there are multiple client tools readily available in the market to perform some analysis on this SSAS Server, sometimes it is […]

5 (3)

2019-12-31

3,824 reads

How to partition data in Tabular SSAS

  • Article

Partitioning data is a standard SQL Server administration practice. Partitions enable independent administration of different slices of data. When a SQL Server Analysis Services (SSAS) tabular data model is developed and processed, data is read from the source system and loaded into the tabular data model configured in In-Memory processing mode. Every time the model is processed, the entire data set may not require re-processing. Only certain slices of data containing changes may require re-processing which can be achieved by partitioning data into logical slices. In this post, Siddharth Mehta looks at how to partition tables in Tabular SSAS.

2017-06-08

2,832 reads

Blogs

Daily Coping 30 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

ASF 034: Alex Yates interview (part 1)

By

Introduction Alex is a Data Platform MVP who loves DevOps. He’s has been helping...

Blog .NET for Apache Spark UDFs Missing Shared State

By

The Problem When you use a UDF in .NET for Apache Spark, something like...

Read the latest Blogs

Forums

Any way to use ReportServer in HA AND have two separate SSRS servers?

By C-M-A

This is a little awkward to explain, but we have 2 SQL Server instances...

How to improve the performance of insert?delete?update sql statement

By 892717952

as it was said in the title, which we should pay attention to when...

TDE Drama

By Brandie Tarvin

My workplace uses a 3rd party key management system as an encryption provider for...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The Best Query

See possible answers