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 Average at different grain
Ok, highly simplified table of three columns, order#, product#, and quantity...
Order | Product | Qty
1 | A | 10
1 | B | 20
2 | C | 30
I want to calculate an average of quantity, so.. this is at the "default…
m1nkeh
- 1,337
- 23
- 45
0
votes
2 answers
Count function DAX with text field in SSAS tabular model
I am trying to replicate the below dax calculation which worked in Power BI but throwing error in SSAS tabular model.
Account Warranty Count = CALCULATE(COUNT(dds_repairlogs[Repair…
ssg
- 23
- 4
0
votes
1 answer
DAX Refer previous calculated value in calculated column formula - puzzle
Is the following possible in DAX?
The following A,B,C,D,E ,..are maturity Buckets.A is a negative bucket , B is positive bucket
Bucket Amount
A -100
B 90
c -200
D 300
E -10
F 30
H -2
The requirement is to calculate…
Ben
- 11
0
votes
1 answer
Mdx parameters- pull in all data
I have a situation where I have a parameter in ssrs that contains only a single value. When that value gets passed over in the mdx query it allows the results to be filters. The values are directly linked to a dimension in the tabular model. However…
Mutai
- 125
- 1
- 1
- 9
0
votes
0 answers
Dynamic Work shifts in Tabular model
I have a static calendar hierarchy in SSAS Tabular model with minutes, hours, days. This way I can do cool metric grouping by dates like:
2017-01-01 45
2017-01-02 3
2017-01-03 17
I want to be able to do groupings by work shifts which are no more…
skfd
- 2,528
- 1
- 19
- 29
0
votes
1 answer
Replacing a Null field in mdx
I have a situation where i have a null value coming in for a column and that value needs to be replaced with another value.
Current mdx
select
non empty { [measures.[Color count]} on columns
,non empty {…
Mutai
- 125
- 1
- 1
- 9
0
votes
1 answer
Calculate revenue by week - sunday to saturday (last year) on tabular cube/Power BI
I have a report on Power BI where data comes from a tabular cube. The DAX expressions are made in the cube. When drilling down in Power BI and comparing results to the original numbers there is a slight difference. Power BI calculates the week…
Faiz
- 273
- 2
- 7
- 21
0
votes
1 answer
Formatting measures in DAX
I have a situation where I have a simple measure which gets the average of a column in a dimension. The column contains data in seconds. I need to format the measure in a way that show something along the lines of 00:00:00 ( Hour:Minute:Second). The…
Mutai
- 125
- 1
- 1
- 9
0
votes
1 answer
DAX: calculate measure "without" current row
I want to calculate a DAX measure "without" the current row. Here is an example based on AdventureWorksDW2014.
evaluate
summarize(
'FactInternetSales'
, 'DimProduct'[ProductSubcategoryName]
Cell-level measures, these are…
Jonathan Stone
- 70
- 3
- 7
0
votes
0 answers
Pivot shows single record field value that doesn't agree to tabualr data model value (source data) - misaligned?
I have found something I'm a little concerned about. Was trying to get a measure working and had it as a calc column previously so was comparing the 2 different outputs and checking for line by line differences. I picked a good one and…
Stuart Bisset
- 11
- 2
0
votes
1 answer
Getting getdate(), datediff in SSAS (MDX) query
We have a MDX query which looks like this:
WITH Member [Measures].[Z] AS (DATEADD("H",-1,[X].[Y].Member_Caption))
SELECT { [X].[Y].Children } ON Rows,
{ [Measures].[Z] } ON Columns
FROM ABC
It basically returns Datetime (LastRefresh).
My…
Chetan Kulkarni
- 404
- 4
- 15
0
votes
1 answer
SQL Server, Tabular Model
CREATE SECURITY POLICY Security_Policy
ADD FILTER PREDICATE RLS.fn_CanSeeSalary(EmployeeName)
ON dbo.Salary
WITH (STATE = ON);
When I execute the query above I get the following error:
Msg 343, Level 15, State 1, Line 37
Unknown object type…
MeBy2
- 21
- 9
0
votes
0 answers
SQL Server Report Models
I am currently working on a project which uses SQL Server Reporting Services 2012 to create a (large) set of reports.
We would like to enable some business users to create reports from a live Oracle database, however these are staff who have no…
user3644997
- 89
- 1
- 9
0
votes
0 answers
Executing XMLA with AMO PowerShell does not create measures
I wrote a PowerShell script to automate deployment of SSAS Cubes. I use the Deployment Wizard to generate an XMLA file and then PowerShell AMO command to deploy it. However, when I run it the tabular database gets created but all measures are…
northern_poodle
- 75
- 8
0
votes
2 answers
SSAS Tabular data refresh
I am developing SSAS Tabular project for Power BI, as part of requirement I need to automate the below process
1. Every week I have to delete last two weeks of data in SSAS Table
2. Update last two weeks of data.
Thanks in advance
Please advice
Mazhar
- 3
- 2