-
Try to make an expression filter...ERROR
I made a parameter with letter range values… put it into a dashboard filter. Then I created an expression filter to bind it to my last name column in the table with the image I uploaded here. I am getting the following error??? Invalid Expression. Validation of parameter values failed. A general error has occurred. Message…
-
Trying to put my calculation in a Tile, but I can't????
Here is my calculation CAST(COUNT(SAAR_ID) AS VARCHAR(50)) || ' SAARs pending as of: ' || CAST(CURRENT_TIMESTAMP(5) AS VARCHAR(50))
-
OAS 26 on Premises AI Feature
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
-
OAC Dataset filters in SQL???
In OAC when I am creating a dataset, How can I pass a Filter from the "Dashboard filters to the SQL? I attached a image like it was don in BIP Publisher
-
Syntax error when i add /*+ full(table) */ hint in the evaluate function
I am getting syntax error when im trying to add full table hint in evaluate for an obiee report analysis column. This is the function im adding the below: why isnt the syntax working, what is missing or incorrect here in the function?
-
oas extensions download
we have two seperate environments in air gap… 1- oas 2024 2- oas 2026 developers in both env, required extensions like push button, racing bar, guage…. where to download.
-
Usage Tracking
Hello everyone, We use OBIEE 11.1.1.9, on Oracle Linux. We have set up Usage Tracking. It shows users but it misses some of them. How can I see all users?
-
Cascading Prompts: How to handle Multi-Select in Prompt 2 when filtering by Prompt 1 variable?
Hi everyone, I have a cascading prompt setup in OAS Classic (OBIEE 12c) that works for single selection but fails on multi-selection due to variable formatting. The Setup: Column Prompt 1: "Cost Center" (Multi-select enabled). Sets variable @{COSTCENTER_CONCAT_PROMPT}. Column Prompt 2: "Organizational Unit". Filters its…
-
When OAS 2026 version will be supported with RHEL 10?
As per our review, the RHEL 9 Full Support Phase ends on May 31, 2027. we have a requirement to migrate to RHEL 10. Could you please check with your sales/product team and let us know when RHEL 10 will be supported with the new OAS 2026 version? We would appreciate any available roadmap or tentative timeline for RHEL 10…
-
Total record question
How can you put a total number of records in your oracle OAC table footer
-
Data Flow writing to Dataset tables (July update? Bug?)
We've had some data flows configured to give self-service management over what used to be a complex ETL process. Several of these "broke" recently, generating errors and all kinds of issues. After extensive research, we've found that the option to Save to a Dataset Table used to save the mentioned table as its own dataset.…
-
OAS to OAC schedule report parameters question
So in OAS you put dynamic parameters in the SQL. Create the report and when you go to schedule the report, you select the parameters in the General Tab. So you can use one report and create multiple schedules off one report HOW do you do this in OAC??????
-
Arabic translations in the semantic models presentation layer?
Hi, In OAS after creating Subject Areas now if we need to add Arabic translation for each column then what are the steps? Is there any standard table available in which we can upload or we need to create custom table or if there is any other standard way which I am missing. Thanks
-
Re the Announcement OAC - TLS 1.0 and TLS 1.1 Desupport for Oracle Database Connections [SEP 2026]
Do you know if connections that do not use TLS will be affected by the September 2026 update? Regards, Alison.
-
How do we know how many rows a DF has processed/loaded?
When I look at a DF log, I see the below. No of rows successfully loaded is always 0. Where else can this information be found? "Job Type": "DATAFLOW", "Name": "XXXXX", "Number of Rows Successfully Loaded": "0", "Number of Tasks": "1", "Request Type": "Scheduled", "Status": "Completed" Thanks, Usha
-
error in updating analysis via SOAP in Oracle Analytics server
Hi, i am trying to update direct query analysis in Oracle Analytical server using SOAP. in excel file i have analysis name, old sql, new sql, old connection and new connection. But when i try to write back the analysis or create the backup of it, it is failing. getting below error Probing writeObjects endpoint … ❌…
-
OAS query filter with calculated field. Getting Bulk fetch failed.
have a calculated column that has bit more complex condition formula and i put filter items to use it as filter column that caused the error --Bulk fetch failed. So i put the calculated formula into two separated columns and put filters on them.. it's working now. I am just curious that complicated calculated column (not…
-
Enable Secure OAC Report Embedding with Seamless Authentication and User-Level Data Access
We have a requirement to embed OAC reports within the OCC Marketplace for both Organization and Non-Organization users. Currently, Organization users can access the reports through Oracle Analytics Cloud. However, the requirement is to make these reports available as embedded content within OCC Marketplace. When a user…
-
Siebel CRM 26.x and Oracle Analytics Server 2026 Compatibility Confirmation
Hi Team, I would like to confirm the supported compatibility between Siebel CRM 26.x and Oracle Analytics Server 2026? is it certified ? We currently on the upgrade process to Siebel CRM 26.x with an existing OBIEE environment, and we are evaluating the migration from OBIEE to Oracle Analytics Server 2026. which will be…
-
Alerting Incident Owner of SLO
i want to create automation where every morning automate email goes to owner of incident where slo of there sr or incident is going to breach or already breach we already have data in dashboard i want a automate way where it can pool data from our ohh slo dashboard is there api for it which can be use
-
OAS 2026 DV Workbook Metadata via REST APIs
Hi Oracle Analytics Community, I'm exploring OAS 2026 REST APIs for workbook governance and metadata analysis. For a DV workbook, can the available APIs expose enough metadata to programmatically retrieve: Formulas / calculated measures Filters (workbook & visualization level) Aggregation grain Temporal logic (date fields,…
-
OAS 2026 SSO/SAML Configuration Documentation
Hi Team, We would like to raise an enhancement request for the SSO/SAML configuration guidance for OAS 2026. We have already raised multiple SRs regarding OAS 2026 SSO configuration. However, we are facing difficulties getting the required guidance, as the available documentation does not clearly cover the OAS 2026 SSO…
-
Historical Reporting in OAC
We are planning to archive the Contract and Lease data currently sourced from the External Source as Contract and Lease accounting functions are being migrated to Oracle's CLM and Lease Accounting modules. At this stage, only active and partially closed records are being converted into Oracle and the remaining historical…
-
How are OAC AI Agent tokens charged as AIDP units, and what guardrails control model usage?
Hi everyone, with the July patch changes, could someone clarify how OAC AI Agent tokens are being mapped/used as AIDP units for chargeback purposes? Specifically: What’s the charging model now (e.g., how tokens translate into AIDP units, and what gets counted)? What guardrails are in place (or recommended) to control usage…
-
Oracle EBS responsiblity as Role in BIP reports folder in OAS
Hi, Kindly suggest if in OAS BIP reports we need to apply access security on folder based on Oracle EBS authentication and EBS responsibity need to be folder role so when user will login if he/she will have relevant responsiblity assigned then folder access will be there. My challenge is EBS auth I am able to configure in…
-
Trying to average a calculation row in a table
The difference column is a calculation, and I would like to average that row.
-
Complex filter issue. How do I do this
We are trying to convert our OAS reports to OAC and one of the parameters in the where clause of the report is what I am trying to make in OAC. I created a calculation as follows and I am trying to put it into a filter . The code validates EVALUATE('GREATEST ( TRUNC ( NVL (%1, TO_DATE (''1/1/2013'', ''mm/dd/yyyy'') ) ),…
-
Oracle Analytics Server roadmap for Java 25 certification
Hi Oracle Community, Our product standard is moving toward Java 25 across all components. Could you please share whether Oracle Analytics Server is planned to support and certify Java 25? Specifically, we would appreciate guidance on: The expected OAS release/version that will certify Java 25 The anticipated timeline or…
-
Facts of different granularity and unbalanced hierarchy
Hi gurus, We need to model the following situation in the OBIEE/OAS repository. The main dimensions are RISK and ORGANIZATION. The indicators are the number of EMPLOYEES EXPOSED to risks and the number of EMPLOYEES (STAFF) per node in the ORGANIZATION. The level of granularity is therefore different for these two…
-
Is there a supported method in OAS 2026 to suppress or disable the "Drill to Attribute/Hierarchy"?
Hi Everyone, We're running into a challenge in OAS 2026 with Data Visualization (DV) workbooks embedded in Classic Answers dashboards. Our requirement is to: Allow the embedded DV workbook to respond to Answers dashboard prompts. Prevent users from accessing the "Drill to Attribute/Hierarchy..." option from the right-click…