Sandboxes and Other Functionality

  • Oracle Smart View for Office:

    • Sandbox functionality is available in Smart View, though you can't create, delete, or publish data from Smart View.

    • In ad hoc analysis, users can see the HSP_View members, which includes sandbox and base data.

    • Selecting the ConsolidatedData member displays the data entered in both the sandbox and the original base data.

    • Sandboxes are supported for Smart Slices, but the HSP_View dimension is hidden.

    • In Planning Admin Extensions, the HSP_View dimension is displayed under Dimensions, but you can't change member properties. Likewise, you can't change the member properties of sandbox Version members.

  • Financial Reporting: To report on base view data, select the BaseData member of the HSP_View dimension. To report on sandbox data, select the ConsolidatedData member for HSP_View.

  • Data Management: The HSP_View dimension is visible in the mappings, but you can map only the BaseData member.

  • Migration: If you clone an application using Migration, Oracle recommends that you select the Sandbox Changes option. If you're importing sandboxes and data, you must select Sandbox Changes if you want to publish the sandbox data.

  • Oracle Hyperion Public Sector Planning and Budgeting: Decision Packages and Budget Requests don't support sandboxes.