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