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
1 answer
DAX Calculate the MAX of a SUM measure
I have an SSAS tabular model based on Inventory data. The data contains not only the current (i.e. todays) On Hand values, but also 90 days worth of history. Here is a very small sample of data:
I need to create a DAX measure that will return…
cmn
- 93
- 2
- 8
0
votes
1 answer
DAX - PARALLELPERIOD() to get the previous minute
In DAX, I want to get the value for a previous minute.
I know the PARALLELPERIOD function can do this for the date and year, but does not allow this to be done by minute.
Is there an easy way I can write the below:
[DateTime] = [DateTime] - (…
Neil P
- 2,920
- 5
- 33
- 64
0
votes
0 answers
Grouping and Sub-queries dax
I am bringing detailed data to Tabular cube(Model is denormalized..One table in model having various attributes A,B,C,D and measures).I want to calculate some measures(Sales, Unit Price) by grouping on A.B.C. On top of that i want to calculate few…
Satyabrat Nayak
- 9
- 2
0
votes
1 answer
DAX Custom Financial Periods
I have an SSAS Tabular model that I am attempting to use a DAX expression to calculate Year over Year metrics on. I have a table called fact_transaction and a table called dimdate that are relevant to the calculation I am trying to do. The…
S Grzybowski
- 115
- 1
- 6
0
votes
1 answer
SSAS Tabular View
I am in the process of building my first tabular view and have a question.
The tabular model I have has 3 tables based on 3 views that exist on SQL server. An incident view, a users view and a category view.
On the incident view, I have 2 columns…
jd0963
- 39
- 7
0
votes
0 answers
How to write xmla query to process tabular cube tables sequentially?
We have a tabular cube with quite a few tables in it and we have a sql job that runs multiple times a day to process the tables in the cube. Recently we added a couple of new tables and the sql job that runs continually fails because of an out of…
MattyKluch
- 11
- 1
- 10
0
votes
1 answer
How to efficiently handle MAX(date) in directquery mode?
Context:
Tableau and Power BI Report Server on prem against SQL RDBMS and SSAS Tabular (Sql Server 2016)
Denormalized table of data. Currently about 100m records.
Challenge:
Analyst does calculations which require MAX(datecol)
This doesn't seem…
Chris Harrington
- 1,238
- 2
- 15
- 28
0
votes
0 answers
DAX only count first occurrence
I have the following tables in a SSAS 2016 Tabular model:
fact_ContactScore (inluding foreign key to dim_account and a measure TopContact)
dim_Account (has accountname and parentaccountname)
An account can have multiple records in the…
analyzethat
- 191
- 1
- 16
0
votes
1 answer
Tableau and SSAS Tabular with greyed out dimensions
I am currently working with Tableau and SSAS Tabular. Can somebody please help shed some light on Tableau behaviour:
When selecting a measure from the model some dimensions are greyed out. These dimensions are however connected to the measure source…
Peter Larsen
- 493
- 2
- 9
- 20
0
votes
1 answer
DAX - check for the existance of a column in the query
Is it possible, in a DAX measure, to check if the current query contains a particular column?
For example, I have a column named "Time" - is it possible to detect if a user in a self service environment has included this in their report, from the…
Neil P
- 2,920
- 5
- 33
- 64
0
votes
1 answer
DAX Count Down Over (remaining)
I wanted to calculate the column RestOrder in DAX. Can you guys please help? The TotalOrderDay column was calculated with the Allexcept() formula. I need something like calculate the orders for Statedate remaining or so...or a SQL "rownumber over…
Andy
- 11
0
votes
1 answer
DAX Query - EARLIER() - Compare with previous Quarter
I tried to do a comparison in DAX between multiple Quarter.
In our case we use Power Pivot with a flat table as source. (No star schema)
Here is a small example:
Our source looks like this:
That's what we have now:
Here is our expected result:
I…
Arnaud Gastelblum
- 312
- 1
- 11
0
votes
1 answer
Sum values on date table where one column equals a selected value from another
I have a DimDate table that has a Billable Day Portion field that can be between 0 and 1. For each day that's in the current Bonus Period I want to multiple that Day Portion by 10, and then return the total sum.
To find out what Bonus Period we're…
Nick Heidke
- 2,787
- 2
- 34
- 58
0
votes
1 answer
MarkLogic 9.0 32 bit ODBC driver failed SSAS Cube
Hello i wan't to create an tabular cube with Microsoft SSAS on top of the MarkLogic 9.0 TDE views. Everything is ok including creating 32 bit ODBC driver on the MSSQL 2017 Server.
When i choise "import data" the list of tables / views are empty, if…
Erik hoeven
- 1,442
- 6
- 26
- 41
0
votes
1 answer
Alternative to generate Local Cube for Tabular data model in SSAS
Just a quick question, im new to the Sql Server Analysis Service environment and still experimenting with it. As what im aware of, for multidimensional model, we can use MDX Script to generate a local cube for ad hoc data query through excel pivot…
Syafiq Hisham
- 11
- 4