Using Cubes in Service Manager 2012


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 …


Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s