Explore SSAS on Experts Exchange

Expert Solutions for Your Tech Problems


SQL Server Analysis Services (SSAS) is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server used as a tool by organi...

Read more
  • 1.0K Content
  • 448 Contributors

Expert Spotlight
SQL Server Consultant

Database Expert with 15+ years experience (SQL, Access, Power BI).

Leading Experts In
Troubleshooting Solution

Basic package 101 - using evalution of data

I am brand new to this. I would like a package to do the following. In the DataFlow task, I would …

SSAS: Automating SQL Server Agent service logon as administrator

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes. We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that with a PowerShell script.
Troubleshooting Solution

SSAS Multidimensional Cubes  OR  Tabular


Hi Experts,

I almost started creating cube using a Multidimensional Cubes

 project, but then I read a

Advice Solution

Speed up SSAS cube processing?


I have an SSAS multidimensional cube that takes over 18 hours to run the update process from a data

Advice Solution

Upgrading to SQL Server Enterprise license - any downtime?


I intend to upgrade our SSAS server license from standard to Enterprise.

Never done it before and

Troubleshooting Solution

SSAS standard edition - how many partitions can I have?


I have an SSAS cube with two measure groups that have two partitions each.

This is with a standard

Troubleshooting Solution

In SSAS using SSMS, how to persist cube partition changes?


I am making changes in an SSAS Multidimensional cube using SSMS.

Specifically I am creating

Troubleshooting Solution

How to edit SQl Server Analysis Services Command in a Job?


I have never done this before.

I've been asked to look at a system agent job to see if there is any

Troubleshooting Solution

SSAS Cube processing - where is the time completed logged?


I have made partition changes to a SSAS cube.

I don't want to watch it to determine how long the

Research Solution

How to prepare to go shopping for SSAS alternatives?


Senior management doesn't want to upgrade to SQL Enterprise licenses for existing 

Standard SSAS

Troubleshooting Solution

SSRS CountDistinct Expression

I have this expression in my ssrs that looks something like this:

Troubleshooting Solution

Visual Studio - import SSAS multidimensional databases?


I want to evaluate/tweak MDX queries.

I know how to get there in SSMS.

How do I import existing SSAS

Troubleshooting Solution

How do I find out how an SSAS Cube  is partitioned?


How do I find out how an SSAS Cube  is partitioned?

Troubleshooting Solution

Setup of SSAS Cube

I am a newbie to SSAS and I am having difficulty setting up the Data Source, I am unable to …
Troubleshooting Solution

Need to understand sample data model of OLAP database

need to to understand the physical structure of an OLAP database. And if I looked into a Oracle …
Troubleshooting Solution

Where's SSDT in SQL 2015?

At wok, I installed SQL Server Developer 2015. I think I clicked to install everything that comes …
Troubleshooting Solution

Management Studio

i installed 2012 version but the management studio is not installed with it? How to i install the …
Troubleshooting Solution

Permission Errors while deploying SSAS Cube in sql server 2008 r2

Hi, I have created SSAS cube from my Data source View which is calling a view from my Database. I am…
Troubleshooting Solution

Generate Data in T-SQL


I have two datasets and both are medical records . Now one contains records with the …

Do more with Experts Exchange.

Get Answers

Join a Group Discussion


Monitor your Site

Explore solutions and more