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.
Questions tagged [ssas-tabular]
869 questions
2
votes
1 answer
MDX - NON EMPTY function faster?
I was under the assumption that NON EMPTY clause must be avoided whenever possible. So, I was in for a shock when I accidentally found that it actually made the query much faster!
Sample this:
select
[Measures].[Count Of Requests] on…
SouravA
- 5,147
- 2
- 24
- 49
2
votes
1 answer
Cannot connect to ssas server
I'm creating a new 'Analysis Services Tabular Project' in Visual Studio and the first thing VS asks is:
Select an Analusis Services instance to use while authoring tabular model projects.
I fill in the server and try Test Connecection, the error…
Ralf de Kleine
- 11,464
- 5
- 45
- 87
2
votes
1 answer
Efficiently displaying Top N in Excel PivotTable from SSAS Tabular Model
I have a simple tabular model consisting of a fact table with approx. 20 mio. records (sales transactions) and a dimension table with approx 600.000 records (customers).
A typical reporting scenario is to get the top 10 customers over some measure…
Dan
- 10,480
- 23
- 49
1
vote
1 answer
DAX - Making a calculated column that has another table's value, based on several factors
I am having trouble with a calculated column I am trying to develop.
I have two tables:
(I don't know why the tables aren't displaying properly. It looks fine in preview)
Table A:
PK
Calculated column
1
Value wanted in caluculated column row…
Shiverz
- 663
- 1
- 8
- 23
1
vote
1 answer
DAX expression for cumulative returns
I have to find cumulative returns as show in the image. below is the input table
Date
Funds
Returns
45047
100
0.1
45048
100
-0.05
45049
200
0.2
45050
200
0.1
45051
100
-0.05
I need DAX expression for "Cumulative Returns" 804.97…
Arjun
- 1,049
- 6
- 23
- 37
1
vote
1 answer
Error in SSAS Tabular: An M partition uses a data function which results in access to a data source different from those defined in the model
I have a SSAS tabular. I'm trying to create a expression.
The code is the next:
= Sql.Database("ServerName", "mydatabase",[Query="SELECT * FROM DW_D_AC_CERTIF_OPER_DIM"])
But when I try to process the partition it gives me the following error:
An…
Luis
- 11
- 1
1
vote
1 answer
SSAS Tabular - how to aggregate differently at month grain?
In my cube, I have several measures at the day grain that I'd like to sum at the day grain but average (or take latest) at the month grain or year grain.
Example:
We have a Fact table with Date and number of active subscribers in that day (aka PMC).…
Gabe
- 5,113
- 11
- 55
- 88
1
vote
0 answers
How can I edit table properties in tabular model in visual studio?
I want to add new columns in two tables in a tabular model. But I faced three questions in the process.
When I opened the table properties, I found here has filter rows commands. I tried to directly delete filter rows command here, but I clicked…
syc30
- 11
- 1
1
vote
2 answers
Calculate number of sales days in DAX
1/ How to calculate the number of sales days (= number of days at least one sale has been done)?
So far, I created this measure, but I'd like to know if another more optimal solution exists for a large sales table (1b+ records):
Sales[No of Sales…
bjnr
- 3,353
- 1
- 18
- 32
1
vote
2 answers
Concatenate Tabular Analysis Service
Suppose I have a data model with SSAS-Tabular Analysis Service. In this data-model I have multiple tables but for ease suppose I have "Table1", "Table2" and "Table3". Each of these tables have a column named "Source.Name" which indeed indicates each…
BloomShell
- 833
- 1
- 5
- 20
1
vote
1 answer
How can I delete unused measures in cube without breaking pbix?
I have 3 .pbix files that consume live from a SSAS cube.
The .bim cube has thousands of measures (most of them not used at all).
My goal is to delete the unused measures in the .bim (without breaking any visual in the .pbix).
Is there a way of…
Chicago1988
- 970
- 3
- 14
- 35
1
vote
1 answer
how to change int to date in dax?
I am consuming LIVE from an SSAS cube.
I have my Fact table with the below column:
When I display it in a matrix visual, in my pbix I get this:
But in SSAS I see it as:
How can I display it in a nice dd-MMMM-yyyy format?
Ps: the table comes from…
Chicago1988
- 970
- 3
- 14
- 35
1
vote
1 answer
DAX. Conditional Measure
I'm trying to create a measure that returns a Sum or an Average, depeding on the value of a column. I understand that you need to give a row context to the expression, but I don't like the idea of doing and averege on an id column This is my…
Jack Casas
- 914
- 18
- 37
1
vote
1 answer
Why RLS only works on tabular not within Power bi?
I have a tabular cube (built in VS) where I have RLS, it works fine. I use the cube, for 2 reports... One is for everyone where I just show personal data and the other one is for Leadership.
(I do the trick by having an 'access table' where I set it…
Chicago1988
- 970
- 3
- 14
- 35
1
vote
1 answer
SSAS Cube Sync Takes Too Much Time
When I try to sync in SSAS between two servers in same version. It stucks in "Backup Metadata Traversal Finished". Sync doesn't start. It takes 1.5 hours.
When I delete the cube in server and sync again, it takes 5 minutes. I checked the locks, sync…
Tracedy
- 11
- 1