About Comments and Unknown Members

Set options to highlight comments and unknown members on an ad hoc sheet, then use the Comment Edit dialog to modify or delete comments and unknown members as you require.

When you are connected to a provider, you can enable options in Smart View that allow you to quickly detect:

• Unknown members on a grid

• Text typed outside the grid; for example, your own notes on a sheet

In Smart View, cells containing these types of text are referred to as comments.

You can set options in Smart View that allow you quickly and easily spot comment cells, including invalid, or unknown, members in the grid or pertinent notes you may have made on a sheet outside of the grid.

For example, in the Vision database, a member named "Total Entities" is renamed "Total Entity." Smart View tracks this change and shows it to you in the sheet if you define a cell style to call out comments. Then, you can quickly note the change and correct it either directly in the grid or by clicking View Comments in the Smart View ribbon and modifying the cell in the Comment Edit dialog.

To call out comments on an ad hoc sheet, open an ad hoc grid and in the Options panel, Formatting tab:

• Select the Use Cell Styles check box
• Set a cell style for Comments

You can then easily identify comment cells on the ad hoc sheet, and further select and work with them in the Comment Edit dialog box.

You can also select the Always show on refresh check box in the Comment Edit dialog box to launch it on each refresh.