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)

You rated this post out of 5. Change rating

2020-02-03

7,462 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)

You rated this post out of 5. Change rating

2019-12-31

7,657 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

A New Word: Proluctance

By

proluctance – n. the paradoxical urge to avoid doing something you’ve been looking forward...

Know Thy Platform

By

IT and data professionals, I implore you – know thy platform. All of it....

Adding Git LFS Support – #SQLNewBlogger

By

I got this message recently while committing some changes: This post shows my work...

Read the latest Blogs

Forums

Troubleshooting sql issue where multiple sessions are involved

By vsamantha35

Hi All, We have an application that spawns multiple spid's, runs multiple multiple batches...

Best Practice for full backup and transaction log truncation

By anbu678@gmail.com

I am new to SQL Server DB. Could someone please let me know what...

when peers maintain a job rdp'd in they corrupt the job

By stan

Hi, one of my peers prefers to maintain one specific sql agent job after...

Visit the forum

Question of the Day

Filestream on Linux

I want to implement a Filestream table on SQL Server 2022 running on Linux. Can I do this?

See possible answers