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
1
vote
1 answer

MDX Dynamic dimension filter based on value of other dimension

How can I filter using values from two dimension in MDX? The required result should include records where [Purchase Date].[Date] is before today minus number of years from [Accounting Date].[Year]. So, the result should include YoY records from…
Fenix
  • 2,271
  • 1
  • 16
  • 24
1
vote
0 answers

Checking for many-to-many relationships

I have 2 tables, say Table1 (with primary key Table1_PK) and Table2 (with foreign key Table2_FK referencing the primary key Table1_PK) such that: select count(*) from Table1 t1 is greater than select count(*) from Table2 t2 and select…
MCrassus
  • 149
  • 1
  • 6
1
vote
1 answer

Failed to deploy analysis services tabular project in Visual Studio 2019

I am unable to deploy analysis service tabular model from VS 2019. The error message returned is "1500 is not a valid value for this element.". Also I checked the deployment analysis server in SSMS to find the supported compatibility levels does not…
Marcus
  • 13
  • 3
1
vote
1 answer

SSDT database project as data source for Tabular SSAS project?

Can I use a SSDT database project as a datasource for a Tabular SSAS project? I am using a visual studio solution to build and maintain multiple projects, sql database projects, ssis packages and I want to add an SSAS tabular project as well, but is…
Lee
  • 13
  • 2
1
vote
2 answers

Process SSAS Tabular Models using Python

I want to execute TMSL scripts to process SSAS tabular models (On-Prem) using Python. I have my SSAS HTTP endpoint ready. Any leads?
Ankur
  • 31
  • 6
1
vote
1 answer

SSAS Tabular DMV to get source query for a table

Need to get the source query and connection details for measures used in Tabular Model. Have tried below to get measure names: SELECT * from $system.TMSCHEMA_MEASURES We get TableID and measure calculations from above query executed against…
Joseph
  • 530
  • 3
  • 15
  • 37
1
vote
1 answer

SSMS Tabular Model: create multiple partition via one single xmla script

I need to create a considerable number of partitions using XMLA scripts run through SSMS. Is there a way to combine the creation of multiple partitions into one single script. In below example, I need to execute the first script. When it finishes, I…
Seymour
  • 3,104
  • 2
  • 22
  • 46
1
vote
1 answer

Long running view in ssas-tabular

I have a SQL Server database where we have created some views based on dim and fact tables. I need to build SSAS tabular model based on my tables and views. But one of the view runs for 1.5 hour inside SQL query (SSMS). Now I need to use this same…
nick
  • 323
  • 2
  • 14
1
vote
1 answer

From a Date and Time value, aggregate all records over the following hour

I have an SSAS Tabular data model that consists of a Fact and Dimension table structure. Within this model there is a Date dimension and a Time dimension, that are referenced by each Fact table. I would like to aggregate Fact data from one table…
iamdave
  • 12,023
  • 3
  • 24
  • 53
1
vote
1 answer

Is there a way to convert this MDX syntax to DAX?

I'm changing a legacy multidimensional analysis services to tabular and "Converting" the MDX measures to DAX. (I don't have much knowledge using MDX) I found the script below and i'm not sure what it is doing. ([Origin].[Origin].&[BUDGET…
M Kobayashi
  • 11
  • 1
1
vote
1 answer

Is there a dax Function that support paging in query?

I wrote a DAX query that include some different kind of measure in SSAS Tabular model. Now I have to break my solution in some pages for using in application and sort by my measures. I used TOPNSKIP() function but can not creating table that sorted…
Zahra Shokri
  • 23
  • 4
1
vote
0 answers

How to build a c# code to backup a tabular database with REST API?

I'm looking for a solution or at least some advice on how to build a function app in c# allowing to backup a tabular database hosted on an SSAS Azure Instance using the REST API. Idea is to backup it on an azure storage. I've seen several code for…
Miguel Martin Perez
  • 119
  • 1
  • 10
1
vote
3 answers

C# to pause, turn on ssas server, backup cube.... how to?

I'm building some function apps in C# (via REST API) to make refreshes of tabular cube located on an azure ssas server. So far, no problem. However, I can't find a way to pause/start the ssas server (I saw some doc in powershell but I'd like to stay…
Miguel Martin Perez
  • 119
  • 1
  • 10
1
vote
1 answer

Why do I need an Azure On-Premises Data Gateway for my Azure Analysis Service?

So I have this Azure Analysis Service where the data source of the cube points to an external (on prem) SQL Server database. For some reason it won't connect to it even when I have the proper firewall changes in place. When processing the cube it…
Martijn B
  • 4,065
  • 2
  • 29
  • 41
1
vote
1 answer

Microsoft.AnalysisServices.Tabular.JsonScripter refers to nonexisting version of Json assembly

I'm trying to call Microsoft.AnalysisServices.Tabular.JsonScripter methods within Powershell to automatically generate CreateOrReplace database scripts for SSAS Tabular. However, when I try to execute the following code I receive an error…
gmuehe
  • 51
  • 3
1 2 3
…
57 58