Actions on data cells

When you click on the data cell in the data table, these actions are available:

Replace Values
This option is only available when you explore your data with the ad-hoc analysis.

Replacing values is similar to writeback, but you can decide how to distribute values in a report according to a variety of rules.

Note: Data is only stored in base elements. If you edit values for a consolidated element directly in the table (manual writeback), then the values are distributed automatically. Equal distribution is used to replace a zero value, whilst weighted distribution is used to replace an existing value.
  1. To replace values in data cells, ensure that writeback is enabled, then right-click the data cell and select Replace Values.
  2. Select one of these methods:
    • Weighted distribution: Distributes the value to the base cells according to their weights.

      You can either select to overwrite, add an absolute amount, or add a percentage amount to the existing value. Depending on your selection, the appropriate field is enabled.

    • Equal distribution: Replaces the value of the target cell and distributes the value equally to base cells.

      You can either select to overwrite, add an absolute amount, or add a percentage amount to the existing value. Depending on your selection, the appropriate field is enabled.

      Note: For the add percentage or add absolute fields in both Weighted distribution and Equal distribution, enter a value and press ENTER. The New value field calculates/shows you the new value.
    • To each leaf: Assigns the value to each base cell.

      Specify the value you want to distribute to each base cell in the New value field.

    • Copy/Copy full: The Copy method copies the base cells from the source cell to the target cell.

      The Copy full method also copies calculated rules.

      Specify the source area.

    • Like/Like full: The like method splashes a new value to a target cell with the same weight specified for the source cell.

      You can overwrite, add an absolute amount, or add a percentage amount to the existing value. Depending on your selection, the appropriate field is enabled.

      The Like full method also copies calculated values.

      Note: For the add percentage or add absolute fields, specify a value and press ENTER. The New value field calculates/shows you the new value. Then, specify the source area.
    • Delete: Deletes all values from the target cell.
    • Source: Here you specify the source cell used to change the value in the target cell.
      Note: This section is only active, when you use these methods: Copy, Copy Full, Like, or Like Full.
    • Target: Here you can see the coordinates of the target cell (the cell from which you opened the Splasher dialog box). The operations to change the value apply to this cell. Changed values are distributed to the base elements according to the mode you select.
Zero Suppression
You can enable zero suppression on rows, columns, or both rows and column. For some types of analysis, zero suppression option on categories, series, or categories and series is available instead.
Note
Additionally, you can add a note to the table cell in ad-hoc analysis. After adding a note, a small triangle in the top right corner of the cell indicates that a note was added. You can edit, view, or delete the note.
This option is only available when you explore your data with the ad-hoc analysis.
View Cell Information
This option is only available when you explore your data with the ad-hoc analysis.

Viewing cell information enables you to see additional information about a specific cell. For example, cell coordinates or, when available, what rules are used to calculate the value in the cell.

Click the data cell and click View Cell Information to see this information:

  • Coordinates: The coordinates of the cube, for example different elements of the cube's dimensions.
  • Rule Info: Displayed only if there is a calculation for the cell. Provides this information:
    • Rule text: Shows a complete rule for the target area and the calculation.
    • Rule description: Shows the name of a rule.
    • Validity range: Shows the level of the calculation. For example, only Base which means that the calculation is done on a base level.
  • Rule References: Displayed only if there is a calculation for the cell. Shows the references used in the cube, for example coordinates of the formula for the calculation.
  • Cell: Provides specific information about the cell.
  • Consolidated Elements Base Count: Shows the number of consolidated elements with their children.
  • Consolidated Elements Hierarchies: Shows the unique names of elements and the dimension name next to it.
  • Base Cells Count: Shows the number of base cells allocated to the cell.

To expand or collapse detailed information in the Cell Information window, select Rows > Expand/Collapse All. You can also expand or collapse individual cell information manually, by clicking the up or down arrow.