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
4
votes
0 answers

Add azure ad group to tabular model in visual studio

I try to add a azure ad group to a Role to a tabular model in Visual Studio. I have tried both to add the group through the visual studio (find user in the role editor) and change the code itself. But I get the same error when I try to open the…
Tysklind-MSFT
  • 87
  • 6
4
votes
1 answer

Analysis Services Tabular disk space

We have some Analysis Services tabular (1600) cubes and I know that normally, the data is all stored in memory, but what I can't find the answer to, is what happens to all this data when the server is re-started ? It would appear that there are a…
Dave Evans
  • 41
  • 3
4
votes
5 answers

Error processing tabular model - From SQL Server Agent

We have a tabular cube, processing database (full) in SSMS works fine, but when processing from SQL server agent, throws following error.  
user5863509
  • 255
  • 1
  • 4
  • 16
4
votes
3 answers

SSAS Tabular How to Change the connection of a table

I created a Tabular model using VS 2013 (because later versions don't support BIDS helper (which we use for creating a folder structure organizing all measures and dimensions within the model)). After working on it for a while I noticed that I was…
Eli
  • 2,538
  • 1
  • 25
  • 36
4
votes
1 answer

a function calculate has been used in a true/false expression that is used as a table filter expression which is not allowed

I have a to check the current month and current year value for a measure in ssas tabular model but due to type mismatch i am not able to do this. For this, i have created a measure in which i am using this dax query…
Deepanshu
  • 69
  • 1
  • 1
  • 4
4
votes
2 answers

Optimizing Dax & model for "where date between" type queries

I am building a model to allow reporting on two seperate datasets, for this example we'l say a Students dataset & a Staff dataset. The datasets are pretty seperate and the only real link between the two is Date, so from a model perspective, there is…
JD_Sudz
  • 194
  • 1
  • 12
4
votes
5 answers

SSAS tabular model slow

Hi i'm working on a large SSAS tabular model and it's so slow every time i change even the smallest thing it goes away and thinks about it for ages. The model is massive and pretty sure that's the problem but I've inherited it like that so at the…
Jim
  • 569
  • 6
  • 15
3
votes
0 answers

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

I need to get calculated measure values based on conditions. Am having the below data in my cube I have created below calculated measure using IIF() function IF([Title] = "Sales Representative",[Reseller Order Count],0) I have tried with below…
TAMILARASAN R
  • 225
  • 1
  • 6
3
votes
1 answer

Data source contains an ImpersonationMode that is not supported for processing operations

hi i am trying to connect the the data base using visual studo analysis service. When i process the table i am getting this error: "SSAS Tabular Project - Failed to save modifications to the server. Error returned: 'Data source contains an…
Cyrine Bouzaidi
  • 31
  • 3
3
votes
0 answers

Automating On-Premise Tabular Model refresh with Azure DataLake Gen1 Connection

We are using Azure Data Lake Gen1 as source in our Tabular model. We have deployed this model on on-prem server. Now, every time we have to manually refresh the credentials to process the model. We want to automate that. I have already tried…
chetan S
  • 31
  • 1
3
votes
1 answer

In DAX, how do I RETURN the sum of a calculated column from a DAX Table Variable (created via ADDCOLUMN)?

I have a multi-step process that stages table variables summarizing base tables to matching grains. The Process (in a nutshell): removes the selected date filter creates a filter using calculated values the new filtered tables then get summarized…
Chris Adragna
  • 625
  • 8
  • 18
3
votes
2 answers

Is there a way to check Which Queries are run by a User in SSAS Tabular?

I am using a BI Model that is a based on SSAS Tabular, using SQL server 2016. Multiple team members are querying it for their needs. I want to find out what Queries are being run and who is running those queries. Couldn't find DMVs very helpful in…
Njk
  • 41
  • 1
  • 6
3
votes
1 answer

Are tabular and multidimensional models built the same way?

I'm having a real hard time understanding what the difference is between a tabular vs multidimensional model. Don't both use dimensions and fact tables? Can't both have a star or snowflake schema? Don't both have measures and calculated…
JJ.
  • 9,580
  • 37
  • 116
  • 189
3
votes
0 answers

Integrating data into existing SSAS tabular model

I have a tabular model setup in SSAS (star schema). The existing data is all from one system and i have setup a summary table based on the fact tables, i.e Total Sales, Sales MTD, Sales YTD, etc. I now have to integrate another dataset from an…
thampton
  • 31
  • 1
3
votes
1 answer

Is it possible to hide the (All) Level for Attribute Hierarchies in SSAS Tabular model

In SSAS multidimensional model the (All) level is an optional level of hierarchy and it is a system-generated level. It contains only one member whose value is the aggregation of the values of all members in the immediately subordinate level. It is…
user1523087
  • 149
  • 2
  • 10
1
2
3
…
57 58