OnCommand Insight

Restoring custom Data Warehouse reports


If applicable, you can manually restore any custom reports you backed up before the upgrade; however, you only need to do this if you lose reports of if they have become corrupted.


  1. Open your report with a text editor, and then select and copy its contents.

  2. Log in to the Reporting portal at https://fqdn/reporting.

  3. On the Data Warehouse toolbar, click oci reporting portal icon to open the Insight Reporting portal.

  4. From the Launch menu, select Report Studio.

  5. Select any package.

    Report Studio displays.

  6. Click Create new.

  7. Select List.

  8. From the Tools menu, select Open Report from Clipboard.

    The Open Report from Clipboard dialog box displays.

  9. From the File menu, select Save As and save the report to the Custom Reports folder.

  10. Open the report to verify that it was imported.

    Repeat this task for each report.


    You may see an “Expression parsing error” when you load a report. This means that the query contains a reference to at least one object that does not exist, which means there is no package selected in the Source window to validate the report against. In this case, right-click on a data mart dimension in the Source window, select Report Package, and then select the package associated with the report (for example, the inventory package if it is an inventory report or one of the performance packages if it’s a performance report) so Report Studio can validate it and then you can save it.