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]()
SSAS
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).
Troubleshooting Solution
Article
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.
Post
Do you work with and analyze data? Enroll in October’s …
Do you work with and analyze data? Enroll in October’s Course of the Month…
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
Hello,
I have two datasets and both are medical records . Now one contains records with the …
I have two datasets and both are medical records . Now one contains records with the …
Explore solutions and more
![SSAS]()
SSASBack to the top
SQL Server Analysis Services (SSAS) is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. Analysis Services includes a group of OLAP and data mining capabilities and comes in two flavors - Multidimensional and Tabular.