Stack Overflow
Stack Overflow

Questions tagged [ssas-tabular]

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.

869 questions
0
votes
1 answer

How to create a SQL Data Warehouse in SSAS tabular model with denormalized tables?

We have 4 to 5 denormalized tables generated from SAP. How can we create a tabular data warehouse with denormalized tables? What is the recommended warehousing technology? All tables are pushed into SQL by SSIS by processing flat files from SAP RFC…
Deva
  • 1
0
votes
1 answer

How to get SSAS tabular model attributes and dimensions usage details

I need to create a cube which purpose would be to gather detailed information about tabular model dimensions and attributes usage by users (e.g. how many times users access certain dimension). So far, I tried to use Data Management View Query…
nefima
  • 1
  • 2
0
votes
1 answer

DAX Rank by Date

I am Counting on Distinct ID's in a column - this is leading to the sum of the subtotals not equalling the grand total as follows: What I want to do is rank the Payment Dates in cronological order and select ONLY the highest date to display. In the…
mal-wan
  • 4,391
  • 4
  • 26
  • 37
0
votes
0 answers

Getting a time out of datetime and use for comparison SSAS

I have the following issue: I have Orders table that have [Submit Time] Datetime column. I need to prepare a tabular model where one dimension will be just TimesOfDay (like 01:30:00, 21:00:00 etc.) so I can filter out orders on the basis of the…
JS_Diver
  • 756
  • 7
  • 19
0
votes
1 answer

DAX : color data, based on value

I am looking for a way to color my data value using coding. Say for -ve value red color and +ve value green color. Is there any formatting dax function or any other way so that visually it would be easy for end user of pivot table. Note I would not…
Ashish
  • 9
  • 4
0
votes
1 answer

Dynamic DAX Security Filter Using Lookup Table with Multiple Values

I am applying dynamic security to a SQL Server Tabular model in an education environment. I have a security table with userid's and the associated school that the user should have access to. My DAX filter works fine if a user has one school, but I…
Alex
  • 11
  • 5
0
votes
1 answer

Set up a Datasource for Tabular Models in SQL Server

I want to go through this tutorial. Unfortunately the author has already set up the datasources and does not explain how to set them up. First off I installed an separate SSAS Instance in my sql server 2014. Then I tried to add a .mdf file via…
ruedi
  • 5,365
  • 15
  • 52
  • 88
0
votes
1 answer

SSAS Tabular Time Intelligence

I am trying to create dynamic Time Intelligence in SSAS Tabular similar to traditional OLAP Time Intel. Additionally, I need Time Intelligence that can handle two sets of date hierarchies. For example, a Transmission Date and an Activity Date. For…
Pablo Boswell
  • 805
  • 3
  • 13
  • 30
0
votes
1 answer

Previous Year YTD till Same Date

I have requirement, Previous Year YTD till the same date as YTD is returing results for example if the Records in my table is present from 1-jan-2016 to 9-May-2016 then this year YTD will Calculate till 9-May-2016 (this is Working fine ) and…
BIDeveloper
  • 767
  • 3
  • 14
  • 28
0
votes
0 answers

Filter out dimension by numeric value

I have SSAS Tabular cube with a table that has a decimal price field. That cube is used as datasource for building SSRS reports. In one of those reports I need to make some calculations only over the facts in which price is higher than value given…
erop
  • 1,510
  • 1
  • 14
  • 27
0
votes
1 answer

Working Days in DAX

I have a requirement where I need to find the working days of a store. The formula to find the working days of a store is:- If Store is opened on or before first day of respective month then Working Day = Total Days in a month. If Showroom is…
BIDeveloper
  • 767
  • 3
  • 14
  • 28
0
votes
1 answer

Using DAX, how do I calculate a table when filtering on a related table?

I'm trying to find the intersect of two result sets using DAX, but I'm really struggling to get the two result sets calculated. I have a fact table, FactCheckForUpdates, that has a relationship to a date table called 'Log Date'. FactCheckForUpdates…
Jonathan Harding
  • 3
  • 2
0
votes
0 answers

how to do a ranking of moving average in DAX

Assume there's a table T1 with columns [state],[product],[price],[store],[date], and a time table T2. There's a relationship between T2's [pk_date] column and T1's [date] columnit. and I create a measure [5days moving average price]: calculate ( …
user3330433
  • 1
  • 1
0
votes
1 answer

How to create new SSDT Analysis Services Tabular Project from deployment files?

I have three deployment SSAS Tabular model files: Model.asdatabase Model.deploymentoptions Model.deploymenttargets and I want to open this model in a new Tabular project in SSDT. Is there a way to somehow import these files into a SSDT project?
Andrey Morozov
  • 7,839
  • 5
  • 53
  • 75
0
votes
2 answers

Adding the values in dax based on a string in another Column

I want to write a Query which would give the Sum of the value where the string contains 'SP11' without any break For Example in the below table I want to add the value of the 3rd, 6th and 7th rows String |…
Shashank Raj Chavan
  • 89
  • 1
  • 11
1 2 3
…
57 58