DAX: Using filter and summarize in same Query

In this SQL Query we are grouping Sales by Year and Color plus adding a filter of 5000 select CalendarYear,color,sum(SalesAmount) from [DimProduct] join FactInternetSales on DimProduct.[ProductKey]=FactInternetSales.[ProductKey] join DimDate on dimdate.datekey=FactInternetSales.OrderDatekey Group by CalendarYear,color Having sum(salesamount)>5000 order by CalendarYear,color   Equivalent Dax of achieving same is: evaluate( filter (summarize (‘Internet Sales’, ‘Date'[Calendar Year], ‘Product'[Color] ,"Sales Amount",sum(‘Internet…

0

PowerShell:How to List Database Roles and their Members

1: [Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") 2: $ServerName = ".\sql2008r2" 3: $DB = "Adventure Works DW 2008" 4: $Server = New-Object Microsoft.AnalysisServices.Server 5: $Server.Connect($ServerName) 6: $SSASDatabase = $Server.Databases.Item($DB) 7: $SSASDatabase.Roles | Select Name, Members

0

SSAS Crashing Intermittently: Caused by Monitoring / AV Scans

Problem Description: Analysis Services is crashing intermittently and also producing min-dumps. Assessment: This could be one of the issues. For getting full analysis of Mini-Dump you can involve Microsoft Customer Support Services and ask them to analyze dumps. In this case we found: The issue is SMS client (CcmExec) does software inventory periodically, and it…

0