Topics Map > University of Chicago > IT Services > Business Systems > Budget Planning & Mgmt > Delphi

Budget Planning and Management - Delphi Planning - How to get rid of #Missing or #NoAccess

This article explains how to get rid of #Missing or #NoAccess entries in Smart View.

This article explains how to get rid of #Missing or #NoAccess entries in Smart View.

When data is missing or you don't have access to a given intersection of dimensions, cells display the value #Missing or #NoAccess. You have a few options for handling these values.

Change the Default Replacement Value

  1. On the Smart View ribbon tab, click Options in the General group.
  2. In the Options window, click Data Options.
  3. Select a new value from the list (we recommend a dash), or type your own value.

Change POV Members

To change your selected intersections, select new point-of-view members.

Change #Missing or #No Access Entries for a Range

If an entire row or column contains these values, you can hide the column or row.

  1. On the Smart View ribbon tab, click Options in the General group.
  2. In the Options window, click Data Options.
  3. Select the Suppress Row or Suppress Column options you need to suppress the unwanted range. Note that the No data/Missing option is already selected by default in the Suppress Rows group.



Keywords:Hyperion, UCSAL, UCBUD, Budget_Office, Executive, workspace, SmartView   Doc ID:29495
Owner:Levita G.Group:University of Chicago
Created:2013-04-16 12:16 CDTUpdated:2017-03-04 20:15 CDT
Sites:University of Chicago, University of Chicago - Sandbox
Feedback:  0   0