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

How to read Column Properties from SSAS tabular DB

I was reading about Column Properties. I want to know how can I using C# read column properties from the SSAS tabular database?
SharpCoder
  • 18,279
  • 43
  • 153
  • 249
0
votes
0 answers

Get column DataType from SSAS tabular DB using ADOMD

How can I get DataType information of each and every column of a SSAS tabular cube? I know how to execute a query and then get the SchemaInformation (which also provides columns DataType). I want to read any given cube, get the list of dimensions &…
SharpCoder
  • 18,279
  • 43
  • 153
  • 249
0
votes
1 answer

DAX: How to count concurrent chats in a time interval

I have a tabular cube containing data from our chat system. I need to make a measure for "Concurrent Chats". I have a start datetime and an end datetime column for each chat session and need to count all those where either startdate or enddate is in…
NicolajB
  • 275
  • 1
  • 6
  • 16
0
votes
2 answers

SSAS Tabular Model on Azure VM

I have an Azure VM with SSAS Tabular Model. I understand that using Virtual Network it can be accessed from On-Premise. But is it possible to access it using DAX queries without creating Virtual Network?
Srinivas
  • 2,479
  • 8
  • 47
  • 69
0
votes
1 answer

Tabular Model Many 2 Many

Can anyone explain to me what exactly is going on behind the scenes with the following two queries? they seem to exhibit the same results, but which is "better" for filtering a measure in tabular model dax across a many-to-many relationship... Here…
m1nkeh
  • 1,337
  • 23
  • 45
0
votes
1 answer

Check is tabular model has loaded latest data

We've a few tabular models on 2012 server. We have queries running to find if the processing of these was successful and that's about it. Most of the times processing is successful but it does not have the latest data. Can I run some MDX XMLA to…
CeeVei
  • 95
  • 2
  • 13
0
votes
1 answer

Sort numeric field used in hierarchy

I have a hierarchy that is Year-Month-Day, and it sorts the day as if it were a text field (i.e, 1,10,11,12,etc). When the same fields are used without the hierarchy the sort is correct. The model is SSAS 2012 tabular, and the field is properly set…
Kevin Dahl
  • 752
  • 5
  • 11
-1
votes
1 answer

Dax function TREATAS with Format Datetime

I am new on DAX language, perfect if you can help I have this code , that's give the error that we can't apply format on Treatas. EVALUATE SUMMARIZE( TREATAS( VALUES(ADDCOLUMNS('Calendar', "FormattedDate", FORMAT([DateCol],…
vlad
  • 49
  • 5
-1
votes
1 answer

SSAS Tabular Model Case Sensitive Dimension

I am using SQL Server as my source. These are my configuration settings: OTLP Server Level Collation setting: SQL_Latin1_General_CP1_CI_AS OTLP Database Level Collation setting: SQL_Latin1_General_CP1_CI_AS SSAS Server Level Collation setting:…
Jason Cheung
  • 13
  • 1
-1
votes
1 answer

TOM ADOMD.NET - What is "Retains dimensionality"?

I try to see the documentation of Microsoft but I can't understand when they said "Retains dimensionality". What does it mean? They describe it in the table of this…
Alberto Gentilcore
  • 21
  • 3
-1
votes
1 answer

Problem with FY PY calculation- incorrect values in 1990 and 2000 years

I'm facing the problem with FY PY calculations. In my model I have a fact table with 2 connected dimensions: Order Date Posting Date In the model already exists the measure which calculate the PY value (I use crossfilter to allow using 2 date…
kittysmile
  • 51
  • 6
-1
votes
1 answer

Calculate the percentage of the groups compared to the total

I have the following schema : I am using a live connection to this SSAS Tabular cube, I want to calculate the % of the Products with Status = Available for each product comparing to the total of Products with Status=Available.
Amira Bedhiafi
  • 8,088
  • 6
  • 24
  • 60
-1
votes
1 answer

Format the measure depending on the filter selection

I have a filter Nombre/Montant in the static_table_filter[filter_name] : If I select Nombre it will get the Montant measure, if I select Montant it will get the Montant measure SwitchFilter = var selected =…
Amira Bedhiafi
  • 8,088
  • 6
  • 24
  • 60
-1
votes
1 answer

Creating relationships in an SSAS Tabular model vs Power BI

I have an SSAS Tabular model composed of a fact table and 3 dimensions. I want to understand what is the difference between creating the relationships in the tabular model in advance comparing to import the tables or using a direct query and then…
Amira Bedhiafi
  • 8,088
  • 6
  • 24
  • 60
-1
votes
1 answer

DAX to average values from another table using associations

Suppose I have these three tables in Power BI (a simplification from my enterprise…
bvy
  • 144
  • 2
  • 12
1 2 3
…
57
58