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
0
votes
0 answers
Tabular Model SSAS (visual studio)
Hi I am trying to create a Tabular Model in Visual Studio, but I keep getting the following error : "An error occurred while connecting to the server".
I tried with all compatibility levels and I keep getting the same error so I know that's not…
Rachel
- 208
- 1
- 5
- 18
0
votes
1 answer
YTD Average in DAX
Need to calculate YTD Average and LYTD Average in DAX , Our Fiscal year starts from Apr.
So if my current day is 5th of the June 2017 then lytd_AVG would be from Apr to June would be
(MTD Aprn 17) + (MTD May 17) + (MTD June 17)/3
and LYTD_AVG…
Joseph
- 530
- 3
- 15
- 37
0
votes
1 answer
Impossible to process multiple tables with ODBC connection in SSAS Tabular 2017
I'm currently building a cube in SSAS Tabular with compatibility level 1400 (on an Azure workspace server) and here is my problem. I have an ODBC connection to source my cube and I have to use a connection string and a SQL query for each tables I…
Mathieu Ricour
- 368
- 1
- 4
- 25
0
votes
1 answer
ssas tabular compare current vs. previous versions of data
I've searched and found alot of results describing how to compare current and previous time periods in SSAS Tabular, but what I need is a comparison of another nature, namely versions (i.e not related to time )
Say I have two related entities in my…
teflonjon
- 9
- 4
0
votes
1 answer
Live connect to SSAS Tabular from Power BI not working
I have a working SSAS tabular model and I want to connect Power BI with live connection to this model. In the model there is a role (READ) for user DOMAIN\aldo. In Power BI desktop everything works fine. I can create report I can see data. In Power…
ALdo
- 75
- 2
- 13
0
votes
1 answer
How to calculate the number of new customers every year in DAX
I have to calculate the number of new customers for every year.
Here is my table,
and here is the expected result.
The tricky part is that I don't have to only count the difference between two years, I have to know if there are customers who…
Mathieu Ricour
- 368
- 1
- 4
- 25
0
votes
1 answer
Subqueries in DAX
How can I write this query in DAX ?
SELECT TimeID, Code,(SELECT SUM(qty) FROM cteRanked c2 WHERE c2.rownum <= c1.rownum and c2.Code=c1.Code)
FROM cteRanked c1;
Thank you
Andrea Da Como
- 21
- 1
- 4
0
votes
2 answers
Find latest item in the same group with an earier date
I have a Power Pivot model with Project and Date tables linked in a relationship:
Project Step Date
------- ---- ----
A 1 2-Jan-18
A 2 4-Jan-18
B 1 3-Jan-18
B 2 …
TDP
- 1,141
- 1
- 9
- 24
0
votes
2 answers
SUM with calculated filed - DAX query
I am trying to calculate sum from a calculated field
sum(Productions201801.Piece * Item.Factor) (sql code)
This is the DaxQuery for calculate simple the Sum. All table are in directly ralation with the Fact Table (Productions201801)
EVALUATE…
Andrea Da Como
- 21
- 1
- 4
0
votes
0 answers
Tabular Model, edit Data Lake URL within single project
I have a Tabular Model which is a standard solution for multiple customers which consumes tables from Data Lake. Previously we used SQL Server databases as data sources and would edit the connection to read a different customer database prior to…
Jimbo
- 3
- 5
0
votes
1 answer
Is it ok to install a SSAS 2016 instance next to a SQL Server 2014 instance?
Should I expect any problems installing a SQL Server Analysis Services 2016 tabular instance next to a SQL Server 2014 database engine? (e.g. due to an update of some shared components)
I'm mostly worried about any issues related to the running…
Stephan
- 650
- 7
- 16
0
votes
1 answer
DAX - count attributes for which FACT records do not exist
I am looking for a DAX measure that is equal to If i have in SQL:
SELECT COUNT(NoDataValue WHEN -1 THEN 1 ELSE 0 END)
FROM
(
SELECT Employee.EmployeeID, CASE WHEN FACT.EmployeeID IS NULL
THEN -1
…
SQLSeeker
- 77
- 11
0
votes
1 answer
Calculated Attribute - Min and Max Valid Date
We have some data inside a table (Dimension) with historical values.
Like this (Small example)
ProductId is our Primary Key (and then is unique)
Code is our Business Key
Color and Type are our historical values
In Analysis Services (Tabular mode),…
Arnaud Gastelblum
- 312
- 1
- 11
0
votes
1 answer
XMLA operation failed. You are either using an older version of Analysis Services client libraries or SQL Server Management Studio
I have an AMO project that I'm using to automate operations against a ssas tabular 2016 model.
Moving the model into azure analysis services tabular, I get the below error when the library runs:
XMLA operation failed. You are either using an older…
Neil P
- 2,920
- 5
- 33
- 64
0
votes
1 answer
Cannot create multiple relationship to same master table
I am very new to SSAS tabular model and I have a very basic problem which I am facing.
I have a master table "city", wherein I have city_code and city_name column. city_code is the primary key.
I have another table sales, wherein I have two columns…
stack underflow
- 197
- 2
- 5
- 18