Questions tagged [ssas]

SQL Server Analysis Services, an OLAP server bundled with SQL Server by Microsoft since version 7.0

Filter by
Sorted by
Tagged with
1
vote
2answers
24 views

8000 character limit in OPENQUERY against Analysis Server

I have a query like SELECT column1, column2 FROM OPENQUERY(AnalysisServerName, 'MDX QUERY ...'). It is inside a stored procedure. A MDX query is dynamically built in it and the length of the query ...
0
votes
0answers
18 views

What version of MSOLAP provider am i using?

We've just upgraded a Server from SQL Server 2016 to 2019. We have linked servers connecting to an OLAP cube. When I look under providers for MSOLAP the label of the dialog box shows: Microsoft OLE ...
1
vote
2answers
21 views

Server side tracing for SQL Server Analysis Services

We are looking to continuously run server side trace on Analysis Services and record its output in a table in database in the Database Services. There are tons of articles showing server side trace ...
0
votes
0answers
12 views

Does SSAS log when connections are refused due to hard memory limit or total memory limit is reached?

I have recently set memory limits for SSAS for SSAS 2017 Tabular In-memory. I'd like to know if those limits are being reached. Obviously I took the time to set the limits based on actual usage, not ...
1
vote
1answer
20 views

how to find the error description for the error codes found in the extended events file XEL generated by SSAS Tabular query end event

how can I translate the error codes logged into XEL files to the corresponding description? I'm importing the XEL files to a SQL Table using the sys.fn_xe_file_target_read_file function, but the ...
0
votes
0answers
27 views

SSAS Clustered Instance - no connection could be made because the target machine actively refused it

I have a clustered SSAS Tabular named instance (TAB_PROD) running on SQL Server 2016 SP2/Windows 2012 R2. When the instance is running on Node1 in the cluster I can connect to it using SQL Network ...
0
votes
1answer
7 views

Data Type to use for Exchange Rate in SSAS Multidimensional

So we have a cube setup that does a many-to-many currency conversion. Until this point, the Exchange Rate measure group has used a Currency data type for the exchange rate, but I didn't realize that ...
0
votes
1answer
99 views

SSAS error deploying project: Ensure that 'SQL Browser' service is running

After successfully building my project, I got this error when deploying it: The project could not be deployed to the '\SQLEXPRESS' server because of the following connectivity problems : A connection ...
0
votes
0answers
14 views

SSAS : 2 linked facts, how to get number of items in dimension attribute?

In an SSAS project there is a TRANSFUSION fact, linked to a PATIENT fact. A transfusion has many attributes, and among them there is the patient who received the transfusion. A patient can receive ...
0
votes
0answers
4 views

Get the list of all Weight attribute members

I have, in SSAS, a fact PERSONS which contains the Measures [Number of PERSONS] and [Weight]. The first one has the value 844. In order to achieve some calculus, I would like to get the list of all ...
1
vote
0answers
7 views

Force use of System.Date in SSAS

I would like to know idf it is possible to force System.Date use in an SSAS data source view. For now, I have a view with a field of type Date and in the data source view it is converted to a System....
0
votes
0answers
13 views

Why does my SSAS cube takes eternal time to process?

I have a cube like this : After 10 mn processing it, I killed the visual studio processus. Little dimensions A->I have in average 10 members, which do not change over time. I created dedicated ...
1
vote
0answers
17 views

SSAS : are dimensions with only Id and Name attributes useless?

I wonder if it is worth creating a dimension with only one column (e.g. Name) in addition to its Id Column. This dimension would be referenced by a fact containing a reference to the Id attribute of ...
0
votes
0answers
5 views

ssas : “data type format not supported” with only data source, no data source view

I created a cube in SSAS for my company. This cube encompasses many dimensions and facts, but when I deployed it for the first time I got this error in SSAS : 'data type format not supported'. I ...
0
votes
0answers
37 views

SQL Analysis Services Microsoft ACE OLEDB provider is not displayed

I working on an SQL Analysis Services school project and my given database is an access database .mdb file when I trying to make a new data source for access file I can only see Microsoft.Jet.OLEDB.4....
0
votes
0answers
14 views

SSAS : how to disable grouping in “Age” property of a fact?

In SSAS, I have: the dimension ANESTHESIT, which has the key ID the fact PATIENT, which key is ID and has a field PAT_ANESTHESIST that is used in a relationship between ANESTHESIT and PATIENT(the ...
2
votes
0answers
29 views

startup ask failed for service MSSQLServerOLAPService

I can't install SSAS (SQL Server analysis services) in multidimensional mode : I get an error at the end of the installation : startup ask failed for service MSSQLServerOLAPService. I was able at the ...
0
votes
0answers
96 views

SSAS cube processing failed: File system error: Insufficient system resources exist to complete the requested service

Have a mysterious problem with SSAS, may be related to SSAS itself or to PKWare Smartcrypt TDE that we have installed on the server. PKWare should encrypt the data for all users outside the domain, ...
0
votes
0answers
71 views

Can't attach SSAS/cube database

Due to running out of disk space, I wanted to transfer 1 SSAS database (cube) to another disk that I connected. In MS SQL, I am trying to detach and attach a SSAS database that I have just moved to a ...
0
votes
1answer
25 views

SSAS- Dimension Attribute needs to be sorted

In one of my SSAS- cube one attribute(inset_date) which is Date datatype and format is yyyy-mm-dd, when I checked in excel pivots it is not coming in order. I have changed the order by property from ...
0
votes
0answers
6 views

How To get cube dimension in ssas 2008r2

How To get number of dimensions from each cube in ssas 2008r2 through query?
0
votes
0answers
42 views

An unexpected error occurred in function 'XMTMStorageFileHelper::CreateOrModifyStorageFile' when processing SSAS tabular model

I'm trying to process partitioned table in SSAS tabular model and I got following error multiple times: An unexpected error occurred (file 'xmutiltm.cpp', line 444, function 'XMTMStorageFileHelper::...
1
vote
2answers
334 views

How can I script administrator permissions on a SSAS server?

I am an administrator for a bunch of SSAS Instances. Sometimes I need to install or migrate SSAS instances to different machines or even different AD domains (we have a couple of different AD domains ...
0
votes
0answers
22 views

I am not seeing Management Folder in SSAS but I do see it in SSMS. What am I doing wrong?

So I am trying to turn on extended events for my SSAS multidimensional cube. However, when I am logged into SSAS (with full admin priv) I only see Database & Assembly folders as seen below. I am ...
1
vote
1answer
37 views

Do I still need OLAP cubes after a SQL Server Upgrade

After our DBA got sacked for poor performance, I am now our accidental DBA. I have been pushing to upgrade our SQL Server instance from 2012 to 2017 so I can use the clustered column store indices in ...
0
votes
1answer
67 views

Design Sql Server physical configuration from existing VM

We have 4 virtual machines that we used to test our BI platform (PoC), the final dimensions are: SSIS (16 vcpu), SSAS (8 vCPU), SSRS (4 VCPU) et Data Engine (24 vCPU) What are the recommendations ...
0
votes
2answers
246 views

how to find backup history of SSAS database

Shockingly on Internet, I am unable to find backup history of SSAS database. Is there no way to do it? Also should we take multiple backups of SSAS database? I am not much aware of SSAS database. ...
0
votes
1answer
29 views

Processing Dimension completed but error occurs

I have problem while processing cube in SSAS, everytime I have an error: I tried to process every dimension separately and it looks like something bad was going on after processing 'Date' dimension. ...
-3
votes
1answer
158 views

SSAS database backup [closed]

I tried to backup SSAS databases (2008 R2) by using query in SSMS, but it is overwriting previous day's backup. How to take backup without overwriting previous backup. I need to maintain at least 7 ...
0
votes
1answer
110 views

Restore from .db folder for Analysis Services

There is an objective to recover cube from long time ago retired MSAS instance. Issue I'm currently standing with is that actual .abf backups are now in a cold storage and recovering them would take a ...
1
vote
1answer
1k views

Does anyone deployed a succesful SSAS on docker?

I'm trying to create a docker image that contains MS SQL server, analysis services, and restore a db (bak) and a cube (abf). The Sql server part is the easy stuff, and I imagine that the restore will ...
2
votes
2answers
1k views

Authentication failed when deploy an Analysis Services project

I am getting the following error on Analysis Services project on Visual Studio 2012 and SQL Server 2014: The project could not be deployed to the 'MyServerName\InstanceName' server because of the ...
1
vote
1answer
187 views

ProcessUpdate of the dimension triggers processing of all partitions of all measure groups in the cube

I have Account and Customer dimensions in the cube that are connected to the same measure groups (there are about 15 - 20 measure groups in the cube). When I run XMLA command to process update these ...
0
votes
2answers
1k views

StorageEngineUsed set to TabularMetadata. For databases in this mode, you must use Tabular APIs to administer the database

I am an administrator in SSAS. I have many data warehouse servers. In some servers I have SQL Server and SSAS on the same machine. I successfully backup the SSAS databases and even check if the ...
0
votes
1answer
98 views

How to have MS Analysis server setup of both modes: multi dimension and tabular

Ref: Is there a way to install both tabular and multidimensional modes? The answer was .."You answered your own question. You simply install another instance of SSAS.".. My MS SQL 2014 has a ...
1
vote
1answer
193 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
0answers
211 views

Error while trying to process dimension in SSAS

I am getting the below error when I try to process my dimension in Analysis services from SQL Server Management Studio. Errors in the OLAP storage engine: The attribute key cannot be found when ...
0
votes
1answer
482 views

Why SSAS tries to connect to the default instance?

I've installed SSDT and while tring to browse the cube I get this error Here it tries to connect to port 2383 which is for the default instance, but in my case SSAS is installed for a named server ...
2
votes
1answer
2k 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 ...
0
votes
0answers
64 views

Running Sql Analysis server on different server

i have server running a database on it, and i have another server which i want to run Analysis server on it, so people can connect the analysis server as they wish to create their own reports for some ...
2
votes
1answer
519 views

SSAS Tabular model Date Dimension with Time possible?

I am in the process of building my first SSAS Tabular model and thought everything was going well, until trying to create a measure by DateTime. In my warehouse, I have a DIm_Time dimension, which ...
2
votes
1answer
532 views

SSAS Tabular Model or SQL Relational Database for new Datawarehouse? Is SSAS still a good to learn technology?

I am in the process of creating a data warehouse using SQL Server for my company. I have created a POC with a simple SQL Relational database with a few(about 10) stored Procs for the ETL process. Now ...
0
votes
1answer
776 views

Errors in the OLAP storage engine: A duplicate attribute key has been found when processing

When I try to process my cube and specifically the Employee_DIM, I get the following error : Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: '...
0
votes
1answer
17 views

Can anyone please tell me if these are correct statements about measure group partitioning in ssas?

A partition is based either on a table or view in a data source, or on a table or named query in a data source view. The location where partition data is stored is defined by the data source binding. ...
2
votes
1answer
360 views

How to log SSAS $system.discover_sessions to a SQL Server Database

We are running SQL Server 2014 and SSAS on the same box. Every now and then our SSAS service appears to freeze. When it does I check the msmdsrv.log file and it tells me that spid x is blocking ...
0
votes
2answers
874 views

SSAS Tabular model table load from query with #temp table fails

We have several situations where complex queries are being used for creating/populating tables in our SSAS tabular model. The actual use cases cannot be presented here, due to both proprietary ...
0
votes
1answer
184 views

Facing error while working with Aggregate function in MDX (MultiDimensional-Expresson)

Hi everyone hope you're doing well I'm using Aggregate function to aggregate the value of my measure for two specific years as you can see below : select aggregate ({[DimTime].[Year].&[1396] ,[...
1
vote
0answers
290 views

My Fact table has data weekly but it is not visible in SSAS cube

I have my fact table that has data in weekly basis, so I am mapping with Week dimension to pull records in Piviot table. My ssas cube doesnt show all data that is in fact. Should I add any specific ...
0
votes
1answer
85 views

Do Indexes in the T-SQL Data Warehouse automatically go over and optimize into the SSAS Cube?

Do Indexes in the T-SQL Data Warehouse automatically go over and optimize into the SSAS Cube? I am reading that applying indexes, will transfer into SSAS. I thought SQL and SSAS are totally different ...
0
votes
1answer
418 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 ...

1
2 3 4 5
8