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
13
votes
3 answers

Dynamic DAX Number Format

I want to dynamically change the number format of a DAX measure, based on a dimension value (or indeed, based on the order of magnitude of the measure value). I understand I can use SWITCH and FORMAT, as demonstrated by Kaspar De Jonge here:…
Olly
  • 7,749
  • 1
  • 19
  • 38
10
votes
7 answers

No QUARTER() in DAX? Really?

While building a Calendar table with PowerQuery for a PowerPivot model in Excel 2013 I use its Date.QuarterOfYear function to get the number of the quarter. Building the same thing in SSAS Tabular requires some workarounds. There's no equivalent…
erop
  • 1,510
  • 1
  • 14
  • 27
6
votes
1 answer

How to Connect to Tabular Cube Server Using Credentials Provided in a ConnectionString?

Microsoft says: https://learn.microsoft.com/en-us/analysis-services/instances/connection-string-properties-analysis-services?view=asallproducts-allversions "When connecting over TCP to SSAS, the client library will impersonate the Windows user using…
Cody
  • 161
  • 7
5
votes
0 answers

Find Number of times a particular character appears in a string using MDX query

In the Microsoft SSAS, I have a dimension column that contains multiple values separated by the special character | in a single row as below. Example value of a row: Image|Video|Audio| Requirement: So, I need to count the number of values present in…
Sathish G
  • 91
  • 3
5
votes
1 answer

IIF() function not working properly while using multiple times in single MDX query

I need to get the aggregated values based on two conditions using single MDX query Am having below data I have created two calculated functions using IIF() function in a below query WITH MEMBER [Measures].[Expression1] AS…
TAMILARASAN R
  • 225
  • 1
  • 6
5
votes
2 answers

Tabular Cube - Excel Filtering Doesn't Function At Node Level

I have the issue described in this post. I have two cubes with the same data backing them, one a Multi-Dimensional cube, the second a Tabular cube. If I connect to the cubes with excel and drag the top level of a hierarchy(in this example "Company"…
David Rogers
  • 2,601
  • 4
  • 39
  • 84
5
votes
4 answers

multi-parent hierarchy propagation in SQL/DAX

Suppose I have a table that describes primary and secondary reporting lines for each member of staff. Let's imagine an organisational structure where the CEO, employee 0, has 2 managers (1 and 2) reporting to him. Manager 2 has 2 staff in her team…
quant
  • 21,507
  • 32
  • 115
  • 211
5
votes
1 answer

Modelling and querying multiple fact tables

Good day! I have a relational data source with 3 fact tables which are related to each other and model patient doctor visits (EncounterEventFact table), assignment of a diagnosis to patient (DiagnosisEventFact table) and collecting lab results for…
YuGagarin
  • 341
  • 7
  • 20
5
votes
2 answers

SSAS Tabular - Multiple Models?

We're starting to build an SSAS tabular model and wondering if most people have one model or multiple. If multiple, do you duplicate tables that are needed by each, or is there a way to share tables between models? I think I know the answer, but…
buck
  • 207
  • 2
  • 9
5
votes
1 answer

Filtering by many-to-many table

I'm havin hard time to understand how to filter out result of multidimensional expression. This is my database schema. And this is my data. Manufacturer ╔════╦═══════════════════╗ ║ Id ║ Name ║ ╠════╬═══════════════════╣ ║ 1 ║ Awesome…
OzrenTkalcecKrznaric
  • 5,535
  • 4
  • 34
  • 57
4
votes
0 answers

Type mismatch error occurs while casting string values to date type in MDX query with some blank rows

I have a string-type dimension in my SSAS cube having the date values along with some blank values and please find the screenshot for your reference. I am trying to convert these values into Date using the CDate function in the MDX query. I have…
TAMILARASAN R
  • 225
  • 1
  • 6
4
votes
1 answer

Clearing a hung SSAS refresh process

On SSAS 2017 Tabular, I have SQL Agent jobs that run some t-sql steps and ssis packages and finish with an SSAS refresh. I have hundreds of these across three servers. (This is a system I have inherited so it was not my design to have two SQL Server…
Simon
  • 41
  • 3
4
votes
2 answers

Dynamic data masking by using a dynamic row filter in SSAS Tabular

I am trying to implement a way to use Dynamic Data Masking on a SSAS Tabular Import. By default this is not supported on SQL Server Analysis Services 2016 (as far as I know). I think I have found a way to implement this anyway using a Dynamic Row…
Menno
  • 12,175
  • 14
  • 56
  • 88
4
votes
1 answer

SSAS Tabular Model - Add column to existing table

I am using VS2019 for SSAS Tabular Model development. Have imported a table from a CSV. The source CSV has undergone a change(new column has been added). When I process my table in VS2019, it gets processed successfully. However I am…
Joseph
  • 530
  • 3
  • 15
  • 37
4
votes
2 answers

how to set thousands separator for a column in ssas tabular model

I have created cube using SSDT Tools 2017,which has below columns Sales Amount Stock Amount 2000 5000 I would like to change above column data type as comma separated as below Sales Amount Stock Amount 2,000 …
saij
  • 57
  • 2
  • 7
1
2 3
…
57 58