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

SSAS (SQL Server Analysis Services) – KPI – Comparing Date and Hour for the Previous Week or Multiple Values in your KPI Goal and Trend Expressions

by October 16, 2013

What I wanted to do was to use a KPI in SSAS to compare values going back one week. But I wanted to get the same hour for the previous week. I could not find an example were it had used multiple values in a KPI Goal or Trend expression. All just used one value.   Example: ·         For my…

KPI, SQL Server Analysis Services OLAP 0