Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [ssas-2016]

18 questions
6
votes
2 answers

administrator permissions on a SSAS database

I had a third party company coming over and building ssas databases to produce reports. They did, but now the DBA wants to have a look but I haven't got permissions, to even see those databases, as you can see on the picture below. Can I grant…
Marcello Miorelli
  • 17,274
  • 53
  • 180
  • 320
3
votes
5 answers

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

I'm trying to deploy a tabular model to a server using the "Analysis Services Deployment Wizard". When attempting to deploy,I get the below error. The JSON DDL request failed with the following error: Failed to execute XMLA. Error returned: 'The…
Neil P
  • 1,294
  • 3
  • 20
  • 38
2
votes
2 answers

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

I am an administrator in SSAS. I have many data warehouse servers. In some servers I have SQL Server and SSAS on the same machine. I successfully backup the SSAS databases and even check if the backups are healthy Recently, however, one of our…
Marcello Miorelli
  • 17,274
  • 53
  • 180
  • 320
2
votes
1 answer

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

I am in the process of creating a data warehouse using SQL Server for my company. I have created a POC with a simple SQL Relational database with a few(about 10) stored Procs for the ETL process. Now that I have business buy in to step it up to a…
WadeH
  • 540
  • 4
  • 20
2
votes
1 answer

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

When you set SQL Server SSAS to MOLAP, and default processing, it detect changes in the relational source and only loads those changes into the SSAS MOLAP storage at processing time. But how does it detect those changes in the first place?…
user3469285
  • 671
  • 2
  • 10
  • 19
2
votes
2 answers

SSAS Calculated measure with SCOPE.

I'm building an SSAS OLAP cube on Meteorological data. Some of this data can be totaled (eg rainfall) and some can't (like wind direction). I want totals, but only on data sources where it makes sense. (Where the interpolation method = 3.) I've…
Sir Swears-a-lot
  • 3,253
  • 3
  • 30
  • 48
1
vote
2 answers

How can I script administrator permissions on a SSAS server?

I am an administrator for a bunch of SSAS Instances. Sometimes I need to install or migrate SSAS instances to different machines or even different AD domains (we have a couple of different AD domains in a trusted relationship). Same as with sql…
Marcello Miorelli
  • 17,274
  • 53
  • 180
  • 320
1
vote
1 answer

how to add an extended events tracking session to SSAS?

I would prefer to have a script to achieve this, but as I am not so familiar with SSAS I am using the wizard to create an extended events session in SSAS. The way I am doing it is right clicking on the following place and getting a new session…
Marcello Miorelli
  • 17,274
  • 53
  • 180
  • 320
1
vote
2 answers

Is it ok to install a SSAS 2016 instance next to a SQL Server 2014 instance?

Should I expect any problems installing a SQL Server Analysis Services 2016 tabular instance next to a SQL Server 2014 database engine? (e.g. due to an update of some shared components) I'm mostly worried about any issues related to the running…
Stephan
  • 111
  • 2
1
vote
0 answers

How make an SSAS Tabular model case sensitive?

I need to make my tabular model case sensitive. Currently my tabular model is case insensitive, how do I change my existing cube to be case sensitive?
Neil P
  • 1,294
  • 3
  • 20
  • 38
1
vote
1 answer

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

I have an indexed datetime column - lets call it "CreatedDateUTC" in table "Entity" in MSSQL db. Column contains UTC datetime. User connecting to db has known timezone offset. I have another table - DateDim with primary key column Date. This is to…
Ondrej Svejdar
  • 131
  • 4
1
vote
1 answer

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

I have an intermittent fault in my SSIS ETL process when I try and process my OLAP cube. There are no error messages in the SQL log, and there's nothing else significant running at the time. The only error message I can find in the event log is: …
Sir Swears-a-lot
  • 3,253
  • 3
  • 30
  • 48
0
votes
0 answers

MS SSAS named instance doesn't work after NTLM deny

Named instance MS SSAS don't accept connections after NTLM incoming/outgoing traffic deny. There is SPN for this server like: FQDN SPN: Setspn -s MSOLAPSvc.3/AW-SRV01.AdventureWorks.com:AW-FINANCE AdventureWorks\SSAS-Service NetBIOS SPN: Setspn -s…
FlegmaSpirit
  • 1
  • 3
0
votes
0 answers

Running Sql Analysis server on different server

i have server running a database on it, and i have another server which i want to run Analysis server on it, so people can connect the analysis server as they wish to create their own reports for some purposes, but the problem is i could not connect…
washaq
  • 37
  • 1
  • 10
0
votes
2 answers

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

We have several situations where complex queries are being used for creating/populating tables in our SSAS tabular model. The actual use cases cannot be presented here, due to both proprietary information and pure length of queries, but the…
Kris Cook
  • 23
  • 5
1
2