Hot answers tagged

2 votes

SSAS memory limits

based on this: https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019?view=sql-server-ver16#Cross-BoxScaleLimits your ssas standard edition has some memory limits. ...
  • 3,975
1 vote

How do I tell which Edition and Version my SSAS Instance is running?

You can do that via PowerShell for a list of servers: $list = 'server1','server2' $loadInfo = [Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") if($ssas){Clear-...
  • 503
1 vote

Why is MDX Moving Average Calculation Inconsistent in Excel?

I would guess that it has something to do with CurrentMember. Since your calculation is specifically looking for the current week and then the prior 51 weeks, if you feed it something that isn't a ...

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