In Oracle Analytics Server (OAS), there is a requirement to automate dashboard exports and persist the output to server-side file systems or to NFS, similar to capabilities previously leveraged in OBIEE-based workflows.
Currently, OAS provides the following functionality in the user interface:
- Dashboard (including multiple pages)
- Export to Excel → Export Entire Dashboard
This feature works successfully when executed manually via the browser.
However, there is no equivalent supported mechanism to achieve the same functionality programmatically or through backend services.
Observed limitations:
- Web Services (e.g.,
AnalysisExportViewsService) support exporting only Analysis objects, not Dashboards - Attempting to use a Dashboard or Dashboard Page path results in a “Type mismatch of catalog object” error
- OAS Agents:
- Do not support exporting Dashboards to Excel
- Do not provide any option to persist output directly to a server filesystem
As a result, there is currently no supported method to:
- Export an entire multi-page dashboard to Excel programmatically
- Automate dashboard export via APIs, agents, or scheduler
- Save generated dashboard output directly to a server-side path (e.g., Linux or Windows file system)
Note: This was working in OBIEE 12c, however deprecated in OAS.
