Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Could you please provide more details on the use case and clarify which Oracle product/module this request relates to? The term “facility level template view” is not a standard Publisher capability.
-
The current web service definition follows the existing service contract design. If you are experiencing integration issues with a specific client or tool, please share additional details so we can better evaluate the request.
-
This functionality is already supported. You can enable “Send output as URL” at both the instance level and at the individual report level. Please refer to the documentation below for configuration steps:…
-
Can you please provide more details on the exact issue observed after migration (errors, logs, migration method used) so we can properly evaluate this request?
-
Hi, You can achieve it using a Schedule Trigger in the data model. Schedule the job and use schedule trigger SQL that returns a row only on the first business day; if no row is returned, the job instance is automatically skipped.…
-
UI doesn’t offer 'last day/last weekday' scheduling, but you can achieve custom frequency via a Schedule Trigger in the Data Model. If the trigger query returns a row, the job runs; otherwise it skips. Example for running only on the last day of each month: SELECT SYSDATE FROM dual WHERE TRUNC(SYSDATE) = LAST_DAY(SYSDATE);
-
You can try with XSL Stylesheet template and output method="text"; insert form-feed (FF, ASCII 12) between logical pages.
-
Pivot tables in Publisher are limited to 5 row columns in interactive layouts(XPT) due to page width and readability constraints in interactive output. Expanding beyond this affects usability and layout rendering. For interactive exploration, use OBIEE/OAC analysis pivot views instead. For larger printable crosstabs, use…
-
The “Maximum allowable nested table row count” property is documented. See Excel Output Properties in the Oracle docs. Also, check Doc ID 2813802.1 for details on increasing export limits greater than 20,000 rows.
-
There isn’t a one-step “overwrite” flag in BI Publisher web services. This is by design to protect catalog integrity(to prevent accidental loss). The workaround is to first check with objectExists(), then deleteObject() or moveObject() the old file, and finally use uploadObject() to add the new one.
-
Publisher Desktop (Template Builder / Add-in) supports Word 365 64-bit- https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/certification-interoperability.html
-
Also, check - Is It Possible to Get UCM Files in the FND_ATTACHMENTS Tables from BI or a SQL Query? (Doc ID 2781879.1)
-
Interactive Layout already supports frozen headers by default. Scrollable tables maintain headers and totals while scrolling (see Oracle Docs).
-
This is an SVSR (Subledger/General Ledger) functional request, not a BI Publisher feature. Please raise this under the Fusion ERP / Financials (GL) Idea Lab.
-
BI Publisher doesn’t support blackout/run windows natively. Use Schedule Triggers in the Data Model to conditionally allow execution (e.g., only weekdays 8 AM–6 PM). Alternatively, orchestrate via ESS Job Sets or external schedulers to enforce blackout periods.
-
Direct access to scheduler tables isn’t available in Fusion SaaS. Use Scheduler Web Services (SOAP) to retrieve job status/history (see example blog: How to Create Oracle Analytics Publisher(BIP) Report to Monitor Scheduled Report Jobs)
-
Delivery to Object Storage is already available in OAC/OAS; under review for Fusion Publisher. https://community.oracle.com/products/oracleanalytics/discussion/21090/bi-report-bursting-to-object-storage
-
Duplicate of Idea 21090 (Object Storage delivery). Already available in OAC/OAS; under review for Fusion Publisher.
-
yes, you can move Analyses /Dashboards along with publisher objects using BAR files. OAC: use Snapshots (BAR files), with REST APIs available to create/restore/manage them: docs. OAS: use WLST scripting utilities for BAR export/import. docs
-
You are correct in your understanding. REST APIs cover report execution/management and do not support direct upload/download of .xdm catalog objects. There is no deprecation or end-of-life announced for the SOAP CatalogService, and no such plan exists. . These services continue to be supported across all flavors (OAS, OAC)…