IT Operations Management (ITOM)
Showing results for 
Search instead for 
Do you mean 

The Secret Sauce of Service Health Reporter

Scott_Edwards ‎02-10-2012 05:30 AM - edited ‎02-21-2015 07:35 PM

**NOTE - To view the below screenshots more clearly, click on "Article Options" at the top of this article and select "Printer Friendly Page."**

 

In his blog on Cross Domain reporting, Suresh Venkataraman explains HP Service Health Reporter’s (SHR) Run-time Service Model (RtSM) driven approach to BI. This is possible by conforming dimensions across domains.

 

In Data Warehouse parlance, dimensions are entities that serve as a mechanism to slice and dice measures stored in fact tables. Data Warehouse tables are often arranged as set of data marts, each catering to a specific domain or problem. This leads to a silo architecture where each domain is distinct and similar dimensions are represented differently in each data mart making cross-domain analysis very difficult if not impossible.

 

SHR solves this issue by enforcing conformance across a set of standard dimensions. Dimensions are conformed when they are either exactly the same or one is a subset of the other. These dimensions serve as an entry point or mechanism to slice and dice data across several data marts. SHR implements several design patterns for Dimension Conformance.

 

The following figure depicts a pattern where the same dimension is used across data marts.

 

 

In the above example, a user analyzing Fact1 in the context of Dim1 can link to Fact2 via the ConfDim; here ConfDim acts as a bridge between the two fact tables, hence enabling cross analysis between the two. The above pattern is used to implement SHR’s DateTime dimension.

 

The pattern depicted below achieves conformance by treating one dimension as a subset of another “master” conformed dimension.

 

 

This pattern is used extensively in SHR. The rows of ConfDim, are a mathematical subset of MastConf and share the same keys; while the ConfDim may have several additional columns to the ones contained in MastConf, it will always contain the columns present in MastConf. A typical example of this in SHR is the modeling of Configuration Items (CI) defined in RtSM. This pattern allows MastConf dimension to be restricted to common CI attributes and not be burdened with domain/CIType specific attributes. All type specific attributes are relegated to the appropriate ConfDim tables.

 

Two dimensions can be conformed by replicating them across data marts as shown below.

 

 

The above pattern demands that both the ConfDim dimension tables be kept absolutely the same at all times. This pattern is not used in SHR today.

 

Conformed dimensions are indeed the secret sauce in SHR architecture and enable all the cross domain goodness it has to offer. It is a powerful design pattern that requires a fairly sophisticated ETL layer but yields an elegant and easy to use schema for advanced in-depth analysis.

 

References: “The Data Warehouse Toolkit” by Ralph Kimball and Margy Ross

0 Kudos
About the Author

Scott_Edwards

Product Marketing Manager for HP Application Performance Management suite of software products. Before this role, I worked in the HP StorageWorks Division working as both a Product Marketing Manager overseeing enterprise hardware and software, as well as working as Business Development Manager for the Enterprise Services channel.

Comments
Arjun Venkatesh
on ‎01-10-2013 10:45 PM

Hello Suresh...,

Good day!!

I was wondering if you can share the link for SHR 9.20 webinars and documents.. It'd be of great help to me

 

Thanks

Arjun Venkatesh

Amit351
on ‎04-10-2013 12:31 AM

Hi,

 

I am new to SHR, can anybody tell me how I can create new user in SHR.

 

Kind Regards,

Amit Bandal

Events
June 6 - 8, 2017
Las Vegas, Nevada
Discover 2017 Las Vegas
Join us for HPE Discover 2017 in Las Vegas. The event will be held at the Venetian | Palazzo from June 6-8, 2017.
Read more
Apr 18, 2017
Houston, TX
HPE Tech Days - 2017
Follow a group of tech bloggers for a new HPE Tech Day, a full day of sessions about how to create a hybrid IT, from hyperconverged to Composable Infr...
Read more
View all
//Add this to "OnDomLoad" event