Power View – Using MDX, SSAS Tabular and Power View to display potential issues based on past trends in data

by December 11, 2013

What I am going to explain below is using the above MDX, SSAS Tabular and Power View to display potential issues based on past trends within our data.   For our example we are going to using the example of SCOM data. Within our example we are looking for systems where the available memory has dropped more than 50% of…

SQL Server Analysis Services OLAP, SQL Server Analysis Services Tabular, SSAS, SSRS 0

SCOM (Systems Center Operations Manager) Cube and Data warehouse

by November 14, 2013

What I have done is I have found that it is very handy having all our SCOM data in a data warehouse and then having it in a SSAS (SQL Server Analysis Services). Within the zip file which can be located here below it has all the details for the following: ·         SCOM Data Warehouse and OLAP Documentation.docx o   This…

KPI, SQL Server Analysis Services OLAP, SQL Server Analysis Services Tabular, SQL Server Reporting Services, SSAS, SSRS 12