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 ...
Community wiki
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
ssas × 346sql-server × 178
mdx × 46
olap × 35
cube × 33
sql-server-2014 × 28
tabular-model × 26
sql-server-2012 × 25
sql-server-2008-r2 × 18
data-warehouse × 17
ssis × 15
dimension × 15
ssas-2016 × 15
sql-server-2008 × 14
sql-server-2016 × 14
backup × 13
ssrs × 13
dimensional-modeling × 12
business-intelligence × 10
visual-studio × 9
ssms × 8
powershell × 8
performance × 7
security × 7
slowly-changing-dimension × 7