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 ...
- 14.8k
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 ...
- 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 ...
- 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 ...
- 12.8k
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]...
- 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 ...
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 ...
- 651
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# ...
- 12.8k
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 ...
- 40.2k
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 ...
- 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'...
- 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 ...
- 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-...
- 131
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 ...
- 3,072
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 ...
- 570
Only top scored, non community-wiki answers of a minimum length are eligible