Display Settings

This property enables you to update the display settings in these tabs:

  • Information
  • Grid
  • Chart

Information

This tab shows the options to display windows for filters, charts, additional key information, and pictures.

You can update these options:

  • Show Fast Filter enables the fast filter for the view.
  • Show Split Chart enables the split chart for the view.
  • Show Key Information enables the Key information. See Key Information.
  • Show Picture enables the Picture. For example product, brand logo, or location pictures.
  • View Icon enables a custom icon for the view.
  • View Menu configures a custom action menu for the view to execute Drill to view, Open view, Open or Execute Workflow, and Run Scripts.

Grid

This tab shows the options to control additional columns and the behavior of grids.

You can update these options:

  • Show Total columns displays a Total sum column for the entire period range for each measure.
  • Show only Total columns hides the period columns so only the Total columns are visible.
  • Show Total Pct column displays a relative percentage for the group levels of the total columns
  • Expand details opens the view with the group levels expanded to the detailed level.
  • Auto size columns width causes data column width to auto size. This operation takes a longer time for large number of rows and columns in the grid. You can do an alternative manual or on-the-fly auto size in the grid by double-clicking or Left Shift + double-click for more precise sizing in the group area.
  • Auto update time series functions when data is changed in the grid, all calculated column gets recalculated. Since time series function causes everything to recalculate, you can disable this option to save time with many changes. You can manually trigger time series recalculation by clicking the red exclamation point in the lower right corner.
  • Hatch read-only cells controls whether the read-only cells are hatched or not. This feature is enabled by default. You can disable hatching the read-only cells in the grid using this feature.
  • Hatch and color changes at Group level marks the changes in the data with a background color so it is easier to see what data has been changed. If the feature is enabled, the updated background color propagates through all group levels. You can disable the feature to speed up the grid when large number of columns and rows exists.
  • Show Calculated Seasonality Index displays the calculated season index when forecast is being recalculated. When grid is first loaded, this column is empty. The feature is available to give a visual representation of that seasonal index being applied by the forecast method.
  • Show outline window displays the Outline window. This is a floating window that allows you to see all the key columns including hidden columns and some additional information like the product picture, key information, and so on. The button panel in the grid can enable or disable the Outline window.
  • Colorize periods in grid header

Chart

This tab shows the options that you can apply to the chart.

You can update these options:

  • Show Auto Year bars displays the year levels as bar when the year is a group level.
  • Show Random Series colors enables a new series color for each series selected. Normally, the series colors are determined by the measure. This is helpful when comparing different product by CTRL + click multiple lines. For example, at group level.