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
-1
votes
1 answer
Dax to find previous day sale based on data availability
I have created one measure in SSAS tabular called "Yesterday Sales by using max(date)-1", with this I am getting blanks if data is not present for max(date)-1. how to get the sales for the next available date.
for Example, my max(date) is 2019-11-25…
-1
votes
1 answer
Does row level security works if null value found in cube model
I have created one sales cube which has country wise sales table and country table and security group table like below.
SALES TABLE:
country sales_amount
India 50000
UK 50000
…
Deepak
- 37
- 4
-1
votes
2 answers
the translation for culture EN reference and object of type X with name X but that object has been deleted
after I try to delete a DAX i get the error:
even after I create a new translation, I can work on it and after a couple of times a get this message again
what can be the cause of that?
thanks
oh i cant post images.. the error is :
Failed To Save…
Matez
- 1
- 1
-1
votes
1 answer
Detail Rows Expressions Do Not Work With DirectQuery
I've migrated SSAS Tabular Model to work in DirectQuery mode.
Everything works fine besides DetailRows expression.
No matters what DAX expression I set for Detail Rows Expression, drillthrough action in Excel fails with the same error: MDX/SQL…
ZENIT
- 500
- 2
- 4
- 16
-1
votes
1 answer
SSAS Tabular - Other options to update tables rather than Process Full...?
We have a fairly large SSAS Tabular cube with many different tables (some which contain measures and dimensions, etc). On occasion we will run into scenarios where I have to optimize the cube partitions (break them into smaller parts) or cube…
MattyKluch
- 11
- 1
- 10
-1
votes
1 answer
How to sort columns in SSAS?
I'm working on a tabular model in SSAS and I'd like columns to appear in a certain order for instance in Excel. The problem is that they are always sorted in alphabetical order.
SSAS:
How I see it in Excel
Thank you.
Vladimir
- 23
- 4
-1
votes
1 answer
I created Analysis services databases by xmla scripts. But I can't show the values in table. e.g. run DAX 'evaluate table_name',there presents nothing
I want to create many Analysis Services Databases, but don't want to create Analysis Services Tabular Projects manually. So I run some xmla scripts. The databases are constructed After running, but I can't show or use the values in the table. when I…
Tobey
- 1
- 2
-1
votes
1 answer
Multi-dimensional to Tabular mapping one column to several
I have the following mapping within an old multi-dimensional cube:
Each one of these 3 INVOICE_FACT columns maps to the same sman_key column within the salesman table. I know within tabular that only one column is permitted to be mapped to another…
Sauron
- 6,399
- 14
- 71
- 136
-2
votes
1 answer
SUM the amount of products with Available status and divide it by the sum of total products with the status Available
I have the following schema :
I am using a live connection to this SSAS Tabular cube, I want to calculate the amount of the Products with Status = Available
for each product comparing to the total amount of Products with Status=Available.
The dax…
Amira Bedhiafi
- 8,088
- 6
- 24
- 60
-2
votes
1 answer
how to revert changes to a specific version in Source Control?
I want to revert my .bim file back to changeset 13900.
If I right click 13900 and hit 'Rollback entire changeset', will I obtain the desired result?
What isn't clear is that 'Rollback entire changeset' can mean 'Rollback 13900 entire changeset'…
Chicago1988
- 970
- 3
- 14
- 35
-2
votes
1 answer
Analysis Service Tabular model
Error while connecting to the work space server in analysis service tabular model
Below the error Image attached...
MeBy2
- 21
- 9
-3
votes
1 answer
Can Python script be used as data source in SSAS Project?
I can select Python script as a new data source in Power BI, but I haven't found similar option to import data for my Analysis Services Tabular Project in Visual Studio. Can anyone give me a hint?
Here's a little bit more detail about my question.…
Alex Reznik
- 61
- 5
-4
votes
1 answer
Create stored procedure in SSAS Tabular model
Is it possible to create a stored procedure in SSAS Tabular Model? I need to invoke a stored procedure from a Fact table in SSAS Tabular model. The results are stored in a temporary table. My client does not want the stored procedure to be stored…
Li C
- 1
- 1