Transformations and Transformation Sets

In CDM XBRL, you can create transformations and transformation sets to change the way that data is presented.

When you tag data from a CDM object, you can apply various transformations to the data. In addition to the one-time inputting of data into the Pivot Grid, the system remembers the transformation set of the tag so that refreshes of the items are similarly applied. A transformation set is a sequence of transformations.

Add a Transformation Set

You can use CDM XBRL to add a transformation set.

1. Click the Home tab, then in the Navigation Pane, click Administration.
2. Under XBRL, double-click Transformations. The Transformations tab opens in the work area.
3. Click Home > Add > Transformation Set.
4. Type the required information into the fields.
   • Name - Type a user-defined name for the transformation set.
   • Description - Enter a description to identify the transformation set. This is optional.
5. In the Transformation Chain section, click Add and make a selection from the drop-down menu. Repeat this step for as many transformations as necessary for the transformation set.

   You can select from the following transformation types. The transformations indicate the input and output types that they support.

   Transformation Type	Description
   Text to Number with separators	Transforms formatted text with decimals and thousands separators into a numerical item type.
   Text to Date	Transforms formatted text with dashes, points, comma, spaces, or slashes into a date item type.
   Number to Nil	Transforms a numeric item to a nil item type. Usually used to transform 0 to nil.
   Omit Number	This will cause numerical items to not be created. Causes a specified number to be omitted from the instance document. For example, zero. The item is created, but not generated in the instance document.
   Scale	This will apply a scale factor to the numerical item type. Usually used to multiply by millions. For example, a large data sheet of financial figures might be reported in millions. In XBRL, these visible figures must be multiplied by 10^6 in the instance document.
   Text to Nil	This will cause special text values to be interpreted as nil items. For example, (nil).
   Text to Text	Transforms formatted text to a specific valid value such as Yes, No, or an enumerated value (for example, Annual report to 10-K).
   Text to Zero	Transforms static text to numerical zero. Common scenarios include different dashes or empty content.
   Text to Empty	Transforms any text to empty content.
   Text to Boolean	Transforms any text to boolean item type. Used to transform any text to true or false.
   Number to Duration	Transforms decimal input to duration type output (PnYnMnDTnHnMnS). Used to transform 22.3456 to P22M10D. For US SEC only.
   Text with unit to Number	Transforms mixed string monetary value with string unit indicators and optional thousands separators into non-negative numbers based on schema-defined decimal format. Supports single- and double-byte characters.
   Text to Duration	Transforms text to duration type output (PnYnMnDTnHnMnS). Used to transform Five Years, two months to P5Y2M. For US SEC only.
   Text to Number	Transforms case-insensitive English text with allowances for connectives (such as a comma or and) into numerical item type. Used to transform seventy thousand and one to 70,001. For US SEC only.

6. Click OK.

Restrictions:

• If the value that is being passed into a transformation is not the correct type, it is passed on to the next transformation in the transformation set. The output of the last successful transformation is the one used for the concept that you are tagging.
• If no transformations are successful, then the output is the value as found in the report object. The transformation set for that tag is remembered by the system despite not applying any of the transformations.

Modify the Process Order of Transformations in a Transformation Set

You can use CDM XBRL to add, delete, and change the order of processing XBRL transformations in a transformation set for a report.

1. In the Transformations tab in the work area, right-click on the transformation set you want to edit and select Edit.
2. In the Edit window, you can edit the name and description of the transformation set, add and delete transformation types for the set, and change the order of processing.
   • To add a transformation, click Add and make the selection from the drop-down menu. Repeat this step for as many transformations as you need.
   • To delete a transformation, select the transformation and click Delete.
   • To change the order of processing, drag the transformation into the required order or click Move up or Move down.
3. Click OK.

Delete a Transformation Set

You can use CDM XBRL to delete an XBRL transformation set from a report.

Important: A transformation set that is used in a tag cannot be deleted. You cannot undo a deletion. Proceed with caution.

1. In the Transformations tab in the work area, right-click on the transformation set you want to delete and select Delete.
2. In the confirmation window, click Yes.