10 votes
Accepted

SSAS Tabular: ImpersonationMode that is not supported for processing operations

I agree the documentation on this is a bit terse, but the error message on the other hand is very clear. ImpersonateCurrentUser is not supported for models attached to a SSAS instance. This is ...
user avatar
  • 15.4k
7 votes
Accepted

SSAS Model Refresh - Not enough memory to complete this operation Error

TL/DR: Add more Memory, reduce the size of your Model(s), and/or move either the SQL Server Services or SQL Server Analysis Services to a different server (e.g. scale out) Longer Explanation: We went ...
user avatar
6 votes
Accepted

How do I tell which Edition and Version my SSAS Instance is running?

The easiest way is : using SSMS -- connect to instance --> reports -> standard reports --> General There are other ways as well - How to find Analysis Services Server Version ?.
user avatar
  • 61.2k
4 votes
Accepted

The column 'Date Offset' in table 'Date' has invalid bindings specified

The problem in this case was that I was trying to replace an existing column also named 'Date Offset' - this was not a calculated column, but taken from the source table. Resolution was to do the ...
user avatar
  • 1,194
4 votes

The 'Database' with 'ID' = 'xxxxxxx' doesn't exist in the collection

One thing that could cause this is if you use the Name of the database instead of the ID. For example, I created a database with with the name Demo1, so the ID defaulted to the same string. ...
user avatar
  • 15.4k
3 votes

SSAS cube fact and dimension relationship

What you are seeing is a typical example of a missing dimension relationship. Yes it has something to do with the relations in your dsv but easy to solve with dimension relationships. If you add a ...
user avatar
  • 15.4k
2 votes

SSAS Model Refresh - Not enough memory to complete this operation Error

I had similar problem and until we start using Azure Analysis Services, I had to find a work around with SSAS standard edition which can only allocate 16GB of memory regardless whether you're on-prem ...
user avatar
2 votes

StorageEngineUsed set to TabularMetadata. For databases in this mode, you must use Tabular APIs to administer the database

It sounds like you are trying to process your tabular model (which is of version >= 1200) with XMLA script (so all in all command is in XML). That kind of tabular model has to be processed with JSON ...
user avatar
1 vote
Accepted

SSAS Tabular model Date Dimension with Time possible?

Generally I keep Date and Time in separate dimensions as this reduces the overall cardinality but even with your date dimension having a time element, you should not have a problem obtaining this ...
user avatar
1 vote
Accepted

Link DAX OpenQuery Output to SQL Server Temp Table

If a column name has brackets, you need to escape them. You can see how if you use function QUOTENAME(). SELECT QUOTENAME('[awful column name]') -- Result: [[awful column name]]] Note the extra ...
user avatar
  • 3,239
1 vote
Accepted

Multi condition DAX row filter

Not an answer to your exact question, but instead of translating the SQL to DAX and maintaining it in two places, you can reuse the SQL logic in your RLS implementation to materialize tables in your ...
user avatar
1 vote

Dynamic Partition on tabular model 1200 using visual basic 2015 in visual studio

I would study this white paper and the AsPartitionProcessing sample for ideas. Ignore that it targets Azure Analysis Services as it should work against your SSAS instance if you use that servername ...
user avatar
  • 1,365
1 vote
Accepted

SSAS Tabular Cube partitioning - number of partitions

In SSAS 2014 Tabular partitions inside a table process serially. In SSAS 2016 Tabular partitions inside a table can process in parallel. So in your version partitioning won't speed up processing if ...
user avatar
  • 1,365
1 vote
Accepted

How to truncate an SSAS Tabular partition

In SQL Server Management Studio you can connect Object Explorer to SSAS, expand to the table, right click, choose Partitions, then click to process one or more partitions and do a Process Clear:
user avatar
  • 1,365
1 vote

How to emulate performant date dimension for SSAS model in tabular mode / direct query

Thanks to @GregGalloway to set me to right track. I ended up with following schema: 1) I've added new mapping table [DateMap] that materialize mapping between UTC datetime (in those weird quarter-...
user avatar
1 vote

SSAS 2016 tabular : Discrepancy on countrows between measures visual studio vs Excel

The solution was to change the processing in Visual Studio (VS) from Default to Full. The issue is described in detail here: https://connect.microsoft.com/SQLServer/feedback/details/685325/processing-...
user avatar
  • 681
1 vote

How to move SSAS tabular instance databases?

You can back up and restore SSAS Tabular 2012 databases, but you will have to adjust the security role memberships to include users in the correct domain. You can perform the backup and restore ...
user avatar
  • 824
1 vote
Accepted

Remove Data From Memory when Using SSAS Tabular In-Memory Mode

For the "Is it possible to remove old partitions from RAM?" portion of your question: Yes. The BOL entry for Process Database, Table, or Partition mentions Process Clear in the "To process one or ...
user avatar
1 vote

How to calculate/store Top 10 in a tabular model?

I had a similar scenario and used the following DAX query... First, to make it simple, I defined a measure to use inside the DAX so I don't have to repeat the formula. Then I used the generate to ...
user avatar
1 vote
Accepted

SSAS tabular browse Excel relationships not working

I think i've found the problem. SSAS doesn't seem to relate data between tables if there are no measures defined. I added a simple measure like grade count and voila i have my data relationship.
user avatar
  • 281

Only top scored, non community-wiki answers of a minimum length are eligible