Stack Overflow
Stack Overflow

Questions tagged [ssas-2016]

19 questions
9
votes
2 answers

SSAS Measure Group EstimatedSize EstimatedRows

The properties panel in SSDS for a Measure Group has two properties I'd like to learn more about: EstimatedRows and EstimatedSize. There seems to be little documentation on either of these. I did find that I can run the Aggregation Design Wizard and…
Mike Smith - MCT
  • 1,166
  • 1
  • 9
  • 15
9
votes
1 answer

Do Clustered Columnstore Indexes Affect SSAS Query End User Performance

Do Clustered Columnstore Indexes affect SSAS Performance querying for the end-user, and how could to fix this? Read an article below here how Sort order affects SSAS query customer user performance. Is there any way to resolve this issue? Would…
user11156893
2
votes
1 answer

Reduce parallelism when processing a SSAS Tabular model using TOM

I process our tabular models (Compatibility level 1200) using the Tabular Object Model and a powershell script. The script uses some metadata to determine what partitions need to be processed for a given table, and then does a process full on those…
Brandon McClure
  • 1,329
  • 1
  • 11
  • 32
2
votes
1 answer

SSAS Data Source View Relationship

I need to get all the relationships in my SSAS cube Data Source View between Fact and Dim tables. I've around 15 Fact tables and linked dimensions to it. Is there any MDX query to get the relationship other then doing it manually
Arvind
  • 192
  • 1
  • 10
1
vote
1 answer

Display table names

I have a tabular model cube with Compatability Level SQL Server 2016. I assigned the columns and the measures in two different display folders. When analyzing the cube with Excel, the columns and the measures are displayed in two different display…
hana
  • 101
  • 10
1
vote
1 answer

DAX alternative for IN function

I have a table in SSAS Tabular model having delivery date of vehicles. There is a dimension table with Age values - I need to write a DAX to show the count of delivery for each year. In the PowerBI report which connects to the Tabular model, the…
Madan
  • 41
  • 5
1
vote
1 answer

SSAS MDX: Calculated member doesn't show up in Excel

I created the calculated member as described below in SSMS (not VS, therefore I did not deploy it) by selecting the command and executing it. Accessing this member in MDX works out fine. But Excel doesn't show me this measure, and I also do not see…
Jens-Peter Giersch
  • 23
  • 6
1
vote
1 answer

Analysis Services Deployment Wizard 2016

In trying to run the Microsoft.AnalysisServices.Deployment.exe I get the following error Could not load type 'Microsoft.AnalysisServices.ManagementDialogs.TabularProcessProgress' from assembly 'Microsoft.AnalysisServices.ManagementDialogs,…
DenisJC
  • 43
  • 7
1
vote
0 answers

How to identify the SQL server objects that a SSAS cube is dependent on?

I have several SSAS cubes which are processed daily. This is done with a SSIS project which is scheduled to run daily at a set time. Sometimes we have ETL issues and my processing job chugs ahead without knowing that the underlying tables are…
Brandon McClure
  • 1,329
  • 1
  • 11
  • 32
1
vote
0 answers

Created perspectives in SSAS tabular don't appear

I am trying to create perspectives in a SSAS Tabular mode cube in Visual Studio 2013. But the problem is that the created perspective doesn’t appear when I click on OK. I have tried it several times, and each time with another selection of tables.…
Naoufal
  • 11
  • 2
0
votes
2 answers

SSAS OLAP yes/no Dimension including all rows on yes option

I need to add a new dimension to my OLAP cube to filter some rows. Essentially if the users select "yes" it should appear all rows. If the users select "no" it should appear the rows identified. I have a column in my factual table with 0 and 1…
Ricardo Castro
  • 157
  • 13
0
votes
1 answer

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
  • 650
  • 7
  • 16
0
votes
1 answer

DAX - PARALLELPERIOD() to get the previous minute

In DAX, I want to get the value for a previous minute. I know the PARALLELPERIOD function can do this for the date and year, but does not allow this to be done by minute. Is there an easy way I can write the below: [DateTime] = [DateTime] - (…
Neil P
  • 2,920
  • 5
  • 33
  • 64
0
votes
0 answers

DAX only count first occurrence

I have the following tables in a SSAS 2016 Tabular model: fact_ContactScore (inluding foreign key to dim_account and a measure TopContact) dim_Account (has accountname and parentaccountname) An account can have multiple records in the…
analyzethat
  • 191
  • 1
  • 16
0
votes
1 answer

DAX - check for the existance of a column in the query

Is it possible, in a DAX measure, to check if the current query contains a particular column? For example, I have a column named "Time" - is it possible to detect if a user in a self service environment has included this in their report, from the…
Neil P
  • 2,920
  • 5
  • 33
  • 64
1
2