Service Failure Analysis

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

Table	Description
tsclm400	Service Resolution History - Failure Analysis
tsclm370	Service Resolution - Failure Analysis

This table shows the attribute mapping for the dimension:

Attribute	Mapping
Activity	tsclm400.acln
Actual Problem	tsclm400.espr
Actual Problem Desc	tsclm330.desc
Actual Solution	tsclm400.sltn
Actual Solution Desc	tsclm335.desc
Company	tsclm400.compnr
Failure Date	tsclm400.fadt
History Date	tsclm400.hidt
Line	tsclm400.lino
Order Date	tsclm400.ordt
Order Number	tsclm400.orno
Origin	tsclm400.orig
Origin Filter	tsclm400.orig
Origin Sort	tsclm400.orig
Reference Activity	tsclm400.crac
Sequence Number	tsclm400.seqn
Serial Number	tsclm400.sern
Service Failure Analysis	tsclm400.orig + tsclm400.orno + tsclm400.acln + tsclm400.lino + tsclm400.seqn
Unknown	1 for null records, else 0
deleted	1 if deleted in LN, else 0
Customer Defined Fields	Standard list of fields