-
Why isn't there a search capability in the forum?
Am I missing something or is there no way to search through previous posts to make sure I don't duplicate a question? All I see on the filter options are tags or status… a general search for a word or phrase would be helpful.
-
OAS 2025: Publishing OAS/DV Datasets to Power BI While Maintaining RAS and Application Role Security
We are running Oracle Analytics Server (OAS) 2025 with an RPD-based semantic model. Security is implemented using Application Roles, Row-Level Security (RAS/Data Filters), and session-variable based access controls. Our business users want to use Power BI for self-service reporting. We currently have access to a…
-
Why aren't hidden columns in DV pivot table exporting in CSV format?
We were under the impression that when exporting a visualization in DV to CSV format hidden columns would be include from the grammar panel. This is not happening. See below for a screenshot showing 3 hidden columns that do not appear when exporting the pivot table to CSV. This seems to have worked a month or so back but…
-
How to change legend title
There is no option for legend title in many visualization types.
-
Failed to save the connection. Internal Error on Windows 11
-
nQSError:46029 Failed to load the DLL /<MW_HOME>/bi/bifoundation/server/bin/libnqsdbgatewayoci10g64.
Migrated RPD from obiee12c to OAS 2024. post migration when we try to access dashboards on OAS we are getting below error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS…
-
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 ?