WHen I do a cube report and show the number of active incidents it shows as 63210, I know for a fact that we only currently have 58 incidents in an active state so why is this happening?

When I looked at the incidentid for some of the 63210 incidents I can see they are closed.

the "Incidents Active" in the pivot table represents the total number of the incidents that were & are in active status. In other words, the total number of the created Incident including any deleted Incident (because deleting Work Items using SMLets remove-object, deletes it from SM DB but NOT from the DW DB)

to get the incident status (e.g. in progress):

Check IncidentDimCount > Scroll down to IncidentDim_IncidentStatus, expand More Fields and check IncidentStatusValue