Insert a Member

By default, when you insert members from the source tree into your report with IBM® Cognos® Workspace Advanced, members are inserted with their children and are inserted as sets. You can change how members are inserted. For example, you may want to insert a member without its children or insert only the member's children.

You can set your report options to insert a member's children when you double-click a member that you have already inserted in your report. You can control whether the children are inserted before or after, nested, or not inserted at all. To do this, from the Tools menu, click Options, and then choose a setting on the Edit tab.

You can set the default behavior for replacing members to replace individual nodes, replace the entire edge, or not to replace anything. To do this, from the Tools menu, click Options, and then choose a setting on the Edit tab.

Note: You cannot change these member insertion and replacing behaviors when you have opened a widget from a workspace in IBM Cognos Workspace to edit it in Cognos Workspace Advanced. In this case, double-clicking a member drills down and replacing members replaces the entire edge.

When inserting members into a crosstab, ensure that you insert members from the same hierarchy on only one of the crosstab edges. If you insert members from the same hierarchy on both edges of the crosstab, you may encounter unexpected results. For example, a report that uses members from years in the rows and Quarters in the columns is very difficult to read because the useful numbers are distributed over a large area of mostly blank cells.

Calculated members from the data source also appear in the source tree. However, calculated members in Microsoft SQL Server Analysis Services (SSAS) cubes do not appear in the list of descendants in the query. If you want these calculated members to appear in a report or a prompt, you must insert them explicitly.

Procedure

From the Source tab , click the insert member with children button and select how to insert members.
If you want to insert individual members instead of inserting members within a set, click the insert individual members button .
Do one of the following:
- To insert a member above or below another member, drag the new member above or below a cell.
  A flashing black bar appears where you can drop the new member.
- To replace an entire edge, drag the new member to the cell with the member to replace.
  A flashing black box appears where you can drop the new member.