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 GuideHigh-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.