SSAS

SQLServerCentral Article

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

4,644 reads

SQLServerCentral Article

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

6,158 reads

External Article

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

How to Calculate Compound Rate in Power BI

By

Recently I had an interesting use case where I had to a compound calculation...

Daily Coping 28 Sep 2022

By

Today’s coping tip is let go of other people’s expectations of you. I think...

SQL Server In Place Upgrades

By

Good morning dear blog reader. Today’s episode is fresh from a great weekend with...

Read the latest Blogs

Forums

Forms Authentication Setup for SSRS in 2019

By mohan.bndri

As I was looking the authentication set up which come as default when we...

SQL inplace upgrade from sqlexpress to standard edition in VM Google cloud

By RK2012

Hello Team, planning to do SQL in place upgrade from sql2016express to sql2016 standard...

SQL Master Data Services 2019 - Website keeps prompting for login

By Pete Bishop

I have two SQL 2019 servers running Master Data Services which are continually prompting...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers