Help Topics

Enabling Keep and Remove


You can enable and disable the Keep Only and Remove Only feature by toggling its check box in the Data Options dialog box. When enabled, the Keep Only and Remove Only feature allows you to selectively Keep Only and Remove Only certain members in a grid or chart.

Using the Keep and Remove options on a member that is referenced in an Alphablox calculated member expression will affect the value of that calculated member. For example, if you have a calculated member with the formula:

Variance = Actual - Budget

And you remove the member "Budget," then the resulting Alphablox calculated member "Variance" would show a string indicating the value is missing.

To enable or disable Keep and Remove:

  1. In the Data Options dialog box, check the Enable keep & remove check box. By default, the box is not checked.
  2. Click the OK button to close the dialog box and implement the changes. Click Apply to implement the changes without closing the dialog box.

Related Topics: