-
Compare values for same parameter,attribute in OAC
I have three columns: parameter, attribute, and timestamp in dataset. If the parameter and attribute are the same but the values differ across timestamps, I want to create a table that shows this difference and highlights it. The table should look like this: parameter | attribute | timestamp1 | timestamp2 How can I achieve…
-
Extract JSON fields from column of csv for filtering in OAC
Use Case: I have a CSV file with multiple columns, and one of the columns is called metadata, which contains JSON values like: {'Architecture': 'x64', 'Vendor': 'One', 'DB Version': None}. I want to extract each of these values like Architecture, Vendor, and DB Version so I can use them individually as filters or in…
-
displaying Graph Title on the center of obiee report
Hi All, I have created the graph view with the Title on the top of graph. I am trying to display the graph Title in the center of report but can't find anything in Titles and Labels option to display the graph in the center of report. Any ideas would be much appreciated. Thanks Raj
-
OAC-HFM on Premise Integration Query
Hello OAC Community, I'm exploring integration options between Oracle Analytics Cloud Data Visualization and on-premises Hyperion Financial Management (HFM) and would appreciate insights on the following: 1. Direct OAC DV to HFM Connectivity: Can Oracle Analytics Cloud Data Visualization establish a live connection…
-
Mapviewer TCPS connection
Hello Is there a way from Mapviewer in OAC to connect to a non-Autonomous database using a wallet? Our data warehouse dba's are requiring TCPS connections to the db going forward which requires a wallet. All the documentation I've been reading is point your wallet file to /home on your local server or some local folder.…
-
OACS Gen2 fires two queries for a report/analysis, one for rendering and one for download
Hi Team, OACS Gen2 fires two queries for a report/analysis, one for rendering and one for download while On-Prem OBIEE fires only one query for both (rendering and download). This is not acceptable from business users. For ex. in On-Prem OBIEE, if there is an analysis which takes 15 minutes to render the report but while…
-
Self Replacing Data in Data Flow
Hi , I am looking to implement a manual tracker for one of ongoing project. There is a time-series information that I would be manually upload to the system on a frequency basis Basically Ive created a dataflow that look like below The idea is that I run the query on the frequency basis to update the table. However Ive…
-
"Upgrading" from OAM/OID to IAM problem with administrators in OAS.
We are on OAS 2024 and have swapped out OAM/OID to IAM. This has worked pretty well, but our administrative users have effectively lost their powers. This is due to faults that happen unless OID is running (which is our current solution). For example, I am unable to create a dataset, run data flows or create connections as…
-
Governance Plugin V2 not working in OAS 2024
We’re currently using OAS 2024 and have been trying to work with the new Governance plugin in DV. While the plugin downloads successfully, the icon does not appear in the interface. Has anyone using OAS 2024 been able to get this plugin working? It’s starting to seem like the plugin might be intended for OAC only.
-
Track time in PPM - Project Funding Subject Area?
I am trying to recreate one OTBI report in OAC. In OTBI Under the subject area 'Projects - Cross Subject Area Analysis - Real time' I can see Track time under Project Team member But I am not able to see this column (track time) under PPM- Project Funding in OAC Where I can find the Track time record in the subject area…
-
Only Latest Deployed Semantic Model Visible in OAC
Hi, I have deployed multiple semantic models in Oracle Analytics Cloud, each under a different name. However, I am currently able to access only the most recently deployed model, while the earlier models are not appearing in the interface. Thanks, Jay
-
How to know Report Name via Usage Tracking
Hi Team, We already do have usage tracking in OAC. But wanted to understand - how to know exact report name used by User. Can it be viewable through Usage tracking, let me know. Thanks Saroj
-
I'm new to BICC - any PVO advice?
I hope this is the right community. I couldn't find one specific to BICC. My background is in integration platforms such as OIC and BizTalk, so working with the Fusion & Oracle ERP Cloud data structures is new to me. We have just started a project utilizing this BICC, and while I find the tool itself fairly…
-
Visualizer Plugin Support - What's the official support capacity / agreement from Oracle?
Hello, Can someone tell me where Oracle stands with supporting the Visualizer Plugins? My current understanding is that it's purely community based and in the hands of the contributor / plugin creator ? Is there the concept of certifying / supporting certain plugins? Similar to the way "Competitors" do it? This question is…
-
Datasets Dependency analysis
Hello, We have multiple workbooks using the same datasets. Is there a way for us to know from a dataset which workbooks are leveraging this? This will help us to ensure all the workbooks are working fine when we make a change to the dataset. Also Is there a way to get a summarized access roles on FDI reports ? Eg what…
-
Export full workbook as image.
Currently export as image exports only area displayed on screen only. But I want image with scrolled down images as well. It means all visualizations in the workbook. Appreciated any suggestions.
-
Activity logs for Mail Settings and Remote Data Connectivity
Hello, In the OAC console, we see these two tiles. My customer wants to keep track of the activity that goes on within each of these. For example, for Mail Settings, they like to maintain a history of who is creating/changing/deleting mail settings, and what the settings are. Similarly, for Remote Data Connectivity, they…
-
Help with Embedding Oracle Analytics Server Without Authentication (Login)
Hello, I'm working on a project using Oracle Analytics Server (OAS) version 12.2.1.0 (2025), and my main goal is to embed a dashboard into an external system without requiring the user to log in manually. What I’ve done so far: The dashboard is already created and working properly within Oracle Analytics. I’ve configured…
-
Application Roles in Table
Hi All, are the application roles stored in any table by OAC by default. we like to know if custom and OOTB App roles stored in any tables, please share the table name and schema name. thank you
-
Oracle DV background color in column header in Pivot Table
I've figured out how to change the colors of columns in Oracle Data Visualization. In Classic Pivot reports I can make the header row a different color than the background of the column. I can't find out to do this in DV. Screenshot above is DV, below is Classic Pivot.
-
When embedding a workbook using iFrame, I get for a sec. a headerbar with back button->security risk
When embedding a workbook in an external website using the iFrame method, I see for 1-2 seconds a header bar with a back button a the left side, before the workbook is rendered. This happens despite of the fact that the header is turned off in the workbook. During this short period of time the user can press the back…
-
OAC-Semantic Model -Cutom/ManualQuery
Hii OCA Community…..In direct dataset creation there is option for Manual/custom query . But in Semantics model ,we couldn't find this option .Can anyone pls advise how to create tables using Manual/Custom query in Semantics Model .Thank you.
-
Catalog folder level security OAS 2024
Hi All, we have built a new environment. I have 6 folders, and 4 application Roles as of now Role1 - BIcontentAuthor role mapped Role2 - Bi consumer role mapped Role3 - BIcontentAuthor role mapped Role4 - BI consumer role is mapped Folder1 - Read & Write for Role1 and Consumer access to Role2 Folder2 - Read & Write for…
-
OAS Mobile Application Usage
Hello everybody, I am looking for a clear document that guides me to use mobile 'Oracle Analytics' application in IOS and android in for my company. When I look at the youtube or google, I really could not find any specific helpful guides. Firstly, is it possible to use mobile app for OAS Version 2024. If it is, can you…
-
configure Multiple OAS instance with OHS
Hello All, Could you please suggest the configuration changes to OHS (Webapp1 instance) for 2nd OAS instance (APPHOST2), so that when the oas instance1 down then ohs to route 2nd OAS instance (APPHOST2). what are all the places I have to add Apphostname2 and list of ports Thank you, NR
-
Agent / reports always hung except right after BI bounce
Hello, when we try to run Agent / reports always hung, except right after BI bounce. this is OBIEE 11.1.1.9, but the logs are clean. nothing changed for many months. since the logs are clean, most of the resources on both DB and application are idle at all the time, does any one know why they hung? why it is only ok right…
-
Designing a Pill shaped chart in OAS (v 6.4)
Hello, I am trying to design a Pill shaped chart in OAS. I am using OAS 6.4. I was able to achieve something close using the inbuilt gauge view but it was not accepted. the chart needs to be similar to how a brightness pill looks on a smartphone. Any ideas or help as to how to achieve it will be very helpful. Thanks in…
-
Would it be possible to format the font and background color of Oracle Analytics' canvas?
Would it be possible to format the font and background color of Oracle Analytics' canvas name? As we can notice below, I only notice the style and AutoHide options. I am unable to find a way to update the font and background of word "Canvas 1" Regards.
-
How do I modify an IKM in ODI 12c to prevent duplicates in a target table?
Hi everyone, I was practicing ODI 12c and I came across this problem: I have a mapping in ODI 12c that inserts the data from a staging table into a staging history table. The logical diagram is: source: staging table -> FILTER -> EXPRESSION -> target: staging history table In the physical tab of the mapping, I set:…
-
Is there a better way to filter measures by attributes other than the 'FILTER' SQL function
I ahve found the FILTER function in DV to be very buggy, is there any other function I can use. Example: (Filter("VRM - Auction Sales"."Measures"."Sold Value (Net) % of CAP Black" using "VRM - Auction Sales"."Agreement - Current"."Termination Reason" = 'Mechanical Failure') When the above measures isnt in the table the CAP…
