5 votes
Accepted

administrator permissions on a SSAS database

from the comments by Denis Rubashkin Try to use "Run as administrator" when running SSMS, it solved the same problem for me and that worked for me too. to run ssms as and administrator press ...
user avatar
4 votes

administrator permissions on a SSAS database

The SSAS permissions are completely independent from SQL Server permissions. If you don't have permissions, there is one hope: By default, members of the local Administrators group are also ...
user avatar
  • 858
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
3 votes
Accepted

SSAS Tabular Model or SQL Relational Database for new Datawarehouse? Is SSAS still a good to learn technology?

In my opinion, yes - it is still a technology that is completely valid. Even more so if we are discussing Tabular rather than Multi-Dimensional SSAS implementations. For example, VertiPaq (the ...
user avatar
2 votes
Accepted

SSAS Calculated measure with SCOPE.

I don't have your SSAS database so I can't test the syntax, but I believe you would need to write your MDX as follows (notice the THIS= addition): SCOPE ([Measures].[Total]); THIS = SUM([Data Source]...
user avatar
  • 15.4k
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
2 votes
Accepted

How does MOLAP SSAS default processing detect changes in the relational source?

I contacted Chris Webb (SQL Server MVP) about this, who got back to me. The answer is: the premise of the question was wrong. Default processing does not detect changes in the relational source. In ...
user avatar
1 vote

How can I script administrator permissions on a SSAS server?

I highly recommend you check out Analysis Management Objects (AMO) - I use it to perform all maintenance tasks in SSAS such as creating Roles, Permissions, Databases and Models. I prefer to use C# ...
user avatar
1 vote
Accepted

How to dynamically add/remove role members from SSAS 2016 Tabular model

Typically only the role definitions are part of the project. The role memberships are different by environment (dev,test,prod), are usually not administered by the model developers, and so are ...
user avatar
1 vote

SSAS Tabular model table load from query with #temp table fails

The SQL query can be converted to a stored procedure and then executed as the source SQL statement for the SSAS dimension/fact tables. As with a typical stored procedure, you can then use temp tables ...
user avatar
  • 556
1 vote
Accepted

how to add an extended events tracking session to SSAS?

The target is where the event data is stored. For example, to write the data to a file use the event_file target type. To create an extended event and overcome the error on the Data Storage page you'...
user avatar
  • 556
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

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
Accepted

SSIS/SSAS 2016 intermittent fault: An error was encountered in the transport layer

I think we solved this or at least found a workaround. I believe the problem is a timeout when connecting to SSAS when it has been inactive for some time. It has nothing to do with the actual ...
user avatar
1 vote

SSAS Calculated measure with SCOPE.

Some measures, even though they are numeric, makes no sense as SUM. Temp, Datekey (could be numeric) and others. The solution is to mark this measure as non-aggregate in the measure tab. This way it ...
user avatar
  • 570

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