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
  • 451 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

SSRS CountDistinct Expression

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

Troubleshooting Solution

SSRS Formula not working correctly. when checking for fields > 0


The SSRS  goal is to sum and count (two separate formulas) that should have the same format and

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 …
Troubleshooting Solution

When to use Dimension Table and when to use Reference Table

In data mart designing, when should a table be a dimension table and when should it be a reference …
Troubleshooting Solution

Does anyone know of any good Access/SQL classes on the web?

I am needing to learn how to use SQL as the backend for some of my Access Databases.   Does anyone …
Troubleshooting Solution

SQL Server High memory usage

Hi experts, In my project environment , many of the clustered SQL Servers physical memory usage …
Troubleshooting Solution

Demographic: Dimension or fact

I have a fairly simple star.  7 dimensions that are easily set up.  Fact table with various dates …
Troubleshooting Solution

Installing SQL Server 2012 using VM server

Im somewhat new to installing SQL Server although I have done it before with success. I have never …
Troubleshooting Solution

SSRS, NULLs, and the Case of the Persistent #error

OK, so I though I got my head out of my ssa...but no.  How to make the #error go away?

Expression …
Troubleshooting Solution

Dynamic Partitioning in Tabular SSAS Model

I have implemented the incremental loading of data through SSIS. I am looking for a step by step …
Troubleshooting Solution

SSIS Package wont add rows when it runs from the Agent

I'm having an issue with a SSIS package i just created.  This package is simply designed to add rows…
Troubleshooting Solution

Microsoft Development questions for SSIS / SSRS / SSAS development

I'm an Oracle developer trying to re-tool to Microsoft, specifically SSIS / SSRS / SSAS, so I have …

Do more with Experts Exchange.

Get Answers

Join a Group Discussion


Monitor your Site

Explore solutions and more