Creating Transformations to Define Time-Based and Other Comparisons » Transformation metrics and joint child attributes

Transformation metrics and joint child attributes

Review the discussion of joint child attributes and relationships in Joint child relationships before proceeding in this section.

In a report, a transformation metric displays the current attribute with transformed data, that is, the values for the transformation. For example, a report contains Quarter and the transformation metric Last Year’s Revenue. Each quarter is displayed, with the previous year’s revenue, as shown below:

When a joint child attribute, which is an attribute that exists at the intersection of other indirectly related attributes, is added, this affects how the attribute elements and transformation values are displayed.

For example, the joint child attribute Promotion is added to the previous report. The report displays the quarter, the promotion associated with a given quarter, and the revenue data from the date-promotion combination, minus one year. To demonstrate the effect this has on the display of data on the report, the report below shows the revenue for all quarters in 2009 and 2010, without any transformations:

The highlighted data in the report shown above indicates that in the fourth quarter of 2009, there was $52,529 of revenue related to the Memphis Special Sale promotion. You can also see in this report that the Memphis Special Sale promotion was not held in the fourth quarter of 2010. The report below shows how this data is displayed when a transformation of the data is used:

In the report shown above, notice that the Memphis Special Sale is displayed with the fourth quarter of 2010, and the fourth quarter of 2009 has no listing of this promotion. This can seem contradictory as compared to the previous report that did not include a transformation on the data. However, this is due to the fact that the Last Year’s Revenue metric is displaying data for the previous year for each attribute element. Since the joint child attribute is dependent on time, the attribute elements also must change to reflect the transformation of data. This results in a report that displays the Memphis Special Sale data for the fourth quarter of 2010, because this was the revenue that was generated for this quarter during the previous year.