Stack Overflow
Stack Overflow

Questions tagged [ssas-tabular]

The SQL Server Analysis Services (SSAS) tabular model is an in-memory, column store relational data warehouse constructed with tables which can have multiple columns of data. SSAS Tabular is geared for fast querying and high data compression. The Tabular Engine is the same one used in Power BI, Azure Analysis Services, and Excel Power Pivot.

869 questions
2
votes
1 answer

SSAS Tabular in memory compression

I am testing SSAS tabular on my existing data warehouse. I read that compression of data in memory will be fantastic, up to 10 times. The warehouse weights about 600MB, analytical model has about 60 measures (mostly row counts and basic…
Rummy
  • 129
  • 2
  • 8
2
votes
0 answers

How to generate XMLA script of an SSAS tabular model using SQL job?

We are using SQL jobs to deploy SSAS models deployed in UAT server to production server. Two steps we are currently following are: Sync model of UAT to production. Process (full) the production model. Now we want to add another step where we take…
NewDevNinja
  • 21
  • 1
2
votes
1 answer

Is it secure to deploy an SSAS Tabular Model package impersonating a specific user?

I created an Analysis Services Tabular Project in Visual Studio. I tried to set the Impersonation Information to "Current User": Unfortunately, I get the following error: Failed to save modifications to the server. Error returned: 'The datasource,…
EJoshuaS - Stand with Ukraine
  • 11,977
  • 56
  • 49
  • 78
2
votes
1 answer

Is it Possible to export the Analysis Services DB from SSMS into Visual Studio as we can do in Azure Analysis Services

I have created a cube on SSAS in Visual Studio 2017 (SSDT) and deployed on SQL Server Analysis server. I can see the deployed the Analysis Server DB on Prod in SSMS. Over a period of change, I created multiple version of that DB and I can't find the…
Ashish
  • 23
  • 5
2
votes
4 answers

cannot deploy metadata. reason;an error occurred while connecting to server

I have made an Analysis service tabular project . now I wanna deploy the project but it gives the error cannot deploy metadata. reason;an error occurred while connecting to server. I checked the ssdt is installed. I don't know what else I have to…
Zahra
  • 317
  • 4
  • 16
2
votes
1 answer

What is the best approach between AAS Tabular model or SSAS Multidimensional in Azure Data Platform with Azure Synapse

We have on prem SQL Server Analysis Services (SSAS) multidimension with lot of custom complex calculation, lot of measure group, complex model with many more features. We process per day few billion rows and have custom Excel add-in to connect…
Durgadas
  • 21
  • 2
2
votes
1 answer

Migration from SSAS Multidimensional cube to Tabular model

I hope you are doing well. I'm working on a migration from an on premise ssas multidimensionnal cube to an azure analysis services tabular model. Is there a way , a method or a tool to do it quickly and efficiently? It's a large cube and it will…
Lidou123
  • 155
  • 3
  • 15
2
votes
0 answers

SSAS Calculated Members's equivalent in Tabular model

I am looking for a way to implement the same idea as SSAS Multidimensional model calculated members in SSAS Tabular model. In The Internet Sales sample database, let's consider Location dimension and Sales fact table. I am looking for a way to…
Abiete
  • 105
  • 2
  • 10
2
votes
2 answers

Powershell Script to pull DMV results from Tabular Model

Trying to build a PowerShell script to connect to Analysis Services Tabular Model and pull the output of DMV queries(eg : SELECT * FROM $System.DBSchema_Tables) Tried Below, but its fails, it seems there is something wrong with connection string or…
Joseph
  • 530
  • 3
  • 15
  • 37
2
votes
1 answer

AAS tabular model in DirectQuery mode performance benefits

Suppose you have 10 pretty big fact tables (each 50-100 GBs) that should be queried with Power BI. They doesn't fit into Azure Analysis Services RAM (reasonable price). So in order to use tabular model and AAS you have stay with the following…
VB_
  • 45,112
  • 42
  • 145
  • 293
2
votes
1 answer

dax compare customers selected month vs other months

I am trying to take a list of customers that purchased say in Jan 2019 and the from sales data count how many of those Jan customers purchased in Feb, March, etc. Any ideas, I have tried many solutions presented but none of them seem to fit my…
smckechnie
  • 79
  • 7
2
votes
1 answer

Limit duration of DAX queries

I have a few users sometimes executing highly imperformant DAX queries against an OnPrem SSAS Tabular database. Is there are server side setting to limit the duration of queries so that the server cancels long running queries automatically?
gmuehe
  • 51
  • 3
2
votes
0 answers

How to import event log files data in to SQL Table Automatically

Currently, I am importing the event log file data into SQL table manually. But I want to do this process automatically.
Satya
  • 53
  • 1
  • 6
2
votes
1 answer

How to Find SSAS .sln files from tarbular cude that have been deployed to sql server to SSAS in visual studio

I have access to tabular cube that have been deployed to SQL Server Analysis Services (in SQL SERVER), But the parckage is that was deployed from is missing(That is the SSAS) and I am trying to find a way to open the cude in SSAS and add additional…
JonWay
  • 1,585
  • 17
  • 37
2
votes
0 answers

Load DMV with nested rowset column type into an SQL Server table

I would like to load information from the DMV below into an SQL Server table: select * from $System.MDSCHEMA_MEASUREGROUP_DIMENSIONS This DMV returns a column named DIMENSION_PATH which type is nested rowset (see…
MCrassus
  • 149
  • 1
  • 6
1 2 3
…
57 58