1. Administering Migration for Oracle Enterprise Performance Management Cloud
  2. Migrating On-Premises Applications to EPM Cloud
  3. Step 2: Migrate Artifacts from the On-Premises Deployment to EPM Cloud
  4. Migrate Planning to Planning
  5. Migrate Essbase Artifacts
  6. Migrating Report Scripts

Migrating Report Scripts

A report script is used to export data from Oracle Essbase. Existing on-premises Essbase report scripts can be converted to Oracle Smart View for Office smart queries, which you can use for ad hoc reporting and analysis.

Note:

For detailed procedures, see Creating a Smart Query in Oracle Smart View for Office User's Guide

High-level steps involved in creating smart queries in place of Essbase report scripts :

  • Move the members referenced in <ROW in the report script to the row layout of query

  • Move the member selection under <COLUMN in report script to column layout of query

  • Pick the POV members in query that are in <PAGE in report script

  • Specify any suppress options that are in the report script, for example, SUPMISSINGROWS, SUPEMPTYROWS, using Options in the Advanced Options menu.

  • Apply data format options in report script using SmartView data format, cell style or formatting options available in Microsoft Excel.