1. Administering Planning
  2. Managing Sandboxes
  3. How Sandboxes Work with HSP_View and Version Members
  4. The HSP_View Dimension

The HSP_View Dimension

When a cube is enabled for sandboxes, the HSP_View dimension is created with the following members.

  • The BaseData member defines the data intersection when users are working in the base view in a form. When users are not working in a sandbox, data is stored at the intersection of the BaseData member.

  • The SandboxData member stores the data when a user works with data in a sandbox.

  • The ConsolidatedData member is dynamically calculated; it retrieves data from the SandboxData member if it's available. Otherwise, the ConsolidatedData member retrieves data from the BaseData member of the base version.

Note:

  • You can't change the HSP_View dimension or its members. You should not change the order of the HSP_View dimension in Performance Settings. To view Performance Settings, from the Home page, click Navigator Navigator icon, and then under Create and Manage, click Dimensions.

  • In a form, the HSP_View member is fixed on the POV and can't be changed.

  • Aggregations at the top levels of sparse dimensions are not supported in Sandbox view.