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

980 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,008 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

Renewed as a Friend of Red Gate

By

I recently received the news that I’ve been renewed as a Friend of Red...

Redgate Software Needs You!

By

I’ve been very blessed to be able to work for Redgate Software. We’ve done...

Extended Events: Database Auditing

By

Extended Events can do things that simply are not possible with Profiler and another...

Read the latest Blogs

Forums

SSMA 8.6 Unable to find functions in extended stored procedures

By stonechain

I have an instance of SQL Server 2017 (Developer) installed with SSMA for Oracle...

Running generic query for table information

By sizal0234

Hi, I want to run the below query to get information about the tables...

Instance level trigger to store login information (who created what)

By Lord Slaagh

Hello SSC, I am looking for a simplified way to track which user created...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers