Entering data

You can enter in your data directly into the IBM® Cognos® Insight crosstab and use commands to perform simple calculation tasks. You can also copy and paste into the cells or import data from a Microsoft Excel workbook or a CSV file.

1. To change the values in a cell, select the cell and type the new values, and then press Enter or use the arrow keys to move to another cell.

   When you press Enter, the data is displayed in blue and the row and column headers are highlighted in blue. This indicates that the data you have entered is different than the original values on the IBM Cognos Express® or IBM Cognos TM1® server. If other cells are related to the cell where you entered data, pressing Enter results in these cells turning blue to indicate that their values are also different than the original values on the server.

   When you use the arrow keys to move to another cell, the data is displayed in green if you are contributing to a plan. This indicates that the data in the cell has changed and that the change is pending. Recalculations are not performed and related cells are not updated. If you are working with personal data, the data is displayed in blue until you save the workspace.

   When you commit your changes by clicking the Commit icon , the changed values are saved on the Cognos Express or Cognos TM1 server. The data is then displayed in black to indicate that others can see the changes to the data.

   Data that will appear in a chart must be in the following range: 0.000000001 to 99,999,999,999,999,999,999,999,999,999,999.

2. You can use the following commands to enter data in a cell. These commands are processed when you press Enter and can apply only to the current crosstab. These commands are not case-sensitive.

   Table 1. Commands for entering data

   Command	Description
   K	Enters the value in thousands. For example, 5K results in 5000 being entered in the cell.
   M	Enters the value in millions. For example, 10M results in 10,000,000 being entered in the cell.
   Add, +	Adds a number to the cell value. For example, Add50 adds 50 to the cell value.
   Sub	Subtracts a number from the cell value. For example, Sub50 subtracts 50 from the cell value.
   Increase, Inc, >	Increases the cell value by a number used as a percentage. For example, inc6 or 6> increases the cell value by 6%.
   Decrease, Dec, <	Decreases the cell value by a number used as a percentage. For example, Dec6 or 6< decreases the cell value by 6%.
   Hold, Hol	Holds the cell value from data spreads.
   Release, Rel	Releases held cells.
   Multiply, Mul	Multiplies the cell value by a number. For example, Mul50 multiplies each cell value by 50.
   Divide, Div	Divides each cell value by a number. For example, Div50 divides each cell value by 50.
   Grow	Applies compound growth to the percentage that you enter. For example, Grow5 adds 5% to every member in a dimension.
   Power, Pow	Raises the number of one cell to the power that you enter. For example, the number in the cell is 10. Entering Pow3 raises 10 to 1000.
   >	Copies the value to the right to all child items, or leaves, of the consolidation or only to those child items that contain non-zero values.
   <	Copies the value to the left to all child items, or leaves, of the consolidation or only to those child items that contain non-zero values.
   |	Copies the value down to all child items, or leaves, of the consolidation or only to those child items that contain non-zero values.
   ^	Copies the value up to all child items, or leaves, of the consolidation or only to those child items that contain non-zero values.
   : ( a colon)	Stops copying.

3. To change the heading for a row or column, select the heading, type in the new name, and press Enter.