Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

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
0 votes
0 answers
5 views

Define custom visibility order for dimensions' attributes on SSAS and PowerBI

I'm using Visual Studio 2019 to design some datamarts on SSAS to them use PowerBI to make data analysis. In both VS and PowerBI, dimensions and their attributes are being listed on alphabetical order. ...
user avatar
  • 1,413
0 votes
1 answer
76 views

No connection to the analysis service

I can not connect to the analysis service at all. I installed three instance examples of SQL Server on my laptop. SQLSERVER2019 Developer Edition SQLSERVER2017 Developer Edition SQLSERVER2008 R2 ...
user avatar
0 votes
0 answers
35 views

Product Version for Analysis Services and Report Server using T SQL

How can I find the product version for both analysis services and report server using Transact-SQL? I'm trying to put together a query that will get me the details of each SQL instance with their ...
user avatar
  • 121
2 votes
1 answer
117 views

How to find last processed time of dimension in SSAS

I have a list of around 100+ dimensions. Is there any way to check the last processing time of each dimension using DMV's in SSAS?. Thanks in advance
user avatar
0 votes
0 answers
61 views

What are the table naming conventions in tabular models?

With SSAS multi-dimensional models we use star schemas and cubes as our data source. With tabular models we use relational databases. Therefore, with tabular models naming our tables Dim_* and Fact_* ...
user avatar
  • 455
0 votes
0 answers
107 views

How to get a encrypt information from a SSAS Database using Power BI?

I have a database encrypted in my SQL Server instance. To be specific,I used the feature 'Always Encrypted' to encrypt two columns from that database. This database has a relation with a database with ...
user avatar
1 vote
1 answer
74 views

How to install SSAS in SQL server 2019

I installed SQL Server 2019 and Analysis Services. Now I need to install SSDT to create Analysis Services projects. I did some research and saw that to create the SSAS projects it is necessary to ...
user avatar
  • 11
0 votes
0 answers
28 views

Queried cube only returns one single value : the total value of the measure

I have a database where not each dimension row is linked to a fact table row. For that issue, and in order for me to deploy the cube, i set the UnknownMember of the dimensions to be Visible and ignore ...
user avatar
0 votes
0 answers
159 views

Cube won't deploy

I was able to deploy a large cube (with 2 dimensions and 1 measure) in Analysis services server but only after setting configuration error options for both dimensions and the measure (through the ...
user avatar
5 votes
2 answers
294 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 ...
user avatar
1 vote
0 answers
78 views

SSAS 2019: Complex stored proc querying OLAP goes slower after upgrade

I've performed an in place upgrade of Windows 2012 to 2019 and SQL Server from 2016 to 2019 on my Dev server. Since the upgrade we have found one process related to financial forecasting has slowed ...
user avatar
0 votes
2 answers
271 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 ...
user avatar
1 vote
2 answers
142 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 ...
user avatar
  • 159
1 vote
1 answer
28 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 ...
user avatar
  • 141
0 votes
1 answer
20 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 ...
user avatar
  • 221
0 votes
1 answer
700 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 ...
user avatar
1 vote
0 answers
8 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....
user avatar
  • 141
1 vote
0 answers
32 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 ...
user avatar
  • 141
0 votes
0 answers
54 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....
user avatar
  • 1
2 votes
0 answers
72 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 ...
user avatar
  • 141
0 votes
1 answer
29 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 ...
user avatar
1 vote
2 answers
525 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 ...
user avatar
0 votes
0 answers
34 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 ...
user avatar
1 vote
1 answer
68 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 ...
user avatar
  • 113
0 votes
1 answer
104 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 ...
user avatar
  • 1
0 votes
2 answers
387 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. ...
user avatar
0 votes
1 answer
43 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. ...
user avatar
-3 votes
1 answer
242 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 ...
user avatar
  • 151
0 votes
1 answer
168 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 ...
user avatar
  • 101
2 votes
1 answer
2k 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 ...
user avatar
  • 37
2 votes
2 answers
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 ...
user avatar
  • 305
1 vote
1 answer
293 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 ...
user avatar
1 vote
2 answers
2k 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 ...
user avatar
0 votes
1 answer
145 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 ...
user avatar
  • 1
1 vote
1 answer
279 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
user avatar
1 vote
0 answers
239 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 ...
user avatar
  • 131
0 votes
1 answer
559 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 ...
user avatar
  • 2,006
2 votes
1 answer
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 ...
user avatar
0 votes
0 answers
74 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 ...
user avatar
  • 37
2 votes
1 answer
557 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 ...
user avatar
  • 540
2 votes
1 answer
685 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 ...
user avatar
  • 540
0 votes
1 answer
956 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: '...
user avatar
0 votes
1 answer
19 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. ...
user avatar
  • 33
2 votes
1 answer
406 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 ...
user avatar
  • 2,069
0 votes
2 answers
1k 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 ...
user avatar
0 votes
1 answer
225 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] ,[...
user avatar
  • 1,294
1 vote
0 answers
378 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 ...
user avatar
0 votes
1 answer
104 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 ...
user avatar
0 votes
1 answer
495 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 ...
user avatar
5 votes
2 answers
11k 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, ...
user avatar

1
2 3 4 5
7