Explore SSAS on Experts Exchange

Expert Solutions for Your Tech Problems

SSASSSAS

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

Expert Spotlight
SQL Server Consultant

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

Leading Experts In
SSAS
<
Monthly
>
Troubleshooting Solution

Basic package 101 - using evalution of data

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

SSAS: Automating SQL Server Agent service logon as administrator

1
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.
Post
Troubleshooting Solution

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

3

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

Troubleshooting Solution

SSRS CountDistinct Expression

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

Troubleshooting Solution

Setup of SSAS Cube

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

Access to SSAS limited, need elevated permission

1

We have recently installed SQL Server 2019 on a Windows 2019 server. We have also installed SSAS. I

Troubleshooting Solution

Need to understand sample data model of OLAP database

14
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?

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

Management Studio

18
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

20
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

23
Hello,

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

byrodqxo
21
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?

byCRGman
21
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

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

Demographic: Dimension or fact

20
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

byjknj72
16
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

21
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

14
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

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

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more