Questions tagged [ssas]
SQL Server Analysis Services, an OLAP server bundled with SQL Server by Microsoft since version 7.0
352 questions
0 votes
0 answers
155 views
Unable to connect to SQL Server 2022 Analysis Services
I successfully installed SQL 2022 and can connect to it from SSMS. I then installed SSAS in the instance but I am unable to connect to it from SSMS. Port 2383 and 2382 are both open. I get the ...
- 447
1 vote
1 answer
44 views
Schema comparison tools for SSAS
Visual Studio with the SSDT add-in has schema comparison tools for relational databases that allow you to compare a repository to a target database and generate a .dacpac for deployment. Is there ...
- 43
0 votes
0 answers
51 views
SSAS Processing Sanity check: Am I using partitions effectively?
I have been rebuilding a DataWarehouse and lately I have been focusing on decreasing processing times. This is using MS SQL Server 2022. I have been implementing partitions on some of the larger ...
- 1
0 votes
0 answers
28 views
SSAS Multidimensional Model: Questions on Key Attributes
I have several dimensions whose key attributes (i.e. attributes whose Usage property = "Key") takes a really long time to process (because the dimensions are really big; some of them are ...
0 votes
0 answers
50 views
MS SSAS named instance doesn't work after NTLM deny
Named instance MS SSAS don't accept connections after NTLM incoming/outgoing traffic deny. There is SPN for this server like: FQDN SPN: Setspn -s MSOLAPSvc.3/AW-SRV01.AdventureWorks.com:AW-FINANCE ...
0 votes
1 answer
102 views
Does Analysis Services provide connection pooling
We know that when creating a SQL connection, for example: using (SqlConnection sqlConn = new SqlConnection(conString)); we are actually not always creating a new connection to the server, but rather ...
- 133
3 votes
1 answer
251 views
Is Analysis Services DMV query executing "on server" or "on database"
I am doing some DMV queries on SQL Server Analysis Service, like SELECT * FROM $system.DISCOVER_SESSIONS. This query will return data for all databases on the server, so it's not really database-...
- 133
0 votes
0 answers
67 views
ssas alias doesn't work
We registered a cname to be able to use SSAS with an alias. It works on client computer but not directly from the server. How to correct this ? We don't use default ssas port
- 1
1 vote
1 answer
69 views
SSAS Configuration Question
With SSIS and SSRS (and Power BI Report Server), you can install the service on one machine and the catalog database (SSISDB or ReportServer) on a different machine or clustered AOAG instance. Is the ...
- 43
0 votes
0 answers
207 views
Performance issue in SQL Server Analysis Services Multidimensional Data Model
We have a star multidimensional model in SSAS in SQL Server 2019 with 4 fact tables and about 600 million records on each fact and many dimension tables with about 1.5 million records and there is no ...
- 147
0 votes
1 answer
221 views
Installing SSIS, SSAS and SSRS on a separate Server
Please is there any benefit from installing SSIS, SSAS and SSRS on a separate server from the SQL Engine instance? Apart from additional license implications, are there any other considerations for ...
- 447
1 vote
0 answers
32 views
DrillDownLevel causing rows to be duplicates
I have defined a cube with a hieararchy of Dates such: Year is a top level then there's Month level. I have deployed the cube using SSAS VS 2022 and SQL Server 2019. But when I query it using the ...
- 111
0 votes
1 answer
353 views
SSAS Backup to Remote Location [duplicate]
I followed the steps in the best answer on this question - How can I dynamically back up all SSAS databases on a given instance? - and can successfully create backups of our BI Cubes to a local drive ...
- 101
0 votes
0 answers
137 views
OLAP Service stopping out of the blue and Not starting immediately when rebooted
So I have analysis server installed and the services just get down for some reason also when the server is rebooted. I installed a script binding it to the SSAS service to automatically start when ...
1 vote
1 answer
2k views
How to release SSAS memory without forcing restart
We have a production server with two SSAS instances, 1 for user querying and 1 with empty templates where we do new releases and (full) processing of the cubes (and then backup and restore processed ...
- 11