Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

  7. current community

    your communities

    more stack exchange communities

    company blog
Database Administrators

Questions tagged [ssas-2016]

The tag has no usage guidance.

15 questions
Info Newest Frequent Votes Active Unanswered
0
votes
0answers
7 views

How to create a data history in a dimension without using slowly changing dimension?

I'm working on my fact table and I want to create history table for each dimension without using slowly changing dimension because my data flows are bulky and it will take too much time to finish the ...
1
vote
1answer
17 views

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 ...
0
votes
1answer
17 views

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 ...
1
vote
1answer
93 views

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 ...
-1
votes
2answers
91 views

information about licensing and patching SSAS [closed]

I have one server for data warehousing, and it has 2 instances of SSAS (SQL SERVER Analysis Services). The data warehouses are not that big, less that 200GB, and I backup the whole thing on a daily ...
0
votes
1answer
154 views

Link DAX OpenQuery Output to SQL Server Temp Table

I want to record measures from a Tabular model, as KPIs, and store the values in a table in SQL Server. I have created a linked server from my SQL Server instance to my SSAS instance. I have written ...
4
votes
2answers
1k views

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 ...
1
vote
2answers
47 views

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 ...
0
votes
1answer
387 views

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

I am developing a number of tabular models, which currently have a limited number of users assigned to roles within each. At the moment, with the exception of 1 or 2 cases, the majority of the users ...
2
votes
1answer
86 views

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 ...
2
votes
3answers
2k views

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 ...
1
vote
0answers
224 views

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?
1
vote
1answer
94 views

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 - ...
1
vote
1answer
627 views

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 ...
2
votes
2answers
3k views

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 ...