Using Cubes in Service Manager 2012


Hello,

Today we will demonstrate the basic use of excel cubes in service manager.

Open the service manager console -> Data warehouse -> Cubes

Select the desired cube and click Analyze in Excel.


Let’s start simple. Select IncidentDim -> IncidentdimCount


Ok now let’s add the classifications.



Nice, let’s add a graph.


Easy …

Now we can add the effected user display name.


You can switch labels as desired. Simply move the desired label upwards.


You can also move labels to the report filter section. This adds filtering to excel.



And you can move the label from row to column.



Remember if extensions are in a sealed mp, you can immeditately use them in the excel reports.


Now this is just basic use of the cubes but I’m sure you see that there are endless reporting capabilities in here.

Enjoy …

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s