-
OAC Classic Dashboard Page PDF Export with Dynamic Prompts via API / OIC
We have migrated OBIEE dashboards to Oracle Analytics Cloud and need to automate exporting an entire Classic dashboard page as PDF. Our requirement is to: Pass Business Date and Credit Support ID dynamically. Export the complete dashboard page, including multiple analyses and conditional sections. Invoke the export from…
-
Creation an Action Error??
What am I doing wrong here? There is only one selection in the Target Canvas??
-
How to disable "Drill to Attribute/Hierarchy" while keeping the predefined hierarchy drill-down
Hi everyone, We have a Data Visualization workbook using a predefined hierarchy in the Semantic Model. Our requirement is to: Keep the standard hierarchy drill-down enabled, so users can navigate through the predefined hierarchy levels Disable only the "Drill to Attribute/Hierarchy..." option available from the…
-
OAS Act As Functionality Not Working as Expected in DV – Data Security Issue
Hi All, We are using Oracle Analytics Server (OAS) and noticing different behavior with the Act As feature in Classic dashboards vs. DV workbooks. When FullAccessUser acts as RestrictedUser, Classic Answers dashboards work as expected. The user context switches correctly in nqquery.log, and HCM row-level security and data…
-
Geojson file is failing with Creation failed possibly from invalid GeoJSON or invalid storage config
Geojson file is failing with Error Creation failed possibly from invalid GeoJSON or invalid storage config on OAS2026 new dv. We have tried all possbible , also file is correct its getting upload at product support as they say.
-
Can you group tables in OAC
In BIP. I was able to group tables. Is this possible in OAC
-
How to get rid of <empty> in a List Filter?
I creates a parameter "Role Name" and then I put the Role name field in the filter and made a bind to the parameter, When I add the value in the parameter, it works. When I delete it from the parameter it give me <empty> How do I get rid of the <empty>
-
OAS 2026 version response files for install silent mode and upgrade from lower of OAS
Hi Team, Has anyone upgrade OAS system from the 2024 to 2026 version? if yes, could you please share the resposne files. Regards, Chand
-
OBIEE Administration Tool can't import metadata due to failed Teradata connection
Hi, all, I have been struggling with connecting to Teradata in OBIEE Admin tool. I can't import Metadata to the RPD that exists. I am not sure about if it is due to my config of ODBC Teradata is incorrect or anything else? Please find the following errors as attached: Many thanks for your help!
-
Download a Report with One field value (Order Num) Dynamically as file name
We need to download a report with the order number as the file name. In the main report, we have a data action (hyperlink) on each order number. When we click an order number, the linked report is downloaded with the corresponding order details. Currently, the file is downloaded using the report name. We need to download…
-
OAC..How do I create an expression filter to capture MULTIPLE values for a sql create list parameter
I tried the following expression and it blows up when I select more that one value in the list see image
-
Dataset created from DataFlow gets added to a workbook but no fields appear under workbook
-
How to Log Oracle Analytics Publisher Report Parameters in OAS 2026 Log Files
We are using Oracle Analytics Server 2026 with WebLogic Server 14.1.2. Our Account Statement report is accessed through '/xmlpserver'. We need to capture the following details in the OAS/Publisher log files whenever a user runs the report: Username Report name and path Report execution timestamp Account Number From Date To…
-
Workforce analytics in UK healthcare & making the case for OAC
Hi all I work in UK healthcare across 30 hospitals nationwide, and we're currently reviewing our Oracle estate and roadmap. Part of that is deciding whether to make a case for investing further in Oracle Analytics Cloud for workforce reporting, or whether OTBI and our existing tools are enough for now. Our HR data sits in…
-
Deploying OAC workbook to different environment (dev -> test -> prod)
How does everyone handle importing a DV workbook created in a different OAC environment. For example: created workbook in dev, export and then import into test. The connection and dataset also get created with new object id even though they might have already existed in test. If you are trying to reuse datasets and…
-
Manage Blend Data for a Workbook - bug?
Using manage blend data, I'm unable to remove connections between datasets. It seemingly accepts my change to delete all matches but then will reapply the connection after I close the Blend Data window.
-
How to use Textbox filters
If I only do one with one expression filter, it works, but if I put the 2nd parameter with an expression filter, I get no data found???? Why
-
Trying to match grain with TRENDLINE function in simple OAC analysis
I've been trying to add a trend line to my line graph in OAC, and it's driving me bonkers. The graph itself is pretty simple. The X-axis consists of days, one day at a time, that comes from a "load date" on each record. The Y-axis is a count of all the contracts in progress per a given load date. OAC easily constructs a…
-
OAC report compilation time is taking long while connecting to snowflake database.
OAC report compilation time is taking long while connecting to snowflake database. The other area ODW compilation is good.
-
To Avoid the Null or "0" value columns from a Pivot Table View?
Hello Team, While building a Pivot Table view for my report, 2 out of the 4 metric columns contain completely null values. I'm looking for a way to automatically exclude or hide metric columns whenever they are entirely null or zero. Could you please advise on how to achieve this? Thanks.
-
Auditlog for Oracle Analytics objects in OAS
Hi! I am looking for audit logging for Analytics objects, such as users creating, modifying, or deleting datasets, dataflows, schedules, etc. The traditional Presentation Services component provides such logging in domains/oas/servers/obips1/logs/auditjson.log, which contains audit information for catalog objects,…
-
How can I resolve this error when I try to index a Local Subject Area?
I'm trying to index a Local Subject Area so I can use it in my AI Agent, however, I keep receiving the generic error below. Request status(500) : error = {"prefix":"DSS","code":50000,"message":"There was an unexpected error while processing this request. Please try again."}
-
Case statements in OAC
it is observed that in OAC while using case statements the output is not expected.For example if we have a case statment like case when table1.column1=table2.column1 then 'yes' else 'No' end as Attribute1 Now if i use this attribute with a fact-amount column attribute 1|| Amount on a report then we dont get the aggregation…
-
How i can check the version of OAS ?
-
Trying to change the data presented in the table by a list of values I created
Once I select that value from the list box Region I created, I want to filter the table by my selection. See the images
-
Generate report of Semantic Model Metadata/Definitions?
Hi, While using OAS or OAC latest version can we generate a report to view complete defition of semantic model/subject area. It helps to document and troubleshoot. thanks
-
OAC RPD joins details Export
I want to export all OAC RPD joins and conditions, is there a way to export or extract joins information. please suggest. Repository documentation doesn't gives joins, if any other way pls suggest.
-
How to populate global country/state/city/postal-code polygon data in DB for Vector Map in OAS 2026?
Hi All, We are working with Oracle Analytics Server (OAS) 2026 and need to implement Vector Map visualization using geospatial polygon data. Our requirement is to display geographic data at multiple levels, such as: Country State/Province City ZIP/Postal Code For example, for the USA we are considering ZCTA (ZIP Code…
-
How to use a textbox field in a dashboard filter
So when I click the apply button, it uses the value . Also. How do I stop the auto populate table when the report opens???? I am in OAC
-
Can a graph derive data from BI if data is incomplete
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…