Extended Data Items

Extended data items differ from the traditional, expression-based text strings by enabling you to add children, view details, select sets, sort sets, and apply contextual calculations.

Extended data items are created when you insert data items from dimensional packages. Extended data items do not apply to relational packages or non-dimensionally modeled packages.

You can do the following with extended data items that are not available with traditional data items:

  • Add an extended data item's child members

    You can double-click an extended data item to insert its child members beside it in the report object.

  • View an extended data item's details

    You can select an extended data item and see where the data item appears in the package in the Properties pane under Data Item.

  • Select member sets

    You can select a member in a set to highlight it as the primary selection and the other members as secondary selections.

  • Sort sets

    You can select an extended data item, click the sort button sort icon in the report object toolbar, and click Edit set sorting to sort a set in ascending or descending order, to sort hierarchically, and to sort by caption, by a property, or by an intersection (tuple).

  • Apply contextual calculations

    You can select an extended data item and then, from the report object toolbar, click the Insert Calculatation icon insert calculation icon to see a contextual list of calculations that are available for this extended data item.