Questions tagged [ssas]
SQL Server Analysis Services, an OLAP server bundled with SQL Server by Microsoft since version 7.0
32
questions
5
votes
2
answers
5k
views
Run a PowerShell script on a different server - from inside a SQL Server job
I have a procedure to backup SSAS Databases.
That is working as a charm.
Now my server is filling up with SSAS backups and I would like to delete the backup files that are older than 2 days.
to ...
- 16.2k
1
vote
1
answer
8k
views
routine to backup ssas databases fails with: The XML for Analysis request timed out before it was completed
I have developed my own stored procedure, that through a LINKED SERVER, backups the SSAS databases according to a table value parameter.
the code for the stored procedure is below.
the problem:
it ...
- 16.2k
6
votes
2
answers
8k
views
administrator permissions on a SSAS database
I had a third party company coming over and building ssas databases to produce reports.
They did, but now the DBA wants to have a look but I haven't got permissions, to even see those databases, as ...
- 16.2k
2
votes
1
answer
2k
views
How to verify a SSAS Backup and how to perform Integrity Checks in SSAS?
I have a procedure to backup SSAS Databases that is working successfully.
I also delete the SSAS backup files that are older than 2 days.
What I am looking forward to implement is:
1) How to verify ...
- 16.2k
3
votes
1
answer
1k
views
How to check the health of a SSAS database? And of its backups?
regarding backups of the SSAS databses, based on the following behaviour:
Backup on an empty SSAS database hangs
Is there a way to check whether or not the SSAS backup is healthy?
I would accept ...
- 16.2k
40
votes
2
answers
22k
views
What does a DBA have to know about SSAS?
I've seen a lot of material covering the business aspect of SSAS, but not really much about the important aspects of administration and management.
From the point of view of administering an instance ...
- 2,323
5
votes
1
answer
24k
views
Linked Server from SQL Server to SSAS not working - what is missing?
I have a SQL Server 2012 Standard edition sp1 that has ssas also installed.
From this server I create a linked server to a ssas server called BIREPLON1, but when I try to access it, I get the error ...
- 16.2k
4
votes
1
answer
5k
views
Real Time SQL Server Analysis Services Cube Processing Report
I would like to know if there is a way to generate a report to determine which SQL Server Analysis Services cubes are processing using SQL Server Reporting Services? I would like to be able to run ...
- 61
3
votes
1
answer
2k
views
SSIS - SSAS: Missing data handling
I have a solution in SSDT with a SSIS and a SSAS project, with missing values in both numeric and text columns.
Is it a good practice converting all the missing values of these columns to NULL during ...
- 99
10
votes
2
answers
8k
views
Configure SQL Server Analysis Services (SSAS) to run on same IP as SQL Server instance
TL;DR
I would like to add SQL Server 2014 Analysis Services to a specific instance of SQL Server and to configure it in such a way, that the Analysis Services (SSAS) and future Reporting Services (...
- 17.7k
7
votes
1
answer
8k
views
SSAS - what could be a good starting point for memory settings?
I have received the following alert regarding memory settings of SSAS:
Alert: SSAS 2014: Invalid TotalMemoryLimit Configuration Source:
MSSQLSERVER Path: SASBI01Alert time: 9/15/2015 5:38:50 PM
Alert ...
- 16.2k
6
votes
2
answers
17k
views
SSAS Model Refresh - Not enough memory to complete this operation Error
We have started encountering an issue regarding the refresh of our tabular SSAS model.
The tabular SSAS model has 38 tables within it.
This process has been running without issue for over a year, ...
- 191
6
votes
0
answers
255
views
Using the Schema Generation Wizard to regenerate a previously-generated schema
Lately, I've been trying to clean up a group of projects that my company received from an outside contractor. Among them is an SSAS cube, with an associated data warehouse.
The contractors generated ...
- 171
5
votes
3
answers
10k
views
How can I dynamically back up all SSAS databases on a given instance?
I want to dynamically back up all the databases on a given SSAS instance using a SQL Agent job (which would most likely involve executing an SSIS package). It is imperative that this is a dynamic ...
- 751
4
votes
3
answers
4k
views
Connecting to MySQL database from Analysis Services
I need to know whether it is possible or not to get data from a MySQL database and create a Cube in Analysis Services 2008. If so, tell me how to connect to MySQL Database from Analysis Services.
- 41
4
votes
2
answers
317
views
Regenerating a cube relational schema in Visual Studio
I have an Analysis Services cube project that my company received from an outside contractor, and I'm trying to get it so that developers can work on it on their local machines.
I'm pretty sure that ...
- 171
4
votes
1
answer
8k
views
Security permission to only read SSAS Cube with Excel
I have an SSAS database set up on a SQL Server 2008 server. I have a Role set up with a group of users that I want to be able to access the Cubes in that database. I set up "Read definition" and "...
- 3,048
4
votes
1
answer
3k
views
Script out XMLA for all databases
I have several SSAS databases. I only want to script out the XMLA for them on a nightly basis. This will be a second tier backup in addition to the regular backups we have.
How do I auto-generate ...
- 325
2
votes
1
answer
346
views
Backup on an empty SSAS database hangs
I created an SSIS package to iterate through all databases on an SSAS instance. It grabs the DatabaseId using AMO in a vbscript, then generates the XMLA to backup each database.
Most databases ...
- 751
2
votes
1
answer
4k
views
Tabular mode disabled during SSAS installation
I am trying to install SSAS in Tabular Mode. However, i find that the radio button is disabled. I am installing it on a separate instance as well. The regular Multidimensional SSAS had been installed ...
- 143
2
votes
1
answer
4k
views
Class not registered error in SSAS Data Source View
Has anyone come across Class Not Registered issue while opening Data Source Views in SSAS using Visual Studio 2015? There are similar posts not haven't found anything exactly the same.
Error text:
...
- 41
2
votes
1
answer
551
views
SSAS and SQL Server on the same server
I have a server that is primarily used for SSAS, heavy processing, however I have SQL Server on it alongside SSAS, but I don't want sql server to hold ssas back.
I have set the SQL Server MAX memory ...
- 16.2k
2
votes
1
answer
4k
views
Use Powershell to query SSAS connection string
I want to retrieve the existing connection string from SSAS for each OLAP Cube or Database. The data will be used in a control/audit report.
I've found that Powershell allows me to drill into SSAS ...
- 3,233
2
votes
1
answer
3k
views
Remove Data From Memory when Using SSAS Tabular In-Memory Mode
I use SSAS Tabular in In-Memory mode. I also use partitions to divide my data. So I will have one partition per month.
AFAIK, when using In-Memory mode, server keeps processed data in memory forever....
user71787
2
votes
2
answers
7k
views
How do I tell which Edition and Version my SSAS Instance is running?
In SQL Server on the database engine, you can run a SQL query like this to get the server's version info like Edition and Version, and Update Level, etc.
SELECT @@VERSION
What is the MDX equivalent ...
2
votes
1
answer
679
views
How can I reduce OLEDB wait type in a SSAS linked server connection?
I have recently created a linked server to one of my SSAS servers.
when I go ahead and open the catalogs, to see which ssas databases I have there,
I use the following procedure:
create procedure ...
- 16.2k
2
votes
1
answer
2k
views
Update OLAP Cube data
We are using OLAP in our project and we are facing a scenario where we need to update the cube with real time data on daily basis.
I need some suggestions about an optimal way for updating the data ...
- 175
1
vote
1
answer
527
views
remove Analysis service from a SQL 2014 cluster
Is it possible to uninstall Analysis service from a SQL 2014 cluster. I’ve seen that it cannot be done in 2008/12. I’m hoping that this maybe fixed now
1
vote
1
answer
4k
views
How can I pass the server name as parameter for a XMLA script?
I have a PROCEDURE sp_backupSSAS - it backups SSAS databases.
it works fine.
I had previous problems with it, but they were sorted out here:
routine to backup ssas databases fails with: The XML for ...
- 16.2k
0
votes
1
answer
1k
views
Is there a way to install both tabular and multidimensional modes?
I have started studying for the MCSE BI exam. I would like to have both the multidimensional and tabular modes available for studying/practice purposes. I have a SQL Server 2014 Developer Edition with ...
- 179
0
votes
1
answer
706
views
Performance Metrics: Columnstore Indexes vs SSAS Cubes [closed]
What has faster performance speed: Columnstore Indexes or SSAS Cubes? Are Columnstore indexes proven to be faster than SSAS cubes (SQL Analysis Services)? Have their been any performance studies ...
user175631
-2
votes
1
answer
3k
views
how to delete multiple ssas database using xmla script
how to delete multiple SSAS database using XMLA script
if possible please post me with syntax
