RecodeEntry

RecodeEntry

RecodeEntryDefine RecodeBody RecodeEnd

RecodeEntryDefine

'RECODE' IdentifierString 'FROM' IdentifierString {FactTable} {RecodeType} {ConfidLevel}

• IdentifierString(1) – Display name for the recode.
• IdentifierString(2) – Name of field the recode is based on.

Yes

Yes

Yes

Yes

Yes
If txd contains custom groups created outside SuperWEB2 the load will be successful. However you cannot edit the table containing the custom group.

RecodeType

'TYPE' ('SWEB_GROUP' | 'SWEB_FILTER' | SWEB_DEFAULT)

• SWEB_GROUP – Recode is a group of items from within a field.
• SWEB_FILTER – Recode is a recode of a field.
• SWEB_DEFAULT – Recode is a default recode.

No

Ignored.
Load fails if the txd have recodes that reference sweb_group items.

Yes

Yes

Yes

ConfidLevel

'CONFID_LEVEL' IdentifierString

IdentifierString - Identifies the level at which the confidentiality is to be applied to the table. Must be the name of a fact table from within the database.

Yes

Yes

Ignored for calculations.

No

Ignored for calculations.

RecodeBody

(RecodeResult | DeriveEntry)+ (RecodeMap)+ {(TotalEntry) } {(DeriveEntry)} {Footnote}

RecodeResult

'RESULT' {'HIDDEN'} {'SUPPRESS'} {ResultRange} IdentifierString {ConfidRule}

• IdentifierString – Identifies an item within the field.
• SUPPRESS - Suppress Intersection flag

Yes

Yes

Yes. Incorrect results if hidden is used. See OrderEntryDefine.

Yes.

Yes.

SUPPRESS is ignored

HIDDEN is ignored

ResultRange

'LOW' Integer 'MID' Integer 'HIGH' Integer {'SUBSTITUTION_STRING' IdentifierString}

Yes

Yes

Yes

Yes

Yes

ConfidRule

'CONFID_RULE' IdentifierString

IdentifierString - Identifies the rule to be applied to the field item.

Yes

Yes

Ignored for calculations.

No

Ignore

RecodeMap

'MAP' ('CODE' | 'NAME') IdentifierString* ValueSet 'TO' IdentifierString

• CODE – Indicates IdentifierString(1) is a field items code.
• NAME – Indicates IdentifierString(1) is a field items name.
• IdentifierString(1) – Identifies the code or name of a field item.
• IdentifierString(2) – Identifies which field item in the resulting recode the field item IdentifierString(1) will be assigned to.

Yes

Yes

Yes

Yes

Yes

ValueSet

'VALUESET' IdentifierString

IdentifierString – Identifies the value set code the item is from.

Yes

Yes

Yes

Yes

Yes

Footnote

'FOOTNOTE' IdentifierString

IdentifierString – Footnote associated with the recode.

Yes
Load fails for dimension derivation footnotes.

Yes
Not saved for dimension derivation and textual recode footnotes.

Ignored
Load fails for dimension derivation and recode footnotes.

No

Ignore

RecodeEnd

'END RECODE'

Yes

Yes

Yes

Yes

Yes