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

Remove all non-numeric characters from string DAX

Is it possible to remove all non-numeric characters from a String of varying length in DAX in a calculated column? The model is an ssas-tabular model, so I'm unable to use M language to clean the data at query time. Also i want to remove starting 0…
uzr
  • 1,210
  • 1
  • 13
  • 26
2
votes
1 answer

How to connect table with Month and year data with calendar table in Power Bi

I'm trying to connect a table (Payroll table) who has No. of labour hours by Months of a year. For example: 2017 Jan 10000 2017 Feb 12000 I want to connect this table to my calendar table to perform some calculation on fact table data which i have…
jjgg
  • 35
  • 1
  • 6
2
votes
1 answer

Azure Analysis Services reached maximum allowable memory allocation when creating partitions for table

We have an SSAS tabular model that we want to add partitions to. The server is hosted on Azure with 100GB of memory (the highest tier). We manage to create 5 out of 20 partitions, but when we try to create the sixth partition we get the following…
Robin Johansson
  • 81
  • 4
  • 10
2
votes
1 answer

Dax Queries in ssas

What's wrong in the below code DEFINE MEASURE DimDate[MyMeasure] = COUNTROWS(DimDate) EVALUATE DimDate[MyMeasure] I'm getting the following error while running the query: Query (1, 1) The expression specified in the query is not a valid…
MeBy2
  • 21
  • 9
2
votes
1 answer

How to construct SSAS Tabular Model DAX expression for all measures in a query context

I have a large tabular model with hundreds of measures, many of which require time aggregations such as YTD. I am familiar with Russo & Ferrari's DAX Patterns related to time functions however I'm now faced with constructing a YTD measure (for…
Mack Robers
  • 51
  • 2
2
votes
1 answer

MDX: Define dimension sub set and show the total

Since in MDX you can specify the member [all] to add the aggregation between all the members of the dimension, if I want to show the totals of a certain measure I can build a query like SELECT { [MyGroup].[MyDimension].[MyDimension].members, …
SMarello
  • 309
  • 4
  • 11
2
votes
1 answer

SSAS Tabular AMO - how to know when a requested refresh is complete

The partition class in the tabular AMO library has a method for refreshing the partition (RequestRefresh). I can use the AMO library to fire this off, however this method appears to be asynchronous and I cannot find a way of monitoring this request…
Neil P
  • 2,920
  • 5
  • 33
  • 64
2
votes
1 answer

Connecting to the Tabular Instance of an Azure-hosted SQL Server Analysis Services Server

I have set up an Azure Virtual Machine with a SQL Server 2016 Standard Edition image. I have installed an instance of Analysis Services Tabular on the machine and configured endpoints such that I can access it from my local machine. I have deployed…
Alaistair Jones
  • 23
  • 4
2
votes
2 answers

RANKING Function in DAX or MDX

How can i get result in attached image by DAX or MDX.Both can work for me. ( I will use DAX in Tabular Model and Will use MDX on SSRS part). Sample Format I tried below code but it didn't work. WITH SET OrderSet AS Order ( ( …
Can Aslan
  • 53
  • 2
  • 11
2
votes
1 answer

Building SSAS 2016 from Visual Studio CLI

SSAS projects can't be built using MSBuild. However, SSAS projects can reportedly be built using Visual Studio or SSAS Helper (description). Using the Visual Studio GUI (devenv.exe), the build of my SSAS 2016 Tabular project does indeed build…
vstrien
  • 2,547
  • 3
  • 27
  • 47
2
votes
1 answer

The expression specified in the EVALUATE statement is not a valid table expression

I'm working on a Tabular cube in Visual Studio. I have a DAX formula in the cube that works fine: SUMX(FILTER(factFHA, factFHA[EventCd]="D"), [LoanCount]) When I run it in SSMS as: evaluate( SUMX(FILTER(factFHA, factFHA[EventCd]="D"),…
FLICKER
  • 6,439
  • 4
  • 45
  • 75
2
votes
1 answer

SSAS TAbular Role hide some of tables

I have some tables in my SSAS Tabular, but I want to hide some table for certain user. Ex : I have Sales, Bonus, and master tables. For Operation Department user cannot see bonus's table.
Henry
  • 167
  • 1
  • 10
2
votes
0 answers

SSAS Deployment fails on Metadata due to using wrong data Source

When I try to deploy a SSAS Tabular project from my local machine to the integration server I get an error in the metadata. It's a many to many error that I had previously solved, and I know I solved it because the Tabular project can be processed…
Randall
  • 1,441
  • 13
  • 19
2
votes
3 answers

SSAS Tabular Model Error: Object reference not set to an instance of an object. While trying to add tables to the tabular model

I'm trying to create my first SSAS Tabular model. I'm following the steps mentioned in following tutorial: https://msdn.microsoft.com/en-us/library/hh231690.aspx While trying to load the tables to the model, I get the following…
MSBI_Student
  • 21
  • 1
  • 1
  • 5
2
votes
1 answer

Both Tabular and Multidimensional Model in one SQL Server, how is that possible?

I'm so confused right now and I need to clear my mind with your help! My company has SQL Server 2012 SP2 installed with multidimensional analysis service. I have read that you cannot have tabular model and multidimensional model in one SQL…
Ton Deli
  • 31
  • 1
  • 5
1 2 3
…
57 58