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
2
votes
1answer
1k views

SSAS Cube processing randomly fails with 08S01 error

We have a cube which is scheduled to process every morning at 6:00 to run at SSAS 10.50.2500.0. Sometimes it does it ok. More often than not, it fails. When it happens, SQL Server has this entry ...
0
votes
0answers
12 views

Two named instances of SSAS on one server - can't connect

I have one Windows Server with two named instances of both SQL Server and SSAS. I am trying to connect to SSAS instances from Pyramid application (on another server) and none works. The port 2382 is ...
1
vote
2answers
5k views

Can't deploy SSAS Tabular Model in Visual Studio

I am following the SSAS Tabular Model Tutorial by Microsoft using the Adventure Works DW. I've imported the DW in SQL Server Management Studio to my local server. I've connected to the DW from Visual ...
3
votes
1answer
373 views

OLAP linked server fails connection test

I am trying to create a new linked server to an Analysis Services database and I would like to use this linked server to import data into a SQL Server table. example: SELECT * into raw.example FROM ...
1
vote
1answer
605 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 ...
0
votes
1answer
268 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 ...
0
votes
0answers
11 views

How to persist the data created by “Analysis Service Tabular Project”?

The database created by "Analysis Service Tabular Project" (in VisualStudio2019) is automatically deleted from Analysis Service Server when the project is closed in VS-(checked using SSMS). How to ...
2
votes
1answer
499 views

SSAS Cube for tracking changes in parent child relationship over time

I would like to build an SSAS cube which tracks how objects in a graph who's edges represent a "belongs to" relationship change over time (daily). There are two components to the change: which object ...
0
votes
1answer
2k views

How to List all roles and their members (users/groups) of an Azure Analysis Services tabular model/database

I have a tabular model/database in an Azure Analysis Server instance. Model/database has roles and users/groups were added on each role. I can see the list by right click on the role and then go to ...
0
votes
0answers
7 views

SSAS record count for all tables from all cube databases

i need help with record count for all tables from all cube databases on the instance. i have used below code but its only returning the default database table count. DISTINCT [CATALOG_NAME] as [...
5
votes
1answer
6k views

What causes “attribute key cannot be found when processing” errors?

I'm consistently getting variations on this error when I process the cube in my first SSAS project: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: '...
1
vote
1answer
44 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
16 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 ...
0
votes
0answers
9 views

SSAS - Memory and Migrate

I have 2 questions: 1 So , i got enviroment built on Analysis Services 2012 based on SQL Server 2012 structure , and id like to migrate all of it to 2019 both. So, i already Database Engine ...
0
votes
2answers
526 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 ...
1
vote
1answer
32 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
57 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
1answer
64 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. ...
1
vote
1answer
335 views

SSAS and Visual Studio Optimization Wizard does not work

We have setup and logged data on our Production Server, but when we try to run the Optimizations from within Visual Studio it crashes immediately with TITLE: Microsoft Visual Studio ------------------...
0
votes
1answer
27 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. ...
0
votes
0answers
13 views

How to calculate rent from previous month SSAS tabular model?

I am new in SSAS tabular model and I am working on a project where one of the requests is to calculate rent for the previous months. So my input data look like this: Table1. I would like to add a ...
-3
votes
1answer
46 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 ...
2
votes
3answers
1k views

SSAS How to calculate Standard Deviation

I'm trying to calculate a variety of statistical calculation across a range of data such as Standard Deviation and Average. The data comes from many different "Data sources". These are are held in a ...
0
votes
0answers
27 views

MDX - Sum values by keys across tables

I currently have two tables in my database, which can be simplified as follows: GoodsStatus GoodsPrice ID|status ID|price --------- -------- 1 | 2 ...
0
votes
2answers
543 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
32 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
2answers
595 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
62 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 ...
1
vote
2answers
976 views

The 'Database' with 'ID' = 'xxxxxxx' doesn't exist in the collection

I have a SSAS Tabular server with 30 database. I also have a scheduled process to backup all databases daily. When I run the process which is an SSIS package with script task using AMO, I get this ...
0
votes
1answer
54 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 ...
3
votes
1answer
3k views

The following system error occurred: No mapping between account names and security IDs was done

While trying to Process a cube i go this error "Error 133 The following system error occurred: No mapping between account names and security IDs was done. 0 0" i know its some user which ...
3
votes
4answers
4k views

The column 'Date Offset' in table 'Date' has invalid bindings specified

I'm trying to deploy a tabular model to a server using the "Analysis Services Deployment Wizard". When attempting to deploy,I get the below error. The JSON DDL request failed with the following ...
1
vote
1answer
94 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
4
votes
2answers
5k 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, ...
1
vote
0answers
123 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 ...
4
votes
1answer
623 views

Problem when add administrator for Analysis Server ( SQL Server 2008 R2 )

I'm trying to add a user as an administrator in Analysis Server, doing this: 1 - Connect - Analysis Server - Right click on the Instance - Properties - Security - ADD : This number was already there,...
1
vote
1answer
628 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
52 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
223 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 ...
2
votes
2answers
690 views

Clustering SSAS

We are using both SQL Server 2012 and 2014 always on. Here is my issue: we have an application that I have set up to use Availability groups(2014), however the issue I am having is that it uses ...
2
votes
1answer
323 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 ...
2
votes
1answer
418 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 ...
0
votes
1answer
552 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: '...
2
votes
1answer
268 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
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
2answers
202 views

SSAS - Calculation in DSV or in view from data source

This wasn't an easy question to Google, a lot of word overlap. My table has a column with a date. I'd like another column that is a calculation on that date. I can do this with a Named Calculation on ...
0
votes
1answer
89 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] ,[...
0
votes
1answer
46 views

Compare Validate TSQL Data Warehouse to SSAS

How do I compare Data in T-SQL DataWarehouse to SSAS Cube? I would like to conduct this from SSMS (SQL Server Studio Management Studio). Example Select CustomerName from dbo.DimCustomer where ...
22
votes
2answers
38k views

What are Measures and Dimensions in Cubes

I'm very new to Microsoft Sql Server Business Intelligence and Analysis Service(but I'm programming for years with SQL Server).Can any one describe Measures and Dimensions in Cubes in Simple words(If ...
0
votes
1answer
300 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
7