Insert items

You insert items from the source tree as rows and columns in an Exploration View or list to create sets for exploration. A set is a collection of like data. For example, you can have a set of data named years that includes quarters as details.

You can control how items are inserted by setting the insert option on the exploration bar. For an IBM® Cognos® Analytics data source, you can use the following insert options.

  • Insert Single Member, which inserts the selected member.
  • Insert Member With Children, which inserts the selected member and its components to one level as a static set.
  • Insert Member With Dynamic Children, which inserts the selected member and its components to one level as a dynamic set.

In addition to items from the source tree, you can insert items retrieved in a search.

Note: The default measure specifies the measure to use for an Exploration View if the measure is not set by one of the existing axes. For example, you create an Exploration View with Products in the rows and Quantity Sold in the columns. You add Revenue to the Measure drop zone to make it the default measure, but the values in the rows do not change because they refer to the measure Quantity Sold in the column axis. However, if you replace the measure Quantity Sold with the non-measure Order Method, the values now refer to Revenue as the default measure.

You can also simultaneously insert all the items of a level Insert all the items of a level, insert some items from a level, or insert items from different levels of the same dimension Insert items from multiple levels of a dimension.

Procedure

  1. Select the insert option you want to use.
  2. In the source tree, select the items that you want to insert.
  3. Drag the items to the desired location in the Exploration View or list.

    To add an item to items that already exist in the Exploration View or list, hold down the Ctrl key when dropping items into the drop zones.

    A highlighted bar indicates where you can drop the item.

    Note: Sometimes, when you add measures to columns or rows, you may notice that other items get re-ordered. This is a query framework behavior. Unlike an OLAP data source, DMR data is not returned in a specified order. If a specified order is required, you must edit the specifications in Framework Manager.

    A detail-based set appears in the Exploration View or list.

    You can insert items as a selection-based set by pressing Shift+click or Ctrl+click to select multiple items in a dimension and then dragging them to the Exploration View or list. When selecting multiple items, the selected items are placed in the Exploration View in the order that you click them. To avoid rearranging items after you drag and drop them into the Exploration View, click the items in the desired order of placement.