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.
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.