-
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…
-
What can cause a scheduled report not being delivered by email even if the agent is run successfully
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
-
Not able to find the documentation on Extension development
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
-
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