Service Probability Analysis

This table shows the table from which fields are retrieved for the dimension:

Table Description
tsclm350 Service Resolution - Probability Analysis
tsclm810 Call history

This table shows the attribute mapping for the dimension:

Attribute Mapping
Activity tsclm350.espr
Actual Problem tsclm350.espr
Actual Problem Desc tsclm335.desc
Actual Solution tsclm350.sltn
Actual Solution Desc tsclm335.desc
Call Group1 tsclm350.cgrp
Call Group2 tsclm350..scgr
Company tsclm350.compnr
Expected Problem tsclm350.expr
Expected Problem Desc tsclm335.desc
Expected Solution tsclm350.ecsl
Expected Solution Desc tsclm350.desc
History Date tsclm350.hidt
Installation Group tsclm350.clst
Order Type
  • tsclm810.orno = tsclm350.ccll and tsclm810.rmso <> tsclm350.orno and tsclm810.rmso is not blank and tsclm350.orig = Call, then order type = Work Order.
  • tsclm810.orno = tsclm350.ccll and tsclm810.rmso = tsclm350.orno and tsclm810.rmso is not blank and tsclm350.orig = Call, then Maintenance Sales Order.
  • tsclm810.orno = tsclm350.ccll and tsclm810.rsvo is not blank and tsclm350.orig = Call, then Service Order.
Order tsclm350.orno
Origin tsclm350.orig
Origin Filter tsclm350.orig
Origin Sort tsclm350.orig
Problem Code Flag If tsclm350.expr <> tsclm350.espr then 1, else 0
Reference Activity tsclm350.crac
Reported Problem tsclm350.rprl
Reported Problem Desc tsclm335.desc
Serialized Item Group tsclm350.sigr
Service Item Group tsclm350.csgr
Solution Code Flag If tsclm350.exsl<> tsclm350.sltn then 1, else 0
Unknown 1 for null records, else 0
deleted 1 if deleted in LN, else 0
Customer Defined Fields Standard list of fields