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

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

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

Advice Solution

Speed up SSAS cube processing?

1

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

Troubleshooting Solution

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

4

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

Specifically I am creating

Troubleshooting Solution

SSAS standard edition - how many partitions can I have?

3


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

This is with a standard

Advice Solution

Upgrading to SQL Server Enterprise license - any downtime?

4

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


Never done it before and

Research Solution

How to prepare to go shopping for SSAS alternatives?

3

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

Standard SSAS

Troubleshooting Solution

SSAS Cube processing - where is the time completed logged?

1

I have made partition changes to a SSAS cube.

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

Troubleshooting Solution

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

2

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



Troubleshooting Solution

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

1

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

Visual Studio - import SSAS multidimensional databases?

5

I want to evaluate/tweak MDX queries.

I know how to get there in SSMS.

How do I import existing SSAS

Troubleshooting Solution

SSAS Multidimensional Cubes  OR  Tabular

1

Hi Experts,

I almost started creating cube using a Multidimensional Cubes

 project, but then I read a

Troubleshooting Solution

DW house - how to  hire developer

1
Hi, Planning hire very good DW house developer, what are the best question need to ask? any tricky …
Advice Solution

Do I need to learn SSAS?

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

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

8
I have created 3 partitions to refresh data in the tabular model, one for the full load before the …
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

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

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

Trying to use Powershell to process a cube using the XMLA as a parameter, getting The '<' operator is reserved for future use.

6
I'm trying to execute a powershell script inside a stored procedure that calls a function that …
Troubleshooting Solution

Translate SQL query into sql MDX query

2
I have been tasked with recreating the following query in Analysis Sercvices.
The following database …
Advice Solution

Turnaround Time Calculation by Month

byTaras
2

I do not have a lot experience with calculating TAT – turnaround time. So I am asking for some help

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more