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

Mdx union between different dimensions

I have situation where I have two different dimensions in a model. Dimension A has ColorId, FirstColor and SecondColor. Dimension B has ColorId and Firstcolor. I am trying to get a complete list of colorIds from both dimensions that are distinct.…
Mutai
  • 125
  • 1
  • 1
  • 9
3
votes
3 answers

Processing SSAS tabular model fails in sql agent

I have a new SSAS 2016 tabular model (1200 compatibility level). I am trying to set up a SQL Agent job to process the model daily. However, when the job runs, it is throwing the following error: XmlaException. The { text node at line 7, column…
cmn
  • 93
  • 2
  • 8
3
votes
1 answer

Testing DAX calculation with NBi

I'm doing some research on automated test tool for our SSAS Tabular project. I found NBi and thought it is really cool. I attempted to set it up and successfully ran some basic tests. However, when I attempted to test dax calculation, it says…
NKD
  • 1,039
  • 1
  • 13
  • 24
3
votes
2 answers

Subselect vs Slicer in MDX

If I want my results to be evaluated in the context of any tuple in MDX, but don't want this tuple to be part of the results, I use either of the below two options. 1. SUBSELECT SELECT [Measures].[SomeMeasure] ON 0, [DimName].[HierName].children ON…
SouravA
  • 5,147
  • 2
  • 24
  • 49
2
votes
1 answer

Difference between SSAS and Power BI in Memory usage

I'm working on a business intelligence project for banking transactions. After completing the ETL phase My supervisor asked me to search the difference between the Tabular and the multidimensional models and which one is more adaptable to our needs.…
Ahmed Fridhi
  • 33
  • 3
2
votes
1 answer

Create a partitoin in SSAS tabular using Powershell TOM

Tried to connect to the tabular model and create a partition on an analysis services tabular model. The piece of code mentioned below. [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices.Tabular") #Here, the variables are…
AmilaMGunawardana
  • 1,604
  • 2
  • 13
  • 32
2
votes
1 answer

Poor performance consuming Analysis service Tabular model via Excel

we run MS Analysis service OnPrem and data are consumed via Power BI and via Excel using Tabular model. In some cases, we are experiencing some performance issue. If we compare some “query execution” from PowerBI and from Excel we notice very…
Giovanni Sellitto
  • 21
  • 2
2
votes
1 answer

Automate SSAS Tabular Model creation via script

I have a data catalog where people can browse through the DWH tables. People can select tables and send a request to the IT team. This is in the form of a table which gives all the table names and column names that a person wants to have. In the…
Jimmy Smeijsters
  • 135
  • 8
2
votes
1 answer

How to use multi level hierarchy names in MDX query

I need to use the dimension field under the 2 hierarchies i.e., one hierarchy under another hierarchy in the MDX query. Am having the below hierarchies/data in my cube: I need to use the highlighted [Country] field in the MDX query. Please find the…
TAMILARASAN R
  • 225
  • 1
  • 6
2
votes
1 answer

Group Items in Comma Separated values in Dax

I have following DAX code. I need comma separated holiday list based on Week No . I tired with CONCATENATEX function and it combine all comma separated holiday list in each row instead of week wise. Any one have any idea how we can achieve below…
NP007
  • 659
  • 8
  • 21
2
votes
0 answers

How to find the required credential properties for an AuthenticationKind

I'm using an application to deploy a tabular model to the MS analysis service through an SSIS package by using a tmsl script. This tabular model can have many data sources connected to that. So I'm using a wizard to get the authentication…
Subash Basnayake
  • 133
  • 2
  • 10
2
votes
1 answer

What are the best practices for advanced row-level security in SSAS tabular models?

I am currently building up a new data model in the area of sales. In the old data model, which I want to replace, I had very specific row-level security settings for each user: Sometimes, settings can be done with an "AND" filter: UserXY should…
Ivo
  • 303
  • 2
  • 15
2
votes
0 answers

SSAS Tabular Model "All" member value

I have an SSAS Tabular Model project for which the language is set to "French". Also, the SSAS Server itself has the language set to "French". The user uses a French version of Excel and Windows as well. When the user explores the model and puts a…
Amine Chafai
  • 188
  • 2
  • 10
2
votes
1 answer

Process multiple SSAS cubes at once

I would like to process several cubes within one job - let's use example: cube A, cube B, cube C, all located on same SQL Server, similar cubes for different customers. Is there a way how to do it easily, without too much manual effort? E.g.:…
Juraj C
  • 97
  • 1
  • 12
2
votes
1 answer

AAS Tabular Cube Refresh

I'm new to Azure Analysis Service and i have few question(s) Whenever we do Full refresh/process AAS tabular cube, does that mean at same time Power-BI reports will become blank. Will end user be able to view data in PBI report at the time of full…
user1941025
  • 541
  • 6
  • 21
1 2 3
…
57 58