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
  • 447 Contributors

Expert Spotlight
SQL Server Consultant

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

Leading Experts In
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 …

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

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

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

HTTP access to SSAS server over IIS server

I try to make the HTTP connection Http access to SSAS (MS Analysis Services) server over my IIS …
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

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

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

What is the best way to automate the process of refreshing tabular partitions data and how to accomplish it?

I have created 3 partitions to refresh data in the tabular model, one for the full load before the …
Troubleshooting Solution

How do I properly pass 2 parameters to a Powershell Script that has function in it that also has 2 parameters?

I have a powershell script CubeProcess.ps1 which processes a cube but want to pass 2 parameters to …
Troubleshooting Solution

Install SQL Server 2012 issues

I had many issues trying to install SQL Server 2012 on Windows 2012 VM. My first issue was trying to…
Troubleshooting Solution

Upgrading SQL SSAS cluster instance

We have a 2-node Windows 2008 R2 active/active SQL cluster. The SQL database is 2008 R2 but the SSAS…
Troubleshooting Solution

Setup of SSAS Cube Data View

I had this question after viewing Setup of SSAS Cube
Advice Solution

Do I need to learn SSAS?

I been using SSRS and Power BI to create reports for a while now but I've never felt the need …
Troubleshooting Solution

SQL Server - Windows server specs

My network guy is about to set up a Windows/SQL server for me and wants to know what I need. I have …
Troubleshooting Solution

SQL 2000:  Truncate Transaction log

Hi All,

One of our SQL 2000 servers (running on Windows 2003)  is running low on space.  A couple…

Do more with Experts Exchange.

Get Answers

Join a Group Discussion


Monitor your Site

Explore solutions and more